Macros Let’s Get Started!
Objectives Overview of Macros Macros Online Training Course Content of the Training Learning Outcome of the Training Target Audience
Overview of Macros A macro is a series of commands and functions present in Microsoft Excel that is used to automate the repetitive tasks. These commands are stored in a Microsoft Visual Basic module and can be run anytime to perform the task associated with those commands.
Macros Online Training The Macros online training provides a basic understanding of Excel VBA and will also enhance your knowledge of recorded Macros. This training also enlightens you about the skills necessary to automate Excel and how and where Macros can be useful in Excel. The training shows you how to run a macro, make small changes to it and save it to your personal macro workbook. The training module is designed in such a manner that those with very less to zero level of knowledge about programming can also easily grasp the content of the training.
Course Content of the Training Macro Introduction Learn About Programming Introduction to Flow Chart & Diagram Getting Started with VBA VBA Excel Object Operators, Data Types & Variables Conditional Statement Loop Statement VBA User Forms- Part-1 VBA User Forms- Part-2 Advance VBA Programming Dashboard
Learning Outcome of the Training By the end of the training, you will be able to perform the following tasks: Understand what macros can do for you Run and Record macros Create a Personal Macro Workbook Expand a macro with statements Use absolute and relative references Test a macro in step mode and Join two macros Use loop structures and Streamline macros
Target Audience This online training is intended for the candidates interested in: Data analyst Report creators Decision makers