Watch Dianne Auld demonstrate one of the smartest and most powerful tools ever developed for Excel. Power Query comes standard with Excel 2016/2019/Microsoft 365 and is available as an add-in on Excel 2010/2013. Dianne will show you how it can automate routine data transformation (i.e. merging, splitting, removing columns, filtering data, replacing data, rounding, sorting, converting text to numbers and dates).

She will demonstrate how you can achieve this without using macros and VBA, and with hardly any formulas.

Almost all the transformation is done through the simple use of a menu and a mouse.

Dianne will show you how to merge and transform multiple files in a folder by clicking Refresh. You 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 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.
• How to pivot employee salary data into different business units for use in scatter charts and pay structure design.
• How to unpivot problem sales commission data for use in analysis.
• Power Query’s AI capability of adding a column based on examples.

Don’t miss this informative session. Dianne will also share example files for you to practice on (after the course has taken place). This Masterclass has limited space available, registration fees are as follows: 

SARA Professionalised Members: No charge
SARA Paid-up members: No charge
Non-SARA Members: R1500

This Excel Masterclass is fully booked, to be added to the waiting list please email eileen@vdw.co.za.

Terms and Conditions

• To get member discount you must use the email address associated with your regular SARA account.
• If you use a new email address a new account will be opened for you, unless you ask the secretariat to update your old account details. 
• Member discount is only offered to paid-up members. 
• You and the billing contact of your organisation will receive invoices a few minutes after you have registered.
• If you see a red notice on the screen about unpaid invoices please contact the secretariat on saraservices@vdw.co.za to resolve.
• Cancellation: Please contact eileen@vdw.co.za if you are unable to attend
   

If you don’t have a Valid Purchase Order Number please use your phone number