Foundational Data: Tables, Data Validation, and Power Query in Excel

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. Once data has successfully been added to a workbook, it is critical that it remains useful.

Topics include:

• Understanding Power Query in the context of an Excel workbook
• Extracting data from various sources
• Performing transformations on dirty data
• Adding Data Validation to ranges in a workbook

Experience using Microsoft Excel