Learn Excel Macros using VBA

Course Description

What is a Macro? A macro is a term for a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task associated with those commands.

Why should you use an Excel Macros?

• Makes complex computations easier to perform.
• Macros record your keystrokes while you work.
• Reduces the possibility of human error that increases with many, repetitive keystrokes and tasks.
• Reduces the amount of time that must be spent performing basic computing tasks, freeing users up for more complex problem-solving and idea-generating activities.
• And, it is easy to create, store and use.

Learn Excel Macros using VBA online course helps you pick up Macros and its essential features. Study notes in form of documents will also be shared so that you get access to material for future reference.

Learn Excel Macros using VBA online course package:

• 10 LIVE interactive online classes + Access to class recordings
• Course timings in IST: Weekdays between 11 AM to 1 AM and 7 PM to 10 PM and Weekends between 7 AM to 10 PM
• Documents containing some sample macros shared for future reference

Learn Excel Macros using VBA Course Outline:

• Recording and Running Macros
• Visual Basic Grammar
• Writing your own Macros
• Referencing Cells and Ranges
• Decisions
• Repeating actions - Loops
• Passing information and Determining the extent of data.
• Working with pivot tables
• Error Handling
• Custom dialog boxes and Custom functions