Power Query is the most important change to Excel in decades. Its job is called ETL – short for Extract, Transform, and Load. This allows us to pull data from any file, database, or other source, and clean it in preparation for our analysis. If you’ve spent significant time copying and pasting information together, updating it when new data comes out, and ‘fixing it up’ to be used, this tool will be a gamechanger.

Topics include:

• Extracting data from Excel, CSV, and other file types
• Compiling data from multiple files in seconds
• Combining related data faster and easier than VLOOKUP
• Automating repetitive data handling