GET ready to TRANSFORM your life! A game changer for Remuneration Professionals!
Join International Excel Guru, Dianne Auld (Master Reward Specialist), as she demonstrates one of the smartest and most powerful tools ever developed for Excel.
Power Query comes standard with Excel 2016 / 2019 / 2021 / Microsoft Office 365 and is available as an add-in to Excel 2013.
It can automate routine data transformation (e.g. merging / splitting / removing columns, filtering data, replacing data, rounding, sorting, changing case, converting text to numbers and doing date calculations). It does this without using macros or VBA, and with very limited use of formulas. Almost all the transformation is done through the simple use of a menu and a mouse.
It can merge and transform multiple files in a folder, then add / transform another file from the folder simply by clicking Refresh. It can scrape data from web tables, transform the data for use in an Excel file, then update it with a single click.
Dianne will demonstrate:
- How to merge and transform three monthly files of labour turnover data for use in a pivot table, then load / transform the next three-monthly files and update the pivot table with a single click
- How to calculate medians per gender / job title
- How to pivot employee salary data into different business units for use in scatter charts
- How to unpivot problem sales commission data for use in analysis
- How to scrape exchange rate data from the web, use the data in a formula to convert multi-country salaries to a single currency, and update data with a single click, and
- Power Query’s AI capability of adding a column based on examples.
Attendees will be provided with the Excel spreadsheets and detailed instructions for replication of the functions demonstrated after the webinar. You do not need to use your laptop/PC for the session and are encouraged not to follow along with the demo on your computer, as it will proceed at a reasonably smart pace, and you might get lost. You should just watch and take notes if desired.
To ensure an effective learning experience, there are a limited number of seats available for this course.