Overview:
This is a high-level introduction overview to Excel's Power tool called Power Query.
See how it can transform large volumes of data by cleaning it, manipulating it and transforming it into a completed query that can then be loaded to an Excel Table or PivotTable for reporting.
Areas Covered in the Session:
- How to import data into the Power Query Editor
- Command oveview to Prepare, Clean and Transform data
- Learn how to combine and join different data sets
- Get an introduction to Power Query formulas
- Load a complete Query into an Excel Table and PivotTable for reporting
Who Will Benefit:
- Managers
- Business professionals
- Administrative Personnel
- Legal Professionals