Course Length: 80 Lessons | 11 hours of Videos.
Total course duration: 9 – 11 hours
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
This course comes into its own is when we start applying these automation components on your own data. When you start to see your manual processes that seem to take forever, now being automated in a matter of minutes, it truly is mind blowing!
Intro to creating Graphs and using Conditional Formatting.
Intro to Excels Golden Rule and the subsequent requirement to lock a cell reference in a Formula by using Absolute Cell References. ($A$2)
A sneak peek at this most Powerful Excel Tool.
VBA has been around almost as long as Excel itself, and unlike Power Query, which specifically helps us to acquire and manipulate data, VBA enables us to automate absolutely anything in Excel. As “Visual” and “Basic” as it is, it is still a coding language, which can be a little tricky to get your head around. In this section we help you understand some Key Coding components, such as Variables, Properties and Methods. Plus some useful coding practices such as For-Loops and If-Statements. We then use this knowledge, to modify some downloaded Code Snippets off the Web, and pop them into our very own Customised Ribbon! This last section is pretty straight forward and enables us to leverage the advantages of existing VBA Code without having to really understand it.