Master Microsoft 365: Essential Skills and Beyond Course

Lesson 1 • Managing Files with OneDrive

Introduces OneDrive as the central file hub for storing, organizing, and sharing documents. Establishes cloud-file habits critical for collaboration chapters ahead.

Lesson 2 • Setting Up Your Account and Profile

Guides account creation, profile configuration, and security settings. Proper setup ensures seamless access across all subsequent modules.

Lesson 3 • Understanding the Microsoft 365 Ecosystem

Covers the full app portfolio, licensing tiers, and cloud-first architecture. Establishes context for every tool introduced later in the course.

Lesson 4 • Navigating the Microsoft 365 Interface

Explores the app launcher, home dashboard, and common UI patterns shared across apps. Reduces friction when switching between tools throughout the course.

Lesson 1 • Creating and Formatting Documents

Covers document creation, page setup, and core text formatting tools. These fundamentals underpin every document type built in this chapter.

Lesson 2 • Using References and Navigation Tools

Covers table of contents, footnotes, citations, and the navigation pane. These tools are essential for long-form professional and academic documents.

Lesson 3 • Reviewing, Finalizing, and Sharing Documents

Addresses track changes, comments, spell check, and export options. Finalizing documents correctly ensures professional delivery and version control.

Lesson 4 • Working with Styles and Themes

Introduces built-in styles, heading hierarchies, and document themes for consistent design. Consistent styling enables automatic table-of-contents generation covered next.

Lesson 1 • Creating Charts and Basic Visualizations

Covers chart types, formatting options, and best practices for data visualization. Clear charts communicate insights faster than raw numbers in any report.

Lesson 2 • Essential Formulas and Functions

Teaches SUM, AVERAGE, IF, VLOOKUP, and other core functions with practical examples. These functions handle the majority of everyday business calculations.

Lesson 3 • Excel Interface and Workbook Basics

Introduces the ribbon, cells, rows, columns, and workbook structure. Mastery of the interface accelerates every data task covered in this chapter.

Lesson 4 • Sorting, Filtering, and Tables

Introduces Excel Tables, sorting, and filtering to manage large datasets efficiently. Structured tables also improve formula reliability and chart creation.

Lesson 1 • Animations, Transitions, and Timing

Introduces entrance animations, slide transitions, and timing controls for dynamic delivery. Purposeful motion guides audience attention without causing distraction.

Lesson 2 • Presentation Planning and Slide Structure

Covers storyboarding, slide hierarchy, and outline view for logical content flow. Strong structure is the prerequisite for effective design and delivery.

Lesson 3 • Delivering and Sharing Presentations

Covers presenter view, speaker notes, export formats, and sharing options. Confident delivery and proper file distribution complete the presentation workflow.

Lesson 4 • Adding and Formatting Visual Content

Covers images, icons, SmartArt, charts, and video embedding for richer slides. Visual elements replace text-heavy slides and improve audience retention.

Lesson 1 • Email Composition and Formatting

Covers composing, formatting, and sending professional emails with attachments and signatures. Polished emails establish credibility in every professional interaction.

Lesson 2 • Inbox Organization and Management

Teaches folders, rules, categories, and the Focused Inbox for managing high email volume. Organized inboxes reduce missed messages and decision fatigue.

Lesson 3 • Productivity Features and Integrations

Covers tasks, To Do integration, quick steps, and Teams meeting links within Outlook. These integrations unify communication and task management in one hub.

Lesson 4 • Contacts and People Management

Introduces the People hub for storing, grouping, and searching contacts efficiently. Well-managed contacts speed up communication and meeting scheduling.

Lesson 1 • Chat, Messaging, and Collaboration

Teaches one-on-one chat, group messaging, @mentions, and message formatting. Effective messaging reduces email volume and accelerates team decisions.

Lesson 2 • Creating and Managing Teams and Channels

Covers team creation, channel types, membership management, and privacy settings. Proper team structure keeps communication organized and access controlled.

Lesson 3 • File Sharing and App Integration in Teams

Introduces file sharing within channels, co-authoring, and tab-based app integrations. Centralizing files and tools in Teams eliminates context switching.

Lesson 4 • Meetings and Video Conferencing

Covers scheduling, hosting, and managing Teams meetings with advanced controls. Productive meetings depend on mastering audio, video, and participant management.

Lesson 1 • Advanced Formulas and Functions

Covers XLOOKUP, INDEX-MATCH, array formulas, and dynamic functions for complex lookups. These functions replace manual data retrieval and reduce formula errors.

Lesson 2 • PivotTables and PivotCharts

Teaches building, customizing, and refreshing PivotTables and linked PivotCharts. PivotTables are the fastest tool for summarizing large datasets without formulas.

Lesson 3 • Conditional Formatting and Data Visualization

Covers rule-based formatting, color scales, data bars, and icon sets for visual analysis. Visual cues surface patterns and outliers that raw numbers obscure.

Lesson 4 • Automating Tasks with Macros

Covers recording, editing, and running macros to automate repetitive Excel workflows. Macro automation saves hours of manual work on recurring reporting tasks.

Lesson 1 • Power Automate for Workflow Automation

Introduces Power Automate flows for automating approvals, notifications, and data transfers. No-code automation extends Microsoft 365 capabilities without developer support.

Lesson 2 • Reporting and Dashboards with Microsoft 365

Covers building integrated reports using Excel, Forms data, and Power BI basics. Consolidated dashboards give stakeholders a single source of truth for decisions.

Lesson 3 • SharePoint for Team Sites and Intranets

Covers SharePoint site creation, document libraries, and page building for team collaboration. SharePoint serves as the backbone for enterprise content management in Microsoft 365.

Lesson 4 • Microsoft Forms and Data Collection

Teaches form and quiz creation, response collection, and results analysis in Forms. Structured data collection feeds directly into Excel and Power BI reporting pipelines.