About This Course
The course relates to the earlier course of Top Five Excel Skills – How To Break The Vicious Cycle to drive the concept home: Building your own “Bot” is your ticket to full automation in Excel Modeling!
Next, the course brings the topic of what is a VBA macro and let students consider when and when not to build a macro.
Third, we illustrate 6 required steps to build your own report generating “Bot”, including:
- Define the file path to make file path dynamic
- Create a message box to communicate with users
- Use For, Next, and Loop for iteration
Fourth, the course illustrates 4 real cases that should not require building a VBA macro. These are cases from some VBA courses that are still teaching obsolete Excel skills.
Last, the course explores best practices in building VBA macros. They include:
- How to activate the macro
- Add notes for your codes
- Add a message box
Prerequisites and advanced preparation:
- Should have taken Top Five Excel Skills – How To Break The Vicious Cycle
- Basic Excel knowledge such as being able to open one Excel file and connect to external data files, etc.
Who this course is for:
- Students (secondary or post secondary)
- Office workers
- Professionals, and Managers
Our Promise to You
By the end of this course, you will have learned to create report generating bots.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about automated report generation.
|Section 1 - Introduction|
|Recap Of Prior Excel Course: Top 5 Excel Skills||00:00:00|
|Hierarchy Of Excel Techniques||00:00:00|
|How This Course Is Compared With “Other Similar Courses”?||00:00:00|
|What You Will Get From This Course?||00:00:00|
|Section 2 - VBA Macro Introduction|
|Section 3 - How To Build A "Bot" To Automatically Generate 30 Or More Reports?|
|Challenge: Generating 30 Reports For 30 Locations||00:00:00|
|Building Your Own “Bot” To Generate Reports – Step 1||00:00:00|
|Building Your Own “Bot” To Generate Reports – Steps 2 To 4||00:00:00|
|Building Your Own “Bot” To Generate Reports – Step 5||00:00:00|
|Building Your Own “Bot” To Generate Reports – Step 6||00:00:00|
|How Effective Is This “Bot”?||00:00:00|
|Section 4 - Actual Cases To Avoid Using Macros|
|When There Is A Better Way: Above 4th Gen!||00:00:00|
|When The Whole Process Does Not Make Sense In The First Place!||00:00:00|
|Section 5 - VBA Best Practices|
|How To Activate The Macro?||00:00:00|
|Add Notes For Your Codes||00:00:00|
|Add Message Box And Make Bite-Sized Macros||00:00:00|
|Section 6 - Conclusion|