Automate your work : Advanced VBA
3.5 (2 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.
50 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Automate your work : Advanced VBA

Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
3.5 (2 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.
50 students enrolled
Last updated 9/2015
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
10 Lectures
01:10:18
+
Introduction: This is where we start
1 Lecture 01:36
+
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
About the Instructor
ATI - Analytics Training Institute
3.9 Average rating
237 Reviews
8,911 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