Microsoft Office Essentials 5 Sections62 Lessons25 Quizzes1 Week
Curriculum
- 5 Sections
- 62 Lessons
- 1 Week
Expand all sectionsCollapse all sections
- 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)
Lab 5.4 Collaboration in a shared document
Prev
