Automate your work : Basic VBA
3.9 (13 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.
276 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Automate your work : Basic VBA

Embrace Excel Automation: Learn to run VBA (Macros), build dashboards, and automate reports with powerful case studies.
3.9 (13 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.
276 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
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Offload your work by automation using VBA Macros!
  • Eliminate repetitive activities for a smarter work approach
View Curriculum
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 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
+
Learn more with hands-on : Introducing the platform to write and automate
1 Lecture 05:48
Introducing the platform : VBA window
05:48
+
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
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