Microsoft Office Essentials Course

Lesson 1 • Customizing Your Workspace

Explains how to tailor the Office environment for personal productivity. Students configure views and preferences that persist across all three applications.

Lesson 2 • Getting Help and Using Templates

Introduces built-in Help, Tell Me search, and the Office template library. Equips students to self-solve problems and accelerate document creation.

Lesson 3 • Navigating the Office Interface

Covers the Ribbon, Quick Access Toolbar, and backstage view across Word, Excel, and PowerPoint. Establishes shared interface logic used throughout the course.

Lesson 1 • Character and Paragraph Formatting

Teaches font styling, alignment, indentation, and line spacing controls. Students apply consistent formatting that meets professional document standards.

Lesson 2 • Proofing and Finalizing Documents

Teaches spell check, grammar check, word count, and document accessibility review. Ensures students submit error-free, professional-quality work.

Lesson 3 • Page Layout and Document Setup

Covers margins, orientation, page size, headers, footers, and page numbers. Prepares students to produce print-ready and submission-ready documents.

Lesson 4 • Using Styles and Themes

Introduces built-in heading styles, style sets, and document themes for uniform design. Connects to later sections on tables of contents and long-document formatting.

Lesson 1 • Working with SmartArt and Charts

Introduces SmartArt diagrams and embedded charts for visual data communication. Connects to Excel chart concepts introduced later in the course.

Lesson 2 • Long-Document Features

Covers table of contents, footnotes, endnotes, and bookmarks for navigating lengthy documents. Builds on heading styles established in the previous chapter.

Lesson 3 • Building and Formatting Tables

Covers inserting, resizing, merging, and styling tables for data presentation. Builds on paragraph formatting skills to organize information visually.

Lesson 4 • Inserting Images and Shapes

Explains how to insert, resize, crop, and position images and shapes within documents. Introduces text-wrapping options critical for professional layouts.

Lesson 1 • Entering and Editing Data

Covers data types, data entry techniques, AutoFill, and Flash Fill for efficient input. Accurate data entry is the prerequisite for all formula and analysis work.

Lesson 2 • Sorting and Filtering Data

Explains single-column and multi-column sorting plus AutoFilter for data exploration. Prepares students for structured data analysis in later Excel chapters.

Lesson 3 • Formatting Cells and Worksheets

Teaches number formats, cell styles, borders, shading, and column width adjustment. Formatted worksheets communicate data clearly and support professional presentation.

Lesson 4 • Understanding the Excel Workspace

Introduces workbooks, worksheets, cells, rows, and columns as the structural units of Excel. Establishes spatial awareness needed for all subsequent Excel work.

Lesson 1 • Building Formulas from Scratch

Teaches formula syntax, arithmetic operators, and cell references for basic calculations. Establishes the logic framework required for all function-based work.

Lesson 2 • Essential Math and Statistical Functions

Covers SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA for everyday data summarization. These functions form the core toolkit for business reporting tasks.

Lesson 3 • Logical and Lookup Functions

Introduces IF, nested IF, VLOOKUP, HLOOKUP, and XLOOKUP for conditional logic and data retrieval. Enables students to build dynamic, decision-driven spreadsheets.

Lesson 4 • Text and Date Functions

Covers CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, TODAY, and DATE for data manipulation. Prepares students to clean and transform imported or inconsistent data.

Lesson 1 • Conditional Formatting for Insights

Covers highlight rules, data bars, color scales, and icon sets to surface patterns visually. Builds on cell formatting skills to add analytical meaning to raw data.

Lesson 2 • Creating and Customizing Charts

Teaches chart type selection, data range setup, axis labels, and chart formatting. Students match chart types to data stories for clear visual communication.

Lesson 3 • PivotCharts and Slicers

Covers PivotCharts linked to PivotTables and slicers for interactive dashboard filtering. Enables students to build dynamic reports for stakeholder presentations.

Lesson 4 • Data Validation and Named Ranges

Teaches input restrictions, dropdown lists, error alerts, and named ranges for controlled data entry. Reduces input errors and simplifies formula readability.

Lesson 1 • Inserting Visuals and Media

Explains inserting images, icons, shapes, SmartArt, and video clips into slides. Builds on Word visual skills while adding media elements unique to presentations.

Lesson 2 • Adding and Formatting Text

Covers text box insertion, placeholder editing, font formatting, and text alignment in slides. Reinforces Word formatting skills within the constraints of slide design.

Lesson 3 • Understanding the PowerPoint Interface

Introduces the slide panel, editing area, notes pane, and view modes specific to PowerPoint. Connects shared Office interface knowledge to presentation-specific workflows.

Lesson 4 • Applying Themes and Slide Masters

Teaches built-in themes, color and font variants, and Slide Master editing for brand consistency. Ensures uniform design across all slides without manual repetition.

Lesson 1 • Preparing and Delivering Presentations

Covers Presenter view, speaker notes, rehearse timings, and laser pointer tools. Prepares students to deliver confidently in live and hybrid meeting environments.

Lesson 2 • Slide Transitions

Covers applying, timing, and customizing slide transitions for smooth deck flow. Teaches restraint in transition use to maintain professional presentation standards.

Lesson 3 • Linking Excel Data to Slides

Explains embedding and linking Excel charts and tables into PowerPoint slides. Connects Excel analysis skills to presentation delivery for data-driven storytelling.

Lesson 4 • Object Animations

Teaches entrance, emphasis, exit, and motion path animations for individual slide objects. Enables students to control information reveal and audience focus strategically.