Overview:
This is an introduction to using Excel Power Query. See how Power Query imports large sets of data then transforms the data in many ways.
Learn how Power Query can extract, merge and combine data, format and filter data, manage columns and rows, shape and calculate data, and run other important steps. Once the data is transformed, load the completed query to an Excel Table or PivotTable for reporting.
Areas Covered in the Session:
- Define Power Query, its purpose and how it is useful using practical examples
- How to import data into the Power Query Editor from different sources
- Extract and Format Data
- Manage Columns and Filter rows; Reduce Rows
- Split and Group by Columns
- Pivot and Unpivot Columns
- Learn how to combine and join different data sets
- Get an introduction to Power Query formulas; create Custom Columns
- Load a completed Query into an Excel Table and PivotTable for reporting
- Refresh, Edit, Duplicate Queries.
- Miscellaneous tips and tricks while working with Power Query
Who Will Benefit:
- Managers
- Business Professionals
- Administrative Personnel
- Legal Professionals