Microsoft Office Essentials is a 40 hour, self-paced online course that builds the software fluency every Canadian office job assumes you already have. Over five structured study days you learn to organize and protect files in Windows and OneDrive, produce correctly formatted documents in Word, build and audit working spreadsheets in Excel, design and deliver presentations in PowerPoint, and run a professional mailbox, calendar and shared workspace in Outlook, Teams and SharePoint.
The course is written in an institutional, textbook register and grounded in named sources: Microsoft Learn and Microsoft 365 product documentation, the Microsoft Office Specialist certification objectives, the Web Content Accessibility Guidelines published by the World Wide Web Consortium, Ontario accessibility law, and the Government of Canada Job Bank profiles for the administrative occupations these skills serve.
Twenty-five core lessons, five on each study day, each with its own five question quiz, are supported by fourteen purpose-drawn diagrams, selected free video viewing, a daily set of Canadian practice notes, instructor-graded laboratory exercises in the real applications, and a capstone project that produces a four-document portfolio piece.
No software purchase is required. Every laboratory exercise in this course can be completed with the free web versions of Word, Excel, PowerPoint and Outlook at office.com using a free Microsoft account. Where a task needs the installed desktop application, the lesson says so and gives the web alternative.
This course is a short-term preview of ERICC’s office-based diploma programs, including Medical Office Administrator and Payroll and Accounting Administrator. Entry-level roles in this field are posted in Canada under National Occupational Classification code 13110, administrative assistants, and code 14100, general office support workers, both searchable on the Government of Canada Job Bank.
Curriculum
- 5 Sections
- 62 Lessons
- 1 Week
- DAY 1: Windows, Files and Cloud Storage17 Items
- 1.1Lesson 1.1: Files, Folders and the Windows Desktop
- 1.2Quiz 1.10 Questions
- 1.3Lesson 1.2: OneDrive, Autosave and Version History
- 1.4Quiz 1.20 Questions
- 1.5Lesson 1.3: Finding Work Fast, Search and Records Discipline
- 1.6Quiz 1.30 Questions
- 1.7Lesson 1.4: File Formats, Compatibility and Safe Conversion
- 1.8Quiz 1.40 Questions
- 1.9Lesson 1.5: Backup, File Recovery and Document Security
- 1.10Quiz 1.50 Questions
- 1.11How to Use Microsoft OneDrive, Complete Tutorial for Beginners
- 1.12Complete File Sharing in Microsoft 365, OneDrive, Outlook, Teams and SharePoint
- 1.13Canada-specific details the videos don’t give you
- 1.14Lab 1.1 Build your professional folder system
- 1.15Lab 1.2 OneDrive versions, sharing and recovery
- 1.16Lab 1.3 Rename rescue and format triage
- 1.17Lab 1.4 Backup and protection audit
- DAY 2: Word and Professional Documents17 Items
- 2.1Lesson 2.1: Styles and the Structured Document
- 2.2Quiz 2.10 Questions
- 2.3Lesson 2.2: Business Document Anatomy, Tables and Page Setup
- 2.4Quiz 2.20 Questions
- 2.5Lesson 2.3: Templates, Reusable Content and Mail Merge
- 2.6Quiz 2.30 Questions
- 2.7Lesson 2.4: Track Changes, Comments and the Review Cycle
- 2.8Quiz 2.40 Questions
- 2.9Lesson 2.5: Accessible Documents, Ontario Obligations and Export
- 2.10Quiz 2.50 Questions
- 2.11Microsoft Word Tutorial
- 2.12How to Mail Merge in Word, Excel and Outlook
- 2.13Canada-specific details the videos don’t give you
- 2.14Lab 2.1 The business letter, built with styles
- 2.15Lab 2.2 The quotation table
- 2.16Lab 2.3 Template and merge-ready data
- 2.17Lab 2.4 The review cycle and the clean release
- DAY 3: Excel, Formulas and Data Analysis18 Items
- 3.1Lesson 3.1: Cells, Formulas and the Core Functions
- 3.2Quiz 3.10 Questions
- 3.3Lesson 3.2: Cell References, Logical Functions and Auditing a Worksheet
- 3.4Quiz 3.20 Questions
- 3.5Lesson 3.3: Data Hygiene, Excel Tables, Sorting and Filtering
- 3.6Quiz 3.30 Questions
- 3.7Lesson 3.4: Lookup Functions and Combining Data Sets
- 3.8Quiz 3.40 Questions
- 3.9Lesson 3.5: PivotTables, Charts and Reporting
- 3.10Quiz 3.50 Questions
- 3.11Excel Tutorial for Beginners
- 3.12Excel Formulas and Functions, Tutorial for Beginners
- 3.13How to Use Excel for Beginners in 10 Minutes
- 3.14Canada-specific details the videos don’t give you
- 3.15Lab 3.1 The twelve month budget, built to be audited
- 3.16Lab 3.2 Data cleaning and validation
- 3.17Lab 3.3 Joining two lists with a lookup
- 3.18Lab 3.4 From transactions to a report
- DAY 4: PowerPoint and Presenting with Evidence17 Items
- 4.1Lesson 4.1: The Slide as a Unit of Communication
- 4.2Quiz 4.10 Questions
- 4.3Lesson 4.2: Deck Structure and Design Surgery
- 4.4Quiz 4.20 Questions
- 4.5Lesson 4.3: Slide Master, Layouts and Consistency at Scale
- 4.6Quiz 4.30 Questions
- 4.7Lesson 4.4: Evidence on Slides, Charts, Tables and Images
- 4.8Quiz 4.40 Questions
- 4.9Lesson 4.5: Delivering the Deck and Making It Accessible
- 4.10Quiz 4.50 Questions
- 4.11PowerPoint Tutorial for Beginners
- 4.12Slide Master, design and delivery, recommended viewing
- 4.13Canada-specific details the videos don’t give you
- 4.14Lab 4.1 The five slide deck from a brief
- 4.15Lab 4.2 Design surgery on a bad slide
- 4.16Lab 4.3 Build a template on the Slide Master
- 4.17Lab 4.4 Rehearse and deliver
- DAY 5: Outlook, Teams and Working Together18 Items
- 5.1Lesson 5.1: Professional Email, Anatomy and Conventions
- 5.2Quiz 5.10 Questions
- 5.3Lesson 5.2: Inbox Triage, Folders, Rules and Automation
- 5.4Quiz 5.20 Questions
- 5.5Lesson 5.3: Calendar Management and Meeting Discipline
- 5.6Quiz 5.30 Questions
- 5.7Lesson 5.4: Teams and SharePoint, Channels, Chat and Co-authoring
- 5.8Quiz 5.40 Questions
- 5.9Lesson 5.5: Working the Suite Together and Your Next Credential
- 5.10Quiz 5.50 Questions
- 5.11Microsoft Outlook Tutorial for Beginners
- 5.12Microsoft Teams Tutorial in 10 min
- 5.13Canada-specific details the videos don’t give you
- 5.14Lab 5.1 Email rewrites and the channel decision
- 5.15Lab 5.2 Build a working mailbox
- 5.16Lab 5.3 Calendar, invitations and delegation
- 5.17Lab 5.4 Collaboration in a shared document
- 5.18Lab 5.5 The Office Pack (Capstone)





