Power Query changes how you work with data in Excel. No matter where your data comes from or how messy it is, Power Query lets you connect, clean, and transform it quickly -- without formulas or manual effort. This course walks you through the essentials, so you can start using it on your own data right away. Prerequisite: Experience with Excel
» Using PQ for data loading and cleaning purposes
» Using PQ to reformat reports to tables for easier data analysis
» Combining data from multiple sheets in a workbook
» Combining data from multiple files in a folder
» Tips, tricks, and best-practice techniques
Consider yourself an intermediate user of Excel and need to work with data that originates outside Excel.
