MS Excel Automation Course
Self-paced Online
R 2,150 pp
11 hrs of videos
Live Online
N/A
Live Onsite
R 5,850 pp*
2-3 days
* Live Training is for groups of 6 or more - Prices Ex. Vat
Course Overview
This course takes the automation concepts introduced in the Advanced course to the next level and beyond!- Recorded Macros
- Power Query
- Power Pivot
- Word and Power Point Integration
- Visual Basic for Application
Course Content
Recording a Macro is one of the simplest ways to start automating your repeatable tasks. You just need to be aware of a few Tips and Tricks to enable your recorded code to run on New Data.
If manipulating Data is your main automation requirement then Power Query is your go-to Tool. We quickly discover that for cleaning up data this tool if far superior than a recorded Macro and as a result forms the core component of the course.
Uses the underlying Data Model and DAX Formula to build complex Pivots from multiple tables. (As this is not actually an automating tool it’s an optional extra for the onsite version of the course)
If you use PowerPoint (or Word) as your reporting vehicle, then this section helps complete the Source-to-Report loop of dynamically updating your Data from Excel.
The new kid on the block (aka Power Query) as fantastic as it is, can’t automate everything Excel, whereas VBA (Macros) can. We introduce you to the basics of VBA and use some classic Excel Requirements to show you how you can adapt Googled code from the Internet to suite your own auotmation requirements.
Next Step ...
For further specific information for our various training options use the links below; or alternatively contact us on hello@summitsolutionstraining.co.za or 086 167 3923.
Course Reviews
Awesome
Aphiwe Sihlahla – Aeroklasduys.co.za
Very informative
Very informative and well presented
Jaco Erasmus – Stewarts and Lloyds
The interactive worksheets makes it easy to follow and creates the ability to see where you might struggle or addresses any questions that you might have. I had so much fun! Thank you
Hansie Steyn – Stewarts and Lloyds
learned a lot
Elsie Van Wyk – Stewarts and Lloyds
Really learned a lot that will help to save time on reports
It was a great course!
It was a great course!
Maybe more in-depth sections on VBA, PowerPivot and Power Query
