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
The method used in our training emulates our live face-to-face training method.
Originally created as a response to COVID, it has been refined and improved over time and based on delegate feedback, has proven most successful.
Delegate are supplied with a complete digital course manual and all relevant Excel data files.
The same interactive training method is exactly the same as our live face-to-face sessions. All courses are designed to introduce best practice modelling methods and processes using MS Excel as the model building tool.
The key to successful modelling lies in the application of correct modelling procedures, model design and structure. These core principles are explained and demonstrated using a combination of detailed course notes and Excel files.
Delegates work through various practical exercises under the supervision, and with the help, of the instructor to get to grips with practical modelling techniques. All Excel functionality necessary and essential to model building is comprehensively explained and supported by appropriate Excel examples and exercises.
All courses are hands-on with the objective is to empowering delegates to build a financial model from first principles. Courses are based on the FAST international modelling standard. The training is presented via Zoom or Teams depending on client preferences
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