Excel Magic 2: Building Your Own Report Generating Bot (Video) (Course Id 1775)

The course is presented in four parts.

First, the course relates earlier course of Top 5 Excel Skills 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 to 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 … 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

Please Note: This course’s author is working on the providing transcripts, PDFs, and slides where applicable. Unfortunately until then we will not be able to offer them with the course but felt the course was valuable enough as it is so have chosen to include it on our site. Our sincere apologies for any inconvenience and please let us know any question using the support bubble on the bottom right of all pages on our site.

Course Learning Objectives

• Understand VBA macro as 4th Gen of Excel modeling techniques
• Identify 3 elements of a VBA macro
• Recognize when to build a VBA macro and when not to
• Discover 5 elements of a VBA environment
• Explore 5 steps required to build a reporting generating “Bot”
• Understand 4 best practices of building a VBA macro