Microsoft Word, Excel and PowerPoint Course

Lesson 1 • File Management and Cloud Storage

Teaches creating, saving, and organizing files locally and in OneDrive. Ensures students can manage documents reliably before adding content.

Lesson 2 • Navigating the Office Interface

Covers the Ribbon, Quick Access Toolbar, and Backstage view shared across all three apps. Establishes the common UI framework students rely on throughout the course.

Lesson 3 • Getting Help and Using Templates

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

Lesson 1 • Inserting Visual Elements

Introduces images, shapes, icons, and text boxes within Word documents. Prepares students to create visually engaging reports and communications.

Lesson 2 • Tables and Data Presentation in Word

Teaches inserting, formatting, and modifying tables to organize information. Connects structured data presentation to professional document standards.

Lesson 3 • Formatting Text and Paragraphs

Teaches font styling, paragraph alignment, indentation, and line spacing. Enables students to apply consistent, readable formatting to any document.

Lesson 4 • Creating and Editing Documents

Covers typing, selecting, cutting, copying, and pasting text with precision. Forms the baseline editing skill set for all subsequent Word work.

Lesson 1 • Mail Merge and Automation

Covers the mail merge wizard for letters, labels, and emails using data sources. Automates repetitive document production for large audiences.

Lesson 2 • Styles and Document Themes

Covers applying, modifying, and creating paragraph and character styles. Enables rapid, consistent formatting across multi-page documents.

Lesson 3 • Long Document Tools

Teaches table of contents, footnotes, endnotes, and bookmarks for navigating lengthy documents. Builds skills essential for reports, manuals, and proposals.

Lesson 4 • Document Protection and Finalization

Covers restricting editing, adding passwords, and preparing documents for distribution. Ensures documents are secure and professionally finalized.

Lesson 1 • Understanding the Excel Workspace

Covers workbooks, worksheets, rows, columns, and cell references. Establishes the structural vocabulary students need before entering any data.

Lesson 2 • Formatting Cells and Worksheets

Covers number formats, cell styles, borders, and conditional formatting basics. Produces readable, professional-looking spreadsheets from raw data.

Lesson 3 • Entering and Managing Data

Teaches data types, AutoFill, Flash Fill, and data validation rules. Ensures accurate, consistent data entry as the foundation for all analysis.

Lesson 4 • Writing Basic Formulas and Functions

Introduces arithmetic operators, SUM, AVERAGE, COUNT, MIN, and MAX. Gives students the core calculation tools used in virtually every spreadsheet.

Lesson 1 • Text and Date Functions

Teaches CONCATENATE, TEXT, LEFT, RIGHT, MID, TODAY, and DATEDIF for data manipulation. Expands formula capability to handle real-world data cleaning tasks.

Lesson 2 • PivotTables and PivotCharts

Introduces building, grouping, and refreshing PivotTables and linked PivotCharts. Delivers powerful summarization of large datasets without complex formulas.

Lesson 3 • Sorting, Filtering, and Tables

Covers single and multi-level sorting, AutoFilter, and converting ranges to Excel Tables. Structures data for efficient analysis and reporting.

Lesson 4 • Data Visualization with Charts

Teaches chart types, formatting, and best practices for communicating data visually. Connects analytical results to clear, audience-ready presentations.

Lesson 1 • Advanced Formula Techniques

Covers array formulas, SUMIFS, COUNTIFS, AVERAGEIFS, and dynamic array functions. Enables multi-condition calculations across large, complex datasets.

Lesson 2 • Data Validation and Protection

Teaches advanced validation rules, drop-down lists, and worksheet protection settings. Prevents data entry errors and secures sensitive spreadsheet content.

Lesson 3 • Macros and Basic Automation

Covers recording, running, and editing simple macros to automate repetitive tasks. Introduces automation concepts without requiring prior programming knowledge.

Lesson 4 • Power Query for Data Import

Introduces connecting to external data sources, transforming data, and loading queries. Automates repetitive data preparation tasks that previously required manual effort.

Lesson 1 • Understanding the PowerPoint Interface

Covers the slide panel, editing area, Notes pane, and view modes. Orients students to the workspace before any design or content work begins.

Lesson 2 • Building Slides with Layouts and Themes

Teaches slide layouts, design themes, color schemes, and font sets. Establishes visual consistency as the foundation of professional presentation design.

Lesson 3 • Inserting Images, Shapes, and Media

Teaches inserting photos, icons, shapes, SmartArt, audio, and video. Builds the visual storytelling toolkit for engaging, multimedia presentations.

Lesson 4 • Organizing and Managing Slides

Covers duplicating, reordering, hiding, and grouping slides with sections. Prepares students to manage large decks efficiently before adding animations.

Lesson 1 • Slide Master and Template Design

Covers editing the Slide Master, layout masters, and placeholders to build reusable templates. Enforces brand consistency across every slide in a presentation.

Lesson 2 • Animations and Motion Effects

Teaches entrance, emphasis, exit, and motion path animations with timing controls. Adds purposeful movement that guides audience attention without distraction.

Lesson 3 • Slide Transitions and Morph

Covers slide transition effects, duration settings, and the Morph transition for smooth visual flow. Creates seamless narrative movement between slides.

Lesson 4 • Delivering and Exporting Presentations

Covers Presenter view, rehearsed timings, speaker notes, and export formats. Prepares students for confident live delivery and professional file distribution.