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.
269 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 14
  • Length 1 hour
  • Skill Level All Levels
  • 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!
  • Should be fairly familiar with working on data spreadsheets at the basic level.

What am I going to get from this course?

  • Offload your work by automation using VBA Macros!
  • Eliminate repetitive activities for a smarter work approach

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

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: Advanced Excel (VBA & MACROS) - The A, B, Cs
Introduction to VBA programming
Preview
03:52
04:15
Hierarchy as a vocabulary of a language
Preview
02:59
Communication among objects
03:24
Examples to justify the communication techniques
03:33
Introducing Intangible Hierarchy
04:11
Quiz time
6 questions
Section 2: Grammar
Sentence creation : Connections in Excel
02:09
Rules of writing sentences in VBA
04:30
Section 3: Learn more with hands-on : Introducing the platform to write and automate
Introducing the platform : VBA window
05:48
Section 4: Small exercises to connect our learning so far
Applying Functions in VBA
11:12
Applying Properties in VBA
09:24
Applying Methods in VBA
04:13
Various Ways of Executing a Macro
09:36
Summary
5 pages
Quiz time
6 questions

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