Introduction to Power Query - 12/06/22

We developed this course to teach real world tech skills in Excel to people who encounter data in spreadsheets in their day-to-day work. If you work with macros, clean data, or use multiple workbooks to create reports, you need to know about Power Query! We dive into practical skills and show you how to approach and handle data with Power Query. This course is not for an Excel beginner.  We will provide you with exercise files to be used during training for a hands on, interactive learning experience. After the session we will provide you a guidebook pdf to use as a reference source. Get Data Queries & connections Access queries & connections Navigate Power Query Editor Load data Disconnect data   Data Cleaning & Applied Steps Delete unnecessary columns Use Choose Columns to remove columns Change columns order Change column names Change data case Replacing values Convert data types Remove spaces & non-printable characters Use Gear for adjustments Change step order Na