Automate your work : Advanced VBA
2.7 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
75 students enrolled

Automate your work : Advanced VBA

Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
2.7 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
75 students enrolled
Last updated 11/2017
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Reduce your work by automating it using VBA Macros
  • Save significant time and effort by implementing advanced macros to take your VBA expertise to a whole new level
Requirements
  • All you need is Microsoft Excel!
  • Basic familiarity with handling data will help
Description

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 this course is for:
  • This VBA course is meant for anybody who is willing to learn to offload their work. You do not need to have any programming background, although a basic knowledge of VBA is preferred for which you can go through the basic version of this course.
  • This course is not for someone who is averse to data and hasn't ever worked on a spreadsheet before
Course content
Expand all 10 lectures 01:10:18
+ Implementation on a case study
7 lectures 48:03
Converting constants to variables
04:19
Understanding Loops : For Next
05:49
Understanding Loops : Do Loops
10:24
Recording a Macro : Hand Holding/On-job training to Macros
07:22
Trailing Macros - one after another
06:36
Quiz Time
6 questions
+ Functions and Events can also be customised
2 lectures 20:39
Events to self execute your Macros
10:19
Creating your own functions in Excel
10:20