Excel VBA Macros Training

We organize Corporate Excel VBA Macros Training or workshops in Mumbai, Kolkata, Bangalore, New Delhi, Gurgaon, Chennai, Hyderabad, Pune etc.

Excel VBA (Visual Basic for Applications) is a programming language that allows you to automate tasks in Excel by writing scripts or macros. VBA can help you save time and improve your productivity by automating tasks that you perform frequently or that require a series of steps to complete.

Key Learning: Automate repetitive tasks | Prepare month-end reports with the click of a button | Automate PowerPoint preparation from Excel reports | User-defined functions (UDF) | Prepare User Forms … and more. For Corporate Enquiry Visit Here

With the aim of equipping with this Ninja-level power. We have developed a 1-day workshop, which has been conducted at prestigious companies, including PwC, EY, ITC, Coca-Cola, Flipkart, Asian Paints, etc.

Outline:

• A: Starting with Excel Advance Functions & Advance Pivot | 2.5 hrs.
• Introduction to OFFSET & INDIRECT
• Advanced Pivot table with feature & Tricks
• B: Introduction to Code Copy & Paste from Google "VBA Code to". | 30 mins.
• Module 01 – Introduction (Folder)
• Introduction to “VBA code to “
• Understanding the Head and tail of the macro
• C: Basic Macro using Record Macro option | 3.5 hrs.
• Module 14 – Recording Macro (Folder)
• Using Macro recording to Separate data into sheets/Excel Workbooks
• Using Macro recording to Merge data into sheets from multiple sheets/Excel Workbooks
• Understanding the difference between normal recording and Relative reference recording
• Using simple Editing techniques and copy & Pasting from recording
• D: Introduction on Writing codes | 30 mins.
• Using OFFSET in VBA to make dynamic reference
• Use of Simple codes with overview of For Each Next
• – (Upper, Lower, [WorksheetFunction.Proper])
• E: Recap of what happened the last day | 30 mins.
• Understanding of Macro
• Recording,Head and tail
• Offset, Ctrl+Shft[Up,Dowm,Right,Left] etc.
• F: Recap of what happened the last day | 20 mins.
• Module 03 – Getting familiar with VBA Interface (Folder)
• Understanding the interface of VBA (Project/Property/Module) etc.
• G: Understanding Data type and Objects | 20 mins.
• Module 02 – Objects, Properties, Methods (Folder)
• Explaining of Object, Property, Method
• Assigning data to containers & understanding data type
• Download Full Training Outline
• H: Understanding Selection techniques | 30 mins.
• Module 04 – Range & Cells Selection Techniques (Folder)
• Module 05 – Range Navigation Techniques (Folder)
• All selection techniques with demonstration (Range,Cell,Navigation)
• I: Declaring Variable & Using them in Loops while understanding their types | 2 hrs.
• Module 06 -Variable & Constant Declaration (Folder)
• Module 09 – Tricks to Speedup Macro process time (Folder)
• Module 08 – Loop, IF & their variations (Folder)
• Understanding the concept of variable declaration
• use of variable declaration in loop and trying out examples of variable loops
• understanding the difference between declaring/not declaring variable
• J: Understanding the use of public/private with some examples | 30 mins.
• Module 07 – Private Vs Public Declaration (Folder)
• Module 11 – InputBox & MsgBox (Folder)
• Difference between InputBox & MsgBox with their variation
• Calling another macro from a different module
• Understanding the use of public & Private sub
• K: Use of Events, Understanding the difference between Form & ActiveX Control | 1.5 hrs.
• Module 10 – Trigger Event-Based on actions (Folder)
• Module 12 – Form & Active X Controls (Folder)
• Use of Form controls on excel file & understand the use (Dashboard,Scroll, Etc.)
• Types of events & ways to trigger them
• L: Creating user form in Excel & by using Form from VBA | 1.2 hrs.
• Using the above knowledge creating a simple form in excel to store data
• Using Form from VBA & ActiveX control to design & program a form
• Storing data in the same file/Separate file