Advanced Excel VBA and Macros course in Mumbai

Microsoft Excel is one such tool that we use in our daily life and is used by everyone be it a student, or a professional. Today Microsoft Excel is being used across industries. You must be wandering what’s advance in advanced excel course? Do not worry as it is the same Microsoft excel application which we can use to perform advanced operations like performing complex calculations, analysing voluminous data, auditing workbooks. Not only the advanced features that can be explored but the advanced techniques of recording Macros and writing your own functions and formulas makes the Microsoft Excel application more powerful.

Blog Image

What you will learn?

We enable individuals/ professionals to make decisions for business by using analytic solutions.

An individual can easily avoid the repetitive task by recording it once using Macros. As this could be a time saviour for other productive tasks.

An individual having keen interest in programming can excel his skills by learning the VBA programming and enrich his Excel knowledge.

Our expert trainers teaches the complex Macros using VBA efficiently in an interactive and practical approach with more of hands-on exercises.

Course Content

    • Writing conditional expressions (using IF)
    • Using logical functions (AND, OR, NOT)
    • Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
    • Specifying a valid range of values for a cell
    • Specifying a list of valid values for a cell
    • Specifying custom validations based on formula for a cell
    • Creating subtotals
    • Multiple-level subtotals
    • Creating Pivot tables
    • Formatting and customizing Pivot tables
    • Analysing data in different scenarios using Scenario manager
    • Analysing data using Goal seek
    • Recording and running macro
    • Storing macro in different books
    • Creating buttons and assigning macro to it
    • Creating My Menu
    • Editing macros using VBA Editor
    • Understanding the project explorer
    • Exploring windows properties
    • Modifying code in code window
    • Debugging code
    • Variables, data types and constants
    • Arrays
    • Object Variables
    • Conditional structures (If …. Then, Select Case)
    • Logical Operators
    • Looping constructs (For loops, Do loops, while… Wend)
    • Built-in functions
    • Creating Subroutines
    • Creating forms
    • Form events
    • Creating custom menus and toolbars

Inquire Now