An online course that will open all the MS Excel courses we offer and would be the equivalent of 10 days of live MS Excel courses.
When you sign up you get access to 7 separate courses so that you can learn in increments. This course is perfect for anyone who uses MS Excel regularly and wants to consolidate their current knowledge.
Details about the Online Beginner MS Excel portion of the Course. With over 60 lessons, 130 video clips, and 28 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
This portion of the course will give you the fundamentals to make sure it is easy to learn anything about Excel.
Details about the Intermediate MS Excel Online portion of this bundled course. With over 133 lessons, 260 video clips and 48 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
This portion of the course builds on the Fundamental knowledge from the beginner course and teaches you to solve problems in Excel with a particular focus on the tools available.
Details about the Advanced MS Excel Online portion of the course bundle. This course has over 141 lessons, 240 video clips and 68 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
The final portion of the course takes your Intermediate knowledge and goes one step further, solving more complex Excel problems with tools and a particular focus on the functions and formula you will need to use.
No matter what your client says, the data you get is never in EXACTLY the correct format. You will need to do some cleaning up and scrubbing to make it useable. This course shows you all the tips and tricks with cleaning up data.
PowerQuery is the free new tool in Excel that is built for data cleanup issues. It solves all the problems that you thought you needed VBA for and makes it easy to automate regular data cleanup processes.
Once you know what you are trying to tell your client, you need to be able to convert it to meaningful, reusable reports and visualisation to help the client understand the issues. This course shows all the tips on how to build Excel dashboards and management reports.
Details about the Financial Modelling with MS Excel Online portion of this bundled course. With over 115 lessons, 200 video clips and 45 example exercises with detailed video solutions explaining exactly how you should have got to the answer.
This portion of the course builds on the Advanced knowledge from the previous course and teaches you to solve problems in Excel with a particular focus financial modelling, budgeting and forecasting.
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."
Free Excel Tips & Tricks delivered straight to your mailbox. Sign up today
