Learn to use the tools designed specifically to make transforming and loading data into Excel streamlined and easily repeatable. Power Query was introduced to us in 2013 and is now firmly entrenched into the Excel interface as the Get and Transform tools. It is a game changer if you need to get data into your spreadsheets for analysis, particularly if the data is not always in the right shape.
Learn to use the tools designed specifically to make transforming and loading data into Excel streamlined and easily repeatable. Power Query was introduced to us in 2013 and is now firmly entrenched into the Excel interface as the Get and Transform tools. It is a game changer if you need to get data into your spreadsheets for analysis, particularly if the data is not always in the right shape.
Rather than loading your raw data into a worksheet then using a combination of formulae, VBA and manual hacking to get it into a useable state, Power Query makes it easy to create a repeatable process to do this that takes place every time you 'refresh' your connection. Data can come from a variety of sources and be transformed and combined in a number of ways. This is a tool that can save your hours!
You should have good intermediate experience in working with Excel.
This course is taught in a PC computer suite at Selwyn College.
(09) 521 9623
info@selwyncomed.school.nz
203-245 Kohimarama Road, Kohimarama
Open Hours
Term Time: Monday - Wednesday 9:00am - 9:00pm
Thursday - Friday 9:00am - 3:00pm
School Holidays: When courses are running the office is open 9:00am - 4:00pm