- This event has passed.
Excel: Get and Transform
1 May @ 9:30 AM - 10:30 AM
“Power Query and Power Pivot aka Get and Transform are the best thing to happen to Excel in 20 years”. Bill Jelen, Excel MVP
How long would it take you to combine data from 15 workbooks into a single data set? A few minutes, an hour? If you’re using Get & Transform (previously known as Power Query), you could combine the data from all the workbooks in a few clicks. With Get & Transform, you can add data from almost any source e.g. files, folders, databases, web pages, organise and transform it and incorporate it in your reports.
Aimed at: As this is an advanced course previous attendance at Introduction to PivotTables or a working knowledge of creating pivot tables is recommended.