About this course
This course develops the Microsoft Office and workplace productivity skills used across businesses, government, NGOs and professional environments. Learners work with Microsoft 365 file workflows before developing strong Word skills for professional documents. Excel receives special focus, covering formulas, functions, data management, charts, PivotTables, dashboards and practical business reporting. The course also includes PowerPoint presentations, Outlook email and calendar management, Teams collaboration, OneDrive, SharePoint basics, Forms, task tools, PDFs and integrated digital workflows. A final project brings several applications together so learners practice completing realistic workplace tasks rather than learning each tool in isolation.
What you will learn
- Create and format professional documents in Microsoft Word. - Use Excel formulas, functions, tables, validation and data-management tools. - Analyze data with charts, PivotTables and simple dashboards. - Create clear and professional PowerPoint presentations. - Manage email, calendars, meetings and follow-up using Outlook. - Collaborate through Teams, OneDrive and shared Microsoft 365 files. - Use common workplace tools such as Forms, task management and PDFs. - Complete an integrated office workflow using multiple applications.
Course contents
Section 1
Module 1: Microsoft 365 & Workplace File Workflows
- Lesson 1.1: Understanding Microsoft 365, Office Apps & Workplace Accountslesson
- Lesson 1.2: Desktop Apps vs. Web Apps vs. Mobile Appslesson
- Lesson 1.3: Creating, Opening, Saving & Recovering Office Fileslesson
- Lesson 1.4: OneDrive Basics: Sync, Access & File Availabilitylesson
- Lesson 1.5: Sharing Files, Permissions & Version Historylesson
- Lesson 1.6: File Naming, Folder Structures & Document Version Controllesson
Section 2
Module 2: Microsoft Word — Documents & Formatting
- Lesson 2.1: Word Interface, Navigation & Document Setuplesson
- Lesson 2.2: Text Entry, Selection, Fonts, Paragraphs & Alignmentlesson
- Lesson 2.3: Lists, Tabs, Indents, Spacing & Page Breakslesson
- Lesson 2.4: Page Layout: Margins, Orientation, Size & Columnslesson
- Lesson 2.5: Tables, Pictures, Shapes & Text Boxeslesson
- Lesson 2.6: Headers, Footers, Page Numbers & Basic Document Polishlesson
- Lesson 2.7: Printing, Exporting & Creating PDF Documentslesson
Section 3
Module 3: Microsoft Word — Professional & Business Documents
- Lesson 3.1: Styles, Themes & Consistent Document Formattinglesson
- Lesson 3.2: Business Letters, Reports, Proposals & Meeting Documentslesson
- Lesson 3.3: Templates & Reusable Document Structureslesson
- Lesson 3.4: Find/Replace, Navigation Pane & Long-Document Organizationlesson
- Lesson 3.5: Tables of Contents, Captions & Basic Referenceslesson
- Lesson 3.6: Reviewing, Comments, Track Changes & Co-Authoringlesson
- Lesson 3.7: Mail Merge for Letters, Labels & Personalized Documentslesson
Section 4
Module 4: Microsoft Excel — Foundations
- Lesson 4.1: Workbooks, Worksheets, Cells, Rows, Columns & Rangeslesson
- Lesson 4.2: Entering, Editing & Formatting Data Correctlylesson
- Lesson 4.3: Basic Formulas & Order of Operationslesson
- Lesson 4.4: Relative, Absolute & Mixed Cell Referenceslesson
- Lesson 4.5: Essential Functions: SUM, AVERAGE, MIN, MAX & COUNTlesson
- Lesson 4.6: Number, Currency, Percentage & Date Formattinglesson
- Lesson 4.7: Practical Worksheet Design & Printinglesson
Section 5
Module 5: Microsoft Excel — Functions & Data Management
- Lesson 5.1: Logical Functions: IF, AND & ORlesson
- Lesson 5.2: Conditional Calculations: SUMIF/S, COUNTIF/S & AVERAGEIF/Slesson
- Lesson 5.3: Lookup Functions: XLOOKUP and Practical Lookup Conceptslesson
- Lesson 5.4: Text Functions for Cleaning & Combining Datalesson
- Lesson 5.5: Date & Time Functions for Workplace Recordslesson
- Lesson 5.6: Sorting, Filtering & Working with Excel Tableslesson
- Lesson 5.7: Data Validation, Drop-Down Lists & Conditional Formattinglesson
Section 6
Module 6: Microsoft Excel — Analysis, Reports & Dashboards
- Lesson 6.1: Preparing and Cleaning Data for Analysislesson
- Lesson 6.2: Creating Charts & Choosing the Right Visualizationlesson
- Lesson 6.3: PivotTables for Fast Summary & Analysislesson
- Lesson 6.4: PivotCharts, Slicers & Interactive Reportinglesson
- Lesson 6.5: Building Simple KPI Reports & Dashboardslesson
- Lesson 6.6: Budget, Sales, Inventory & Attendance Reporting Exampleslesson
- Lesson 6.7: Checking Formulas, Preventing Errors & Presenting Results Clearlylesson
Section 7
Module 7: Microsoft PowerPoint — Presentations That Communicate
- Lesson 7.1: Planning a Presentation Before Designing Slideslesson
- Lesson 7.2: Slide Layouts, Themes, Fonts, Color & Visual Hierarchylesson
- Lesson 7.3: Working with Images, Icons, Shapes, Tables & Chartslesson
- Lesson 7.4: Smart Use of Transitions, Animations & Multimedialesson
- Lesson 7.5: Speaker Notes, Presenter View & Rehearsallesson
- Lesson 7.6: Designing Business, Training & Project Presentationslesson
- Lesson 7.7: Exporting, Sharing, Recording & Delivering Presentationslesson
Section 8
Module 8: Outlook — Email, Calendar & Personal Organization
- Lesson 8.1: Managing Professional Email Efficientlylesson
- Lesson 8.2: Search, Folders, Categories, Flags & Ruleslesson
- Lesson 8.3: Contacts, Distribution Lists & Address Bookslesson
- Lesson 8.4: Calendar, Meetings, Availability & Recurring Eventslesson
- Lesson 8.5: Tasks, Follow-Ups & Personal Productivitylesson
- Lesson 8.6: Email Security, Attachments & Professional Etiquettelesson
Section 9
Module 9: Teams, OneDrive & Collaborative Work
- Lesson 9.1: Teams Chat, Channels & Team Workspaceslesson
- Lesson 9.2: Online Meetings, Screen Sharing & Meeting Controlslesson
- Lesson 9.3: Sharing and Co-Editing Office Files in Teamslesson
- Lesson 9.4: OneDrive Sharing, Sync & Version History in Practicelesson
- Lesson 9.5: SharePoint Basics: Team Files, Sites & Shared Informationlesson
- Lesson 9.6: Permissions, Collaboration Habits & Avoiding Version Confusionlesson
Section 10
Module 10: Workplace Productivity Tools & Integrated Project
- Lesson 10.1: OneNote for Notes, Knowledge & Meeting Recordslesson
- Lesson 10.2: Microsoft Forms for Surveys, Registrations & Data Collectionlesson
- Lesson 10.3: Planner/Task Tools for Team Work & Follow-Uplesson
- Lesson 10.4: Converting, Combining, Signing & Managing PDF Fileslesson
- Lesson 10.5: Scanning, OCR Concepts & Digital Document Workflowslesson
- Lesson 10.6: Integrated Office Workflow: From Data to Report to Presentationlesson
- Lesson 10.7: Capstone: Complete a Realistic Workplace Productivity Projectlesson