Excel Magic 2 – Building Your Own Report Generating Bot Free Tutorial Download
What you’ll learn
Intermediate to Advanced Excel skills that will help you
– to ace your Excel skills,
– to find state-of-the art Excel functions,
– to make yourself the go-to-person in their office, or
– to be well positioned for your next promotion!
Example: be able to open one Excel file, etc.
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:
o Define the file path to make file path dynamic
o Create a message box to communicate with users
o 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:
o How to activate the macro
o Add notes for your codes
o Add a message box
Who this course is for:
- Students (Secondary or post secondary), Office workers, Professionals, and Managers