Module 1: Course Overview - This module explains how the class will be structured and introduces course materials and additional administrative information.

Lessons:

• Introduction
• Course Materials
• Facilities
• Prerequisites
• What We'll Be Discussing

Module 2: Introduction to Power Query - In this module, we will explore the Power Query interface and examine the importance of data types and how to properly utilize them.

Lessons:

• Understanding The Ease That the Revolutionary Changes Afforded by Power Query Provide to the Excel Pro
• Examining The Power Query Interface
• Configuring Data Types

Module 3: Working with CSV, TXT and Excel Worksheets - In this module, we will explore working with CSV, TXT, and Excel worksheets. We will examine the import process and explore transforming and loading data. We will also cover utilizing ranges and working with large numbers of files and folders, then finish with sections on combining worksheets and utilizing PivotTables.

Lessons:

• Importing Data
• Transforming Data
• Loading Data
• Using Ranges in Excel
• Understanding and Handling Special Situations
• Appending Operations
• Working with Folders and Files
• Combining Worksheets
• Using PivotTables

Module 4: Connecting to Databases - In this module, we will examine working with databases and walk-through the process of connecting and importing data from these sources.

Lessons:

• Working with Relational Data
• Importing from SQL Server Analysis Services Multidimensional and Tabular

Module 5: Performing Merges - In this module, we will examine the process of merging datasets. We will cover common issues encountered and discuss ways to resolve them.

Lessons:

• Understanding the Issues
• Performing Merges

Module 6: Loading Your Data - In this module, we will examine other places where you can load your data, such as Power BI Desktop. We will cover the options available with each area, and explore the different interfaces.

Lessons:

• Loading into Excel
• Loading into Power Pivot
• Loading into Power BI Desktop

Module 7: Grouping and Summarizing with Power Query - In this module, we will cover grouping and summarizing data with Power Query.

Lessons:

• Grouping Options
• Summarizing

Module 8: Working with the Power Query Language "M" (Optional) - In this optional module, we will examine the Power Query Language "M" and the capabilities that the language provides. We will also briefly examine formulas.

Lessons:

• Understanding the "M" Interface
• Examining Power Query Formulas