Every time you copy and paste similar data into your workbook to manually sort, filter and format it, you are wasting precious time.  This one-day instructor led course will take you through the process of using Power Query to automate data importing, reshaping and cleansing. 

Each section of the course will provide an opportunity to explore the new subject area, followed by an exercise to reinforce learning.   

Who will benefit from this course

This course assumes no prior knowledge of Power Query.   It is assumed that you are a user of Excel and familiar with PivotTables. You will benefit from this course if you frequently copy and paste data into Excel from the same sources and often need to clean that data.

Key elements of the course 

• Access Power Query and explore the working environment
• Import data from a variety of sources
• Use tools to remove, replace, split, merge and filter data
• Add new columns using calculated fields
• Understand data models and create relationships between tables
• Combine data from multiple sources
• Learn the difference between calculated fields and measures
• Perform data analysis with PivotTables and Charts
• Create simple dashboards

Course Details

This is a one-day, tutor led, on-line course the dates for which are set out on the Course Schedule. It can also be run as a tailored, company specific course either on-line or at an organisation’s premises.