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!
Requirements
Basic Excel
Example: be able to open one Excel file, etc.
Description
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
Homepage
https://www.udemy.com/course/excel-magic-2-building-your-own-report-generating-bot/

Related Downloads :

{related-news}