Microsoft Office
This comprehensive 12-hour workshop series is designed to equip participants with essential skills in Microsoft Office applications – PowerPoint, Word, and Excel. Each application will be explored thoroughly, covering basic functionalities, advanced features, and practical applications in professional settings. Through a combination of lectures, hands-on exercises, and real-world examples, participants will gain proficiency in creating, formatting, collaborating, and finalizing documents, presentations, and spreadsheets using Microsoft Office.
- Online
- 12 hours
- Certificate of completion
Why This Course? & Who Should Attend?
Why This Course?
It’s not just about learning tools but understanding how to use them effectively. Hands-on examples, step-by-step guidance, and practice ensure confidence. Includes reference materials and sample scripts.
Who Should Attend?
Perfect for IT enthusiasts, junior admins, developers needing Windows skills, or anyone wanting to boost technical expertise. No advanced knowledge required.
Details at a Glance
Total Time
12 hours (8 sessions x 1.5 hours)
Requirements
Laptop/desktop with admin access, VMware software, and Zoom for live sessions.
USB Drive
A 64GB USB drive is required for practice exercises.
Course Content
PowerPoint Basics and Design Principles (4 hours):
- Introduce participants to PowerPoint and teach basic creation, formatting, and design principles.
- Provide an overview of the PowerPoint interface and navigation.
- Familiarize participants with fundamental design principles for creating visually appealing presentations.
Microsoft Word Basics and Document Organization (4 hours):
- Cover the basics of creating, formatting, organizing, and citing in Microsoft Word.
- Guide participants through essential Word functionalities such as text formatting, inserting images, and organizing content.
- Teach participants how to effectively organize documents using headings, lists, and tables, and how to add citations and references.
Advanced Formatting, Collaboration, and Finalizing in Microsoft Word (4 hours):
- Cover advanced formatting techniques including styles, templates, and advanced formatting tools.
- Demonstrate collaboration features such as tracking changes and co-authoring documents with colleagues.
- Provide guidance on finalizing documents, including proofreading, formatting for consistency, and preparing for distribution.
Excel Basics and Data Management (4 hours):
- Introduce participants to Excel, focusing on data entry, basic formatting, and data management.
- Cover basic Excel functionalities such as entering data, formatting cells, and managing worksheets.
Advanced Formulas and Functions in Microsoft Excel (4 hours):
- Cover advanced formulas and functions for data analysis and manipulation.
- Teach logical functions (IF, AND, OR), lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH), statistical functions (SUMIF, COUNTIF, AVERAGEIF), and date and time functions.
- Explore data analysis techniques, pivot tables, and data visualization to extract insights from data.