Automate your work : Basic VBA
3.8 (18 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.
307 students enrolled

Automate your work : Basic VBA

Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
3.8 (18 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.
307 students enrolled
Last updated 9/2015
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
  • 1 downloadable resource
  • 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
  • Offload your work by automation using VBA Macros!
  • Eliminate repetitive activities for a smarter work approach
Requirements
  • All you need is Microsoft Excel!
  • Should be fairly familiar with working on data spreadsheets at the basic level.
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 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.
Course content
Expand all 14 lectures 01:14:06
+ Advanced Excel (VBA & MACROS) - The A, B, Cs
6 lectures 22:14
Communication among objects
03:24
Examples to justify the communication techniques
03:33
Introducing Intangible Hierarchy
04:11
Quiz time
6 questions
+ Grammar
2 lectures 06:39
Sentence creation : Connections in Excel
02:09
Rules of writing sentences in VBA
04:30
+ Small exercises to connect our learning so far
5 lectures 34:25
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