Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Excel Macros/VBA Training

4 Reviews

Course type: Online Instructor led Course

Platform: Goto Meeting, Google Hangout

Course ID: 24792

Course type: Online Instructor led Course

Platform: Goto Meeting, Google Hangout

Students Interested 0 (Seats Left 0)

4 Reviews

About the Course

This Excel training is to help everyone to learn, develop and to get exposure to their MS-Excel knowledge. It will help you to get knowledge on various world class examples. This training is based on the practical experience and not just an explanatory course. This aim of this training is to make users expert in excel.

Topics Covered

1. What is VBA
2. How to launch VBA
3. What all you could do with VBA
4. Who can use VBA
5. Different types of Variables
6. Procedures & Objects
7. About Functions
8. Input Values
9. Formatting Data
10. Formatting a Table & its Data
11. How to Display a Message Box
12. Displaying Message Box with Symbol
13. Displaying Message Box with a Heading
14. IF Conditions
15. Nested IF
16. IF AND
17. IF OR
18. Do While
19. For Loop – Very Important
20. Nested For loop
21. Introduction of Select Case statement
22. Use of Select Case
23. How to Save Macros
24. How to Reuse of Macros
25. How to Create an Excel Sheet
26. How to Navigate to an Excel Sheet
27. How to Input Data on a New Sheet
28. How to Copy Data from one Sheet to Another
29. How to Delete an Excel Sheet
30. How to Create an Excel File
31. How to Open an Excel File
32. How to Input Data on a New File
33. How to Copy Data from an Opened File
34. How to Save a Workbook
35. How to Close an Opened Excel Workbook
36. Understand the Data Structure
37. Consolidate Data
38. Sort Data by Ascending
39. Sort Data by Descending Order
40. Sort Data through a Combination of Two or Multiple Columns
41. Select & Deleting Only Blank Cells
42. Auto Filter Object
43. Custom Filter
44. Understanding of Pivot Tables
45. How to Create & Use Pivot Tables through VBA
46. How to Refresh an Existing Pivot Tables
47. How to Filter in a Pivot Table
48. What is a User Form?
49. Various Types of Control Forms
50. Adding Controls to the User Form
51. How to Create a Simple Application Using User Form
52. How to play around with the Imported Data
53. How to Hide & Unhide Excel Sheets
54. How to do Hide Excel Sheets and to restrict not to unhide it
55. Customizing Quick Access Toolbar
56. Homework:Home Work given to Trainees to Explore the Topics and learn it effectively
57. VBA project: How to Create Individual Trackers and Consolidate the Data in a Single File

Who should attend

Who has passion towards learning Excel Macros and Interested to automate the process/task through Excel VBA


Knowledge of Excel & Advanced Excel

What you need to bring

As this is an online training, require an internet access and will contact for further details once interested"

Key Takeaways

At the end of the class students will be able to write Excel formulas through macros and can work on excel automation projects as well.

Date and Time

Not decided yet.

About the Trainer

Uday Kumar picture

5 Avg Rating

5 Reviews

4 Students

3 Courses

Uday Kumar

B.Com (Computers)

4 Years of Experience

About 6 years of experience in training and have been working on excel projects and automation for corporate.

Student Feedback


Average Rating




Christophil Varghese

An excellent trainer who drives you to attain solutions to the problems at hand with data.


Mathew Blake

I can give ***** rating for his training as he explains complex topics in a simple way with lot of industry examples.


Mathew Blake

I enrolled online class for excel training in July, 2014. He has a very good selection of topics and a plenty of valuable tips, but I enjoyed the advanced formulas section a lot. The first day we had a problem in connecting class through online, however it was fine on the second day on-wards.



Your kindness and enthusiasm for Excel are fantastic. The numerous shortcuts that you teach are invaluable. The best thing about his training is, its very simple and easy to understand.


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now


Submit your enquiry for Excel Macros/VBA Training

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Uday

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more