Excel Data Management (Power Query)

Standardize and connect data from multiple sources with Power Query & Power Pivot — the foundation of a professional data model.

1. Rules for organizing data in Excel * Organize and manage data in Excel using Tables instead of Ranges * Advantages of using Tables in Excel 2. Common Power Query functions * Import data and clean raw data with Power Query * Transform raw data into standardized tables for reporting 3. Pivot Table features * Introduction to Pivot Tables and customizing their settings * Create flexible analytical reports with Pivot Tables using calculations like SUM, COUNT, AVERAGE, etc. 4. Power Pivot features * How Power Pivot works and how to build a Data Model * Create multi-table reports by combining Power Pivot, Pivot Tables, and Slicers