Power Query transforms how Ottawa professionals work with data in Excel. Whatever the source, however messy the data, Power Query lets you connect, clean, and shape it quickly -- without formulas or manual effort. This course walks through the essentials so you can apply it to your own data immediately. 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.
