1 / 8

Macros Online Training

Get a basic understanding of Excel VBA and learn how to make efficient use of macros in Excel. An online training on Macros shows you how to automate repetitive tasks and save yourself from the boredom of such tasks.<br><br>For more info: http://www.multisoftvirtualacademy.com/microsoft/ms-macro-vba-excel-online-training<br>

multisoftvirtualacademy
Télécharger la présentation

Macros Online Training

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Macros Let’s Get Started!

  2. Objectives • Overview of Macros • Macros Online Training • Course Content of the Training • Learning Outcome of the Training • Target Audience

  3. 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.

  4. 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.

  5. 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

  6. 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

  7. Target Audience This online training is intended for the candidates interested in: • Data analyst • Report creators • Decision makers

More Related