Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Automate your work : Basic VBA to your Wishlist.

Add to Wishlist

Automate your work : Basic VBA

Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
3.8 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
273 students enrolled
Last updated 9/2015
$10 $20 50% off
5 days left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

Nobody likes doing the same things over and over.

Better still, everybody would love it if their tasks get done automatically.

We've designed this course to help you avoid monotonous, repetitive tasks and find ways to do better things with the data your business generates.

What you will learn

1. Use advanced Excel functions to increase productivity.

2. Build comprehensive reports and real time dashboards.

3. Automate report generation

Don't end your learning at the last lecture

1. Use our Facebook page to interact with thousands of other students and professionals. Keep abreast with the market and network with like minds.

2. Win big by participating in data mining competitions at Kaggle. Who knows, if you are really good at it, you can quit your regular job and be a full time Kaggler!

4. Beef up your resume or create a well-designed profile.

5. Stay tuned, we'll be coming out with new advanced courses.

Who is the target audience?
  • This course is meant for anybody who wants to offload their work. Get introduced to automation using VBA Macros. You do not need any programming background, we will teach you how to write and record macros right from the scratch. Get ready to make your computer do your work for you!
  • This course does not cater to the student seeking to learn the VBA comprehensively. Its main focus is Automation. More advanced VBA topics are available in the Advanced VBA course.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Offload your work by automation using VBA Macros!
Eliminate repetitive activities for a smarter work approach
View Curriculum
  • All you need is Microsoft Excel!
  • Should be fairly familiar with working on data spreadsheets at the basic level.
Curriculum For This Course
Expand All 14 Lectures Collapse All 14 Lectures 01:14:06
Advanced Excel (VBA & MACROS) - The A, B, Cs
6 Lectures 22:14

Communication among objects

Examples to justify the communication techniques

Introducing Intangible Hierarchy

Quiz time
6 questions
2 Lectures 06:39
Sentence creation : Connections in Excel

Rules of writing sentences in VBA
Learn more with hands-on : Introducing the platform to write and automate
1 Lecture 05:48
Introducing the platform : VBA window
Small exercises to connect our learning so far
5 Lectures 34:25
Applying Functions in VBA

Applying Properties in VBA

Applying Methods in VBA

Various Ways of Executing a Macro

5 pages

Quiz time
6 questions
About the Instructor
4.2 Average rating
149 Reviews
8,366 Students
13 Courses
Committed to creating a difference

We are an Analytics firm committed to developing intellectual property that will help individuals and their organisation take smarter decisions every day. ATI, the education arm of Redwood Associates has helped 200 companies and over 15000 individuals speak the language of DATA

The founder Gautam Munshi has nearly two decades of high performance analytics experience. His strong belief that anyone can become an analyst has led him to build a team of 12 - a group of math geeks, techies, musicians, comedians, beer enthusiasts, agriculturists, geneticists, teachers and bankers,who have the gumption that they can make a difference and truly believe that analytics can influence and make a huge impact on a day-day basis. It is this diverse lot that brings Analytics to the mind space of every individual. You can view their moments in the lime light here and follow them on Facebook

Report Abuse