Advanced Office Suite with Power BI Course

Lesson 1 • Cross-Application Data Flow

Demonstrates how data moves between Word, Excel, and PowerPoint via paste-special and linking. Prepares students for integrated reporting tasks.

Lesson 2 • Accessibility and Productivity Settings

Configures accessibility features, proofing tools, and macro security settings. Ensures a consistent, efficient working environment from the start.

Lesson 3 • Interface Layout and Ribbon Mastery

Covers the Ribbon, Quick Access Toolbar, and contextual tabs across all Office apps. Establishes the navigation baseline for every subsequent chapter.

Lesson 1 • Importing and Exporting Data

Covers CSV, XML, and database imports plus export formats for downstream tools. Directly supports Power BI data ingestion covered in Chapter 6.

Lesson 2 • Power Query for Data Shaping

Uses Power Query to import, merge, and reshape data from multiple sources. Establishes the ETL skill set required for Power BI in later chapters.

Lesson 3 • Data Validation and Error Handling

Builds dropdown lists, input messages, and error alerts to enforce data integrity. Prevents downstream errors in formulas and dashboards.

Lesson 4 • Structured Tables and Named Ranges

Converts raw data into Excel Tables and defines named ranges for dynamic referencing. Structured tables are the foundation for all advanced formulas ahead.

Lesson 1 • Lookup and Reference Functions

Teaches VLOOKUP, XLOOKUP, INDEX-MATCH, and INDIRECT for flexible data retrieval. These functions underpin dynamic reports built in later chapters.

Lesson 2 • Logical and Conditional Functions

Applies IF, IFS, AND, OR, and SWITCH to build decision-driven calculations. Logical functions control conditional formatting and KPI logic ahead.

Lesson 3 • Dynamic Array and Spill Functions

Introduces FILTER, SORT, UNIQUE, and SEQUENCE for modern array-based workflows. Replaces legacy array formulas with cleaner, scalable solutions.

Lesson 4 • Formula Auditing and Optimization

Uses Evaluate Formula, Watch Window, and calculation modes to debug and optimize. Ensures formula reliability before data is passed to Power BI.

Lesson 1 • Dynamic Dashboard Assembly

Combines PivotTables, charts, and slicers into a cohesive Excel dashboard layout. Reinforces layout and UX principles carried into Power BI report design.

Lesson 2 • Slicers, Timelines, and Interactivity

Adds slicers and timelines to connect multiple PivotTables for dashboard interactivity. Mirrors the filter panel experience students will use in Power BI.

Lesson 3 • PivotTable Design and Configuration

Covers PivotTable field layout, value settings, and grouping options. Mastery here directly accelerates understanding of Power BI matrix visuals.

Lesson 1 • Mail Merge and Document Automation

Automates personalized letters, labels, and emails using Mail Merge with Excel data. Connects data management skills from Chapter 2 to document production.

Lesson 2 • PowerPoint Slide Master and Branding

Configures Slide Masters, layouts, and placeholders to enforce brand consistency. A branded template reduces design time for all future presentations.

Lesson 3 • Presenting Data Visuals in PowerPoint

Embeds and links Excel charts and Power BI screenshots into slides for live updates. Bridges the gap between analytical outputs and executive presentations.

Lesson 4 • Advanced Word Document Formatting

Applies styles, themes, section breaks, and master pages for consistent long documents. Structured formatting enables automated tables of contents and cross-references.

Lesson 1 • Power BI Desktop Interface Overview

Orients students to Report, Data, and Model views plus the Fields and Filters panes. Familiarity with the interface accelerates all subsequent Power BI work.

Lesson 2 • Date Tables and Time Intelligence Setup

Builds a dedicated date table and marks it for time intelligence functions. Enables period-over-period comparisons central to business reporting.

Lesson 3 • DAX Fundamentals: Measures and Columns

Introduces DAX syntax, calculated columns, and basic measures using SUM and COUNT. Establishes the DAX foundation expanded in Chapter 7.

Lesson 4 • Connecting and Importing Data Sources

Connects Power BI to Excel, CSV, databases, and web sources using Get Data. Builds on Power Query skills from Chapter 2 in a Power BI context.

Lesson 1 • Core Visuals and Best Practices

Configures bar, line, scatter, and matrix visuals with conditional formatting and tooltips. Proper visual selection and formatting maximize report clarity.

Lesson 2 • Time Intelligence and Period Comparisons

Builds YTD, MTD, rolling averages, and prior-period variance measures using DAX. These KPIs are the most requested metrics in executive dashboards.

Lesson 3 • Report Design and UX Principles

Applies layout grids, color theory, and accessibility standards to report design. Professional UX ensures reports are adopted and trusted by stakeholders.

Lesson 4 • Advanced DAX Patterns and Context

Explores row context, filter context, and context transition with CALCULATE and FILTER. Mastery of context is the key differentiator for advanced DAX authors.

Lesson 1 • Row-Level Security and Data Access

Implements static and dynamic row-level security roles to restrict data by user. Ensures sensitive data is visible only to authorized report consumers.

Lesson 2 • Publishing and Workspace Management

Publishes PBIX files, organizes workspaces, and assigns workspace roles. Proper workspace structure is the foundation of scalable Power BI deployments.

Lesson 3 • Data Gateway and Scheduled Refresh

Installs and configures the on-premises data gateway for scheduled dataset refresh. Keeps reports current without manual intervention from report authors.

Lesson 4 • Deployment Pipelines and Version Control

Uses deployment pipelines to promote content across development, test, and production. Structured promotion reduces errors and supports enterprise governance.