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)" is no longer available

No Reviews Yet

Malad West, Mumbai

Course ID: 6524

Malad West, Mumbai

Sagar Yerunkar picture
Sagar Yerunkar
No Reviews Yet

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

Date and Time

Not decided yet.

About the Trainer

Sagar Yerunkar picture

Avg Rating

Reviews

Students

Courses

Sagar Yerunkar

B.E. Computers, MBA

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.

Reviews

No reviews currently
Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, 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 UrbanPro.com. 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