Automate your work : Advanced VBA

Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
0.0 (0 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.
39 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 10
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

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

What are the requirements?

  • All you need is Microsoft Excel!
  • Basic familiarity with handling data will help

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction: This is where we start
Introduction to Advance VBA
Preview
01:36
Section 2: Implementation on a case study
Explaining case study for hands on learning
Preview
02:10
Understanding the IF statements
Preview
11:23
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
Section 3: Functions and Events can also be customised
Events to self execute your Macros
10:19
Creating your own functions in Excel
10:20

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

ATI - Analytics Training Institute, 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

Ready to start learning?
Take This Course