Description

The most critical starting point for a successful spreadsheet is clean, accurate, and current data. The most effective and modern way to accomplish this task is with a newer feature of Excel called Power Query. With Power Query, we perform operations that Extract, Transform, and Load (ETL) data from the original source into our workbook.

Topics include:

• Understanding Power Query in the context of an Excel workbook
• Extracting data from various sources
• Performing transformations on dirty data
• Combining and comparing data
• Setting up automated refreshes of external data