loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Macros in MS Excel (VBA)

Please enter valid question or comment

Please enter your name.

Please enter valid email

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

Share

Macros in MS Excel (VBA)

Macros in MS Excel (VBA)

Malad West, Mumbai

5,000

2 Reviews
0 Interested

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

Recommendations & reviews from previous Customers:

Lavina Bhatia

"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."

attended Macros in MS Excel (VBA)


Kevin

"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."

attended Macros in MS Excel (VBA)


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 8 of 8
M

Milind 11/02/2014

Excel Macro Training, Microsoft Excel Training, Excel Vbscript in saturday & sunday

0 0

Answer

You can add upto 6 Images

U

NIraj 20/08/2013

Hi Sagar,
I'm interested in learning Advanced VBA Macros, Please let me know if you can help in covering the advance topcics eg, linking outlook, access, sql with vba, etc

0 0

Answer

You can add upto 6 Images

Sagar 10/04/2013

Hi Mahesh,

We can discuss this on phone. You can express interest in my workshop and share your phone number or send me a personal message.

Regards,

Sagar Yerunkar

0 0

Answer

You can add upto 6 Images

U

Mahesh 07/04/2013

i would want to learn Macros and also have some projects which we can discuss.

0 0

Answer

You can add upto 6 Images

Sagar 19/03/2013

Hi,

The course can definitely help you in automating several aspects of your work. Please login to UrbanPro and send me a message so that we can take this further.

Regards,

Sagar Yerunkar

0 0

Answer

You can add upto 6 Images

U

Sheetal Patil 16/03/2013

Hi, My job profile includes lots of generating report everyday and analysing them. But most of the time is consumed in generating them. I want to learn writing and editing Macros in Excel as procedure for most of the reports remains more or less the same with some minor change. So thats my intention behind the taking up the course is to focus more...  more » Hi,

My job profile includes lots of generating report everyday and analysing them. But most of the time is consumed in generating them. I want to learn writing and editing Macros in Excel as procedure for most of the reports remains more or less the same with some minor change.

So thats my intention behind the taking up the course is to focus more on analysing and less on data mining.

Thanks,
Sheetal Patil «less

0 0

Answer

You can add upto 6 Images

Sagar 15/03/2013

Hi,

Please can you tell me what details you would like to know?

Regards,

Sagar Yerunkar

0 0

Answer

You can add upto 6 Images

U

SHEETAL PATIL 13/03/2013

I wish to learn Macros in Excel (VBA). kindly provide me the details regarding the course

0 0

Answer

You can add upto 6 Images


Recommendations & reviews from previous Customers:

Lavina Bhatia

"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."

attended Macros in MS Excel (VBA)


Kevin

"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."

attended Macros in MS Excel (VBA)


Date and Time

Not decided yet.

About the Trainer

Sagar Yerunkar picture

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.
Seats Left-

Students Interested 0

Course Id: 6524