Overview
Syllabus
) Introduction.
) Power Query Icon as Magic.
) Files to download and unzip folder.
) What is Power Query? What does Power Query do?.
) Example 1: Import Text File to create report and chart. Then get a new Text File next month and everything will update..
) A complete introduction to Power Query..
) Two methods to update report when you get a new Text file: 1) Edit Query, or 2) Duplicate Query..
) Example 2: Clean Bad Data in an Excel Sheet, Load to Excel Sheet, Build PivotTable. Then add new data and refresh the Query and the PivotTable Cache..
) Example 3: Import multiple Text Files from Folder and Append into single Proper Data Set..
) Summary.
Taught by
ExcelIsFun