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.

Excel VBA Macros Training | Course Outline

Program Name: Excel VBA Macros
Software: Microsoft Excel
Level: Advanced
Duration: 12-14 hrs.

Learning Material: Datasets-based case studies, PDF and YouTube videos from our channel for revision

Delivery Style:

  • Hands-on practice (Demo -> Practice side-by-side).
  • First, show a demo with the problem statement and solution.
  • Then, slow down the pace to let people practice along with the Instructor.

A: Starting with Excel Advance Functions & Advance Pivot | 2.5 hrs.

  1. Introduction to OFFSET & INDIRECT
  2. Advanced Pivot table with feature & Tricks

B: Introduction to Code Copy & Paste from Google "VBA Code to". | 30 mins.

  1. Module 01 – Introduction (Folder)
  2. Introduction to “VBA code to “
  3. Understanding the Head and tail of the macro

C: Basic Macro using Record Macro option | 3.5 hrs.

  1. Module 14 – Recording Macro (Folder)
  2. Using Macro recording to Separate data into sheets/Excel Workbooks
  3. Using Macro recording to Merge data into sheets from multiple sheets/Excel Workbooks
  4. Understanding the difference between normal recording and Relative reference recording
  5. Using simple Editing techniques and copy & Pasting from recording

D: Introduction on Writing codes | 30 mins.

  1. Using OFFSET in VBA to make dynamic reference
  2. Use of Simple codes with overview of For Each Next
    – (Upper, Lower, [WorksheetFunction.Proper])

E: Recap of what happened the last day | 30 mins.

  1. Understanding of Macro
  2. Recording,Head and tail
  3. Offset, Ctrl+Shft[Up,Dowm,Right,Left] etc.

F: Recap of what happened the last day | 20 mins.

  1. Module 03 – Getting familiar with VBA Interface (Folder)
  2. Understanding the interface of VBA (Project/Property/Module) etc.

G: Understanding Data type and Objects | 20 mins.

  1. Module 02 – Objects, Properties, Methods (Folder)
  2. Explaining of Object, Property, Method
  3. Assigning data to containers & understanding data type

H: Understanding Selection techniques | 30 mins.

  1. Module 04 – Range & Cells Selection Techniques (Folder)
  2. Module 05 – Range Navigation Techniques (Folder)
  3. All selection techniques with demonstration (Range,Cell,Navigation)

I: Declaring Variable & Using them in Loops while understanding their types | 2 hrs.

  1. Module 06 -Variable & Constant Declaration (Folder)
  2. Module 09 – Tricks to Speedup Macro process time (Folder)
  3. Module 08 – Loop, IF & their variations (Folder)
  4. Understanding the concept of variable declaration
  5. use of variable declaration in loop and trying out examples of variable loops
  6. understanding the difference between declaring/not declaring variable

J: Understanding the use of public/private with some examples | 30 mins.

  1. Module 07 – Private Vs Public Declaration (Folder)
  2. Module 11 – InputBox & MsgBox (Folder)
  3. Difference between InputBox & MsgBox with their variation
  4. Calling another macro from a different module
  5. Understanding the use of public & Private sub

K: Use of Events, Understanding the difference between Form & ActiveX Control | 1.5 hrs.

  1. Module 10 – Trigger Event-Based on actions (Folder)
  2. Module 12 – Form & Active X Controls (Folder)
  3. Use of Form controls on excel file & understand the use (Dashboard,Scroll, Etc.)
  4. Types of events & ways to trigger them

L: Creating user form in Excel & by using Form from VBA | 1.2 hrs.

  1. Using the above knowledge creating a simple form in excel to store data
  2. Using Form from VBA & ActiveX control to design & program a form
  3. Storing data in the same file/Separate file

M: Uder Define Function (UDF) | 30 mins.

  1. Module 13 – User Defined Functions (UDF) (Folder)
  2. Simple Function created by user
  3. Using If/Select Case for UDF
  4. Using Google to get UDF “VBA code to”

FAQs:

Corporate Excel training is designed to help employees learn how to effectively use Excel for tasks related to their job duties. Corporate Excel training can help employees work more efficiently and effectively, and may also help improve the overall productivity of the organization.

Corporate Excel training is typically attended by employees who use Excel as part of their job duties, or who need to learn Excel for a specific project or task. This may include people in a wide range of roles, such as finance professionals, salespeople, marketing professionals, and administrative staff.

There are several benefits of corporate Excel training, including: Improved efficiency, Increased accuracy, Enhanced data analysis skills, Better teamwork, etc.

There are no specific prerequisites for learning Microsoft Excel. However, having a basic understanding of computers and how to use them may be helpful. Overall, the most important prerequisite for learning Excel is a willingness to learn and a desire to become proficient with the program. With some practice and patience, anyone can learn how to use Excel effectively.

WHAT STUDENT SAYS

Pre-Training Prep Course Testimonials

Kapila Basnayake
Causeway Paints
Read More
It is highly appreciating the way he teaches us. We are a much more comfortable zone to understand since we are in the beginning.
Prasoon Mehra
EY
Read More
The video and modules illustrated were good with the proper shortcuts mentioned. a great training prep.
Sanyam Kalra
PwC
Read More
This Excel Speed Training was really helpful and informative. Shortcuts were really good to know. Flash Fill. Vlookup and Pivot Table as well. Helped me get to the next level. A big thanks to PwC and Yoda Learning Team for introducing me to this course.
Harsh Bhati
PwC
Read More
It's short, and concise yet pretty informative, your way of describing things and the edits mentioning the shortcuts on the screen helped me with the learning.
Vishal Sharma
PwC
Read More
The way these sessions are planned is way more helpful than physical training in the classroom. These are very much helpful.
Chandni Lakdawala
PwC
Read More
Now I can easily and efficiently use excel. Also really good and quick coverage Of the topics.
Mohit Kumar
EY
Read More
Pre-Training preparation is very crisp and really useful to refresh the formulas for advanced training.
Ankit Singh
EY
Read More
All the concepts were explained very clearly and were easy to understand. The information conveyed was relevant and is really going to be handy.
Kavya Gupta
PwC
Read More
All the topics were relevant and can be used in day-to-day projects. Very insightful and informative topics were covered.

WHAT STUDENT SAYS

Post-Training Testimonials

Kaustubh Raul
EY
Read More
It was a superb and 2 ways session. The trainer made it so comfortable and easy for everyone though for almost everyone this is was the very first time to be working on Power BI.
Anushree krishania
EY
Read More
It was excellent!! Very very worthwhile to attend it. Thank you so much, and I hope to have more sessions.
Pushkar Thakur
PwC
Read More
Just excellent. Such detailed explanation and patience, Sir, has no word other than 'excellent.' When training can be tedious, Sir has made the session interactive and not just for the namesake; because it's so exciting and accurate to its name Sir has done justice to the 'advanced excel training.' Kudos!!
Chetan Nagaraju
Razorpay
Read More
The presenter was able to explain all aspects clearly. He was patient and was able to answer all Qs.
Chirag Jain
ITC
Read More
The session was great, and the way the trainer told things was convenient and easy to understand.
Diganta Kakati
T&A Consulting
Read More
So far, I have enjoyed the session. It was very informative and exciting. I like the pace that the trainer conducts the session. Looking forward to learning more new and exciting stuff.