City of St. Catharines Learning & Development

If you're constantly updating spreadsheets or battling slow files packed with lookup formulas, it's time to let Power Query do the heavy lifting. This course shows you how to connect to your source data, shape it to fit your needs, and create smart, streamlined reports like PivotTables—without all the hassle. You’ll also learn best practices for structuring data so it’s Power BI-ready, giving you a strong foundation for building interactive dashboards and reports in Power BI later.

Required Prior Knowledge: Required Prior Knowledge Excel Course 2B and Excel Course 5 topics. You must understand how to set up a valid database, the Table feature, and basic PivotTables.