Power Query is an Excel business intelligence tool that helps you to import data from various sources to be cleaned, transformed and reshaped as needed. You can consolidate multiple worksheets into one Table, quickly filter out data you don’t require or add new data to an existing report without the need to perform traditional time-consuming repetitive tasks.
This half day course will look at; –
- Getting Started with Power Query in Excel
- The Four Phases of Power Query
- How to Get / Import and Connect to various Data Sources
- Using Power Query Editor Interface to Transform Data
- Filter out and Sort Data
- Format Data
- Remove Unwanted Data Columns
- Add New Columns – create simple formula
- Use Combine to Merge and Append
- Load the Queries into your Workbook or Data Model
For further information, please call 0114 4040 160 or Contact Us.