Learn how to building your own report generating robot through VBA

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

Basic Excel

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

Students (Secondary or post secondary), Office workers, Professionals, and Managers



DOWNLOAD
uploadgig


rapidgator


nitroflare