Power Query for Excel Course – Mynda Treacy

Power Query for Excel Course – Mynda Treacy

Overview

If you import or copy/paste data into Excel, you can probably automate many of the related manual tasks using Power Query. Traditionally, we spend a lot of time in Excel simply preparing data for use, for example, getting it ready for a PivotTable, formula-based report, or upload. Then, we get to repeat those same manual steps next month, and the next. Power Query changes all of that because once we define the steps needed to prepare the data, it becomes a simple refresh next period … and every subsequent period

Outline

• Lesson 1: Introduction
• Lesson 2: Data Sources
• Lesson 3: Combining Multiple Sources
• Lesson 4: Transforming and Cleaning Data
• Lesson 5: Data Destinations and Refreshing Queries
• Lesson 6: M Language
• Lesson 7: Parameter Tables and Custom Functions