Modern Data Handling: Introduction to Powery Query in Excel - Seminar
Modern Data Handling: Introduction to Power Query in Excel
Description
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