Signup as a Tutor

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

Macros in MS Excel (VBA)

2 Reviews

Malad West, Mumbai

Course ID: 6524

Malad West, Mumbai

Students Interested 0 (Seats Left 0)

₹ 5,000

2 Reviews

Date and Time

Not decided yet.

Sagar Yerunkar picture
Sagar Yerunkar

B.E. Computers, MBA

3 Years of Experience

About Sagar Yerunkar

I am quite passionate about programming and have over 15 years of programming experience.

Apart from working in the IT industry for almost 3 years, I also have developed a couple of games for the Blackberry platform.
L

Lavina Bhatia

Attended Macros in MS Excel (VBA)

Sagar had conducted Excel Macros training session in our organisation Welspun and the training was spread over 3 days. The topics covered were very concisely taught. His excel expertise level is very good and his teaching skills are commendable. He conducted this training voluntarily, yet the training was well structured and timed. It was indeed a great experience learning a topic such as Macros, which is found tough by many people. Yet Sagar explained in a very simple manner.

K

Kevin

Attended Macros in MS Excel (VBA)

He has extensive knowledge on the subject plus he has the ability of simplifying such programming concepts for non programmer and enable them to write macros for their own use in daily life. I have learnt and applied based on training recevied from his end and wrote one macro for my financial model.

About the Course

This workshop is focused toward working professionals who need to learn Macros in Excel (VBA) for improving their efficiency. The course assumes no knowledge of previous programming experience.

Topics Covered

1. Let's quicken up things quickly
Create a macro using the Macro Recorder and demonstrate how it can speed up work
2. Getting Acquainted
A tour of the environment in which macros are written. We shall write our first macro from scratch and get introduced to a few programming concepts. We shall further explore user defined functions in Microsoft Excel.
3. OOPs!
A brief overview of Object Oriented Programming concepts and how they are applicable to macros in MS Excel.
4. Creating your own Dialog Boxes
Get inputs from users
5. Programming Concepts : Collections
Detailing the types of collections available in the MS Excel Object Model
6. Programming Concepts : Flow control structures
Small and simple macros are no fun? Direct the flow of your code and create powerful macros using flow control structures like If-Then-End If, Do-While-Loop, For-Next

Who should attend

Working professionals who wish to increase their efficiency in using Microsoft Excel.

Pre-requisites

Basic knowledge of Microsoft Excel.

What you need to bring

A pen, a notebook. Preferably a laptop. If a laptop is not available, a flash drive would be needed.

Key Takeaways

Writing Macros in Excel (VBA).
Become an Excel Poweruser

Reviews (2) See all Reviews

L

Lavina Bhatia

Attended Macros in MS Excel (VBA)

Sagar had conducted Excel Macros training session in our organisation Welspun and the training was spread...

K

Kevin

Attended Macros in MS Excel (VBA)

He has extensive knowledge on the subject plus he has the ability of simplifying such programming concepts...

Students Interested 0 (Seats Left 0)

₹ 5,000

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
₹ 5,000 Enquire

Enquire

Submit your enquiry for Macros in MS Excel (VBA)

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Sagar

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com 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 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