From the intermediate modeller to the seasoned spreadsheet guru, we recommend Goalfix’s advanced modelling course as an exceptional opportunity to refresh and renew modelling skills. A very good return on investment.
Data transformation using Power Query
The main purpose of the course is to give delegates a good understanding the power of Power Query in Excel that many Excel users haven’t explored.
About this Course
Course Overview
Power Query is an “Excel on steroids” data transformation tool.
This tool allows you to quickly combine and consolidate large data from different sources like Excel, text files, the web, databases and many more.
It can make complex data sets transformation into an easy process and maintenance of the data set much easier to update.
- Connecting and Transforming Data with Power Query in Excel
- Power Query Transformations
- Appending and Merging Data
- Date and Time Transformations
- Understanding Basic M Code
- Loading Data from Online Data Sources
- Load to Data Model and Power Pivot
- Advanced Problem Solving using Power Query
Enquire
Get Course Outline
Public Courses
Who should attend?
- Anyone looking to pursue a career in data analysis or business intelligence
- Data analysts and Excel users hoping to get their work done faster by using one of Microsoft’s POWER tools.
- Any Excel user wishing to up skill in Power Query for data cleaning and data transformations
- Any Excel user that finds themselves combining data manually
- All Excel users who work with big data
Course format
Live Online Training
Delegates join online live, interactive webinars for 2 days.
Course Delivery
Training Offering
Comprehensive, practical, hands-on training accessible anywhere.
Live Online Training
In-House Training
International Training
Live Online Training
1.
Live Interactive Online Training
Our public courses are offered as live interactive online training sessions. This allows for participation and engagement, ensuring meaningful learning takes place.
All webinars are recorded and shared with attendees.
In-House Training
2.
In-House Training
Customised and cost effective training.
These can either be hosted on site or as live interactive training online, which can be scheduled to suit your specific needs and run as full or half day courses, with breaks every two hours.
International Training
3.
International Training
Working with businesses around the world.
With live online training, Goalfix is able to assist companies around the world with financial model & data analytics training. We have extensive experience in successfully conducting public and in-house courses across continents and cultures.
What clients say about us
Seasoned spreadsheet gurus
David J. Bate
Group CEO – Brookwood Capital Corporation
Goalfix is the go-to trainer
The experience of the tutor was very valuable as questions could be addressed from a practical perspective. For any organisation that is serious about the integrity of their modelling capability, Goalfix is the go-to trainer.
Daniel Bopape
Corporate Finance , Exxaro Resources Ltd
Will definitely assist me
Thank you for the financial modelling master class last week. I really found the course very interesting and it will definitely assist me in my work going forward.
Charl Lishman
Financial manager – FNB Africa
Informative and comprehensive
I am new to the Financial Modelling space, but found the Masterclass to be very informative and comprehensive. I appreciate how the material complies with international standards and look forward to applying my new skill-set in the near future.”
Iben Botha
Tsogo Sun
An excellent course!
“t was a pleasure to meet you during the recent financial modelling course. Allow me to congratulate you on an excellent course that I am already starting to use in very practical ways in my day-to-day consulting work.
Willem Buhrmann
Africa Merchant Capital
Invest in your future
Contact us today to find the best course for you or your company