Microsoft Course

Lesson 1 • Navigating the Microsoft 365 Interface

Introduces the Microsoft 365 portal, app launcher, and unified search. Students gain fluency in moving between apps and accessing shared resources.

Lesson 2 • Microsoft Account and Identity Setup

Covers account creation, Microsoft ID types, and tenant concepts. Provides the authentication foundation required for every Microsoft service.

Lesson 3 • Microsoft Product Suite Overview

Maps the full Microsoft portfolio across productivity, cloud, and developer tools. Establishes the mental model needed for all subsequent chapters.

Lesson 4 • Cloud Storage and OneDrive Basics

Explains OneDrive architecture, sync behavior, and file organization. Connects personal cloud storage to collaborative workflows introduced later.

Lesson 1 • Long Document Navigation and Structure

Introduces headings, navigation pane, table of contents, and bookmarks. Prepares students to manage multi-section documents efficiently.

Lesson 2 • Mail Merge and Document Automation

Explains mail merge setup, data source connection, and field insertion. Enables bulk document generation for letters, labels, and reports.

Lesson 3 • Tables, Lists, and Visual Elements

Teaches insertion and formatting of tables, lists, images, and shapes. Builds visual communication skills applied in reports and proposals.

Lesson 4 • Document Creation and Basic Formatting

Covers creating, saving, and formatting Word documents using styles and themes. Establishes the formatting discipline required for consistent professional output.

Lesson 5 • Accessibility and Document Protection

Teaches accessibility checker use, reading order, and document protection options. Ensures documents meet professional and compliance standards.

Lesson 1 • Sorting, Filtering, and Tables

Covers Excel Tables, sort options, and AutoFilter for data exploration. Connects structured data management to PivotTable analysis introduced next.

Lesson 2 • Data Formatting and Validation

Teaches number formats, conditional formatting, and data validation rules. Ensures data integrity and visual clarity in professional spreadsheets.

Lesson 3 • Essential Formulas and Functions

Introduces arithmetic operators, SUM, AVERAGE, IF, and lookup functions. Provides the formula toolkit used in every subsequent data task.

Lesson 4 • PivotTables and Data Summarization

Explains PivotTable creation, field arrangement, and calculated fields. Enables rapid summarization of large datasets for reporting purposes.

Lesson 5 • Charts, Dashboards, and Sharing

Teaches chart selection, formatting, and basic dashboard assembly. Prepares students to deliver data insights visually to stakeholders.

Lesson 1 • Content Creation and Media Integration

Teaches text box usage, image insertion, icons, and video embedding. Builds the content assembly skills needed for information-rich slides.

Lesson 2 • Data Visualization in Slides

Covers chart insertion from Excel, table design, and infographic elements. Connects Excel data skills to effective visual storytelling in presentations.

Lesson 3 • Presenter Tools and Delivery

Explains Presenter View, speaker notes, and rehearsal timing features. Prepares students for confident, polished live and virtual delivery.

Lesson 4 • Slide Design Principles and Themes

Covers slide layouts, themes, color palettes, and font pairing. Establishes visual design discipline that elevates all subsequent presentation work.

Lesson 1 • Inbox Organization and Search

Covers folders, rules, categories, and advanced search operators. Enables systematic inbox management that scales with high email volume.

Lesson 2 • Outlook Settings and Security

Covers out-of-office replies, junk mail filters, and email encryption options. Ensures professional and secure communication practices.

Lesson 3 • Outlook Interface and Email Basics

Introduces the Outlook layout, composing emails, and formatting options. Provides the operational baseline for all Outlook productivity techniques.

Lesson 4 • Tasks, To-Do, and Follow-Up

Introduces Outlook Tasks, Microsoft To Do integration, and follow-up flags. Builds personal productivity habits that complement team tools.

Lesson 1 • Chat and Messaging Best Practices

Covers direct messages, group chats, message formatting, and @mentions. Builds clear, efficient asynchronous communication habits.

Lesson 2 • Teams Interface and Channel Structure

Explains Teams layout, team creation, channels, and membership management. Establishes the structural understanding needed to organize collaborative workspaces.

Lesson 3 • Meetings and Live Events

Teaches meeting scheduling, in-meeting controls, and breakout rooms. Prepares students to facilitate productive virtual meetings of any size.

Lesson 4 • Apps, Tabs, and Workflow Integration

Covers adding apps, tabs, and connectors to extend Teams functionality. Enables students to build integrated workspaces that reduce context switching.

Lesson 1 • Search, Metadata, and Content Discovery

Covers SharePoint search, managed metadata, and content type usage. Connects information architecture to efficient content discovery at scale.

Lesson 2 • SharePoint Architecture and Site Types

Explains hub sites, team sites, and communication sites and their relationships. Provides the structural knowledge required to plan effective SharePoint deployments.

Lesson 3 • Permissions and Governance

Explains permission levels, sharing settings, and access request workflows. Ensures students can secure content while enabling appropriate collaboration.

Lesson 4 • Document Libraries and List Management

Covers library creation, metadata columns, views, and list configuration. Builds the document management foundation for organizational knowledge sharing.

Lesson 1 • Power Automate Fundamentals

Introduces flow types, triggers, actions, and the Power Automate canvas. Establishes the automation mindset and toolset for all subsequent workflow tasks.

Lesson 2 • Connecting Data Sources and Connectors

Explains standard and premium connectors, HTTP actions, and data operations. Expands automation reach across Microsoft and third-party services.

Lesson 3 • Power Apps Canvas App Basics

Teaches canvas app creation, screen design, and data source connection. Provides the foundation for building custom forms and lightweight business apps.

Lesson 4 • Building Approval and Notification Flows

Covers approval actions, email notifications, and condition branching in flows. Enables automation of common business approval and alert processes.