Excel Automation: Learn VBA & Macros From Scratch!
4.6 (159 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.
534 students enrolled

Excel Automation: Learn VBA & Macros From Scratch!

Learn how to use VBA, to build your own custom Automations in Excel|Simple most language used for Absolute Beginners
4.6 (159 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.
534 students enrolled
Created by Kamal Vaswani
Last updated 11/2019
English
English [Auto]
Current price: $132.99 Original price: $189.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7 hours on-demand video
  • 8 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • 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
  • Learn the Fundamentals of coding, to be able to Understand, Read & Write your own codes
  • Learn the Combined use of Writing & Recording to build full fledged Automations of your own
Requirements
  • Tool: Microsoft Excel 2007 or later
  • Knowledge: Excel Knowledge is a strict prerequisite for this course
Description

This course is built for Existing Excel users who would like to make their life more simpler and smarter by automating manual/repetitive work in Excel.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

FAQs

Q: I've never done coding before and have no background to VBA. Can i still learn it?

A: Yes, This course is mainly targeted to those who are absolutely new to coding/programming. I've trained over 1000 students with no programming background successfully. 

Q: I'm not a great learner, I find difficulty understanding and working with codes/programming. can i learn it?

A: I consider myself as the worst student. So if i can learn it, you can too. 

Q: Why is coding/programming considered so difficult? Can a person with not a great memory learn it?

A: Anything is difficult to remember and understand, if you do not have ample background to it, which answers the "WHYs?" of those concepts. Moreover, I'm myself the person who's not too great at memory, and that makes me ensure that I use simple language, with relatable examples and provide ample background to the concepts in my course. 

Q: I know how to record macros and I'm doing pretty well? What more this course has to offer?

A: Recording is just one part of your learning. there are many more concepts in VBA which a person should know, to get smarter and more efficient at coding. This course doesn't revolve around recording the macros only. It focuses more on how to Write the macros from scratch. The idea is to make sure you are able to understand the codes so well, that it becomes easy for you to make more smarter macros going forward. Refer to the course contents of this course to know the details of what will be covered in this course.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 "If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first"  -  

This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you learn it correctly and can re-implement the concepts when required.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

After completing this course you will be able to:

  1. Build your own full fledged macros from scratch!
  2. Write your macros
  3. Understand your macros
  4. Edit/Modify your macros to improve performance
  5. Create your own User Defined Functions
  6. Auto execute Macros on Several Events.
  7. Re implement the concepts to different problems
  8. Start Loving to code (in case you currently don't)

Looking forward to having more interactions with you in the course.

Happy Learning!

Who this course is for:
  • Anyone who wants to automate their work in Excel to save Time and Energy spent on manual work
  • Average or above average Excel Users
Course content
Expand all 52 lectures 07:04:25
+ Theory
15 lectures 01:11:32
Object Oriented Programming Language - Made Easy
03:14
Object Referencing in VBA
05:33
Object Within Object Referencing in VBA
08:35
Function Referencing
06:20
Understand Properties and Methods
02:10
Intro to VBA Window and Writing Macros
07:10
Saving your Macros
02:16

Enable All Macros (Not Recommended, Potentially dangerous code can run)

The above is the option you should enable carefully. However, unless you receive and open files from non trusted sources or you are not going to implement dangerous codes (I'm not teaching that) you shouldn't worry about it much. I have this enabled for me too!

Enabling Macros
00:31
Connections
02:33
Connections(1/3): Objects & Functions
07:39
Connections(2/3): Objects & Properties
06:46
Connections(3/3): Objects & Methods
02:58
Different ways you can execute your Macros
11:23
+ Writing your Macros
9 lectures 01:05:08
Intro To Section
00:50
Variables
07:56
Range Loop - FOR
11:56
Solve this assignment to test your understanding on the Range Loop (For Loop) and other things that you've learn't so far. Let's see how much have you learnt!
Range Loop
1 question
Conditional Loop - DO
06:39
Solve this assignment to test your understanding on the Conditional Loop (Do Loop) and other things that you've learn't so far. Let's see how much have you learnt!
Conditional Loop
1 question
Conditional Statement (IF, AND, OR)
08:58
Practice writing a macro with a simple conditional statement using IF
Conditional Statement (IF)
1 question
Practice writing a macro with a conditional statements using Nested IF
Conditional Statement (Nested IF)
1 question
Practice writing a macro with a conditional statements using Nested IF with AND/OR
Conditional Statement (IF with AND/OR)
2 questions
Select Case Statements
07:50
Implement your learning from the Last Video about Select Case Statements.
Select Case Statements
1 question
How to make your Macros - Smart
05:16
Error Handling
13:27
What's next ?
02:16
+ Recording Macros
2 lectures 12:16
Introduction
03:10
How to Record?
09:06
Assuming you have a common data that you work upon every time and you need the duplicates to be removed from it. It may be time consuming to always define the similar commands to the Remove Duplicate Tool. In that case, if you have a single button to do the task, it'll be simple.
Remove Duplicates
1 question
Its an assignment to make one of the Data Cleaning steps easier to use by assigning it to a button.
Delete Blanks
1 question
+ Complete Macros (Writing + Recording)
3 lectures 15:52
Introduction to Section
02:24
Delete Rows with NULL values in the Gender Column for all the Sheets available
Delete Rows in all the available sheets
1 question
This Assignment will save you tons of time at work if you work on multiple data on different sheets which can be a pain consolidating manually.
Consolidate Sheets Using a Macro
1 question
Execute Multiple Macros with a single Button
10:42
ScreenUpdating Property
02:46
+ Sub Routine
6 lectures 30:01
Introduction
03:11
Example - Button Click
02:56
Example - Keyboard Shortcut
02:11
Example - Custom Keystroke
08:40
Example - Scheduling Macros
11:58
Summarizing Sub Routines
01:05
Apply your understanding from this course so far to solve this assignment where you need a button based data splitting
Split the Data
1 question
+ Private Sub Routines
5 lectures 23:49
Introduction
04:40
Example - WorkBook Open Event
06:26
Example - WorkBook Close Event
05:00
Example - Change Event
06:40
Summarizing Private Sub Routines
01:03
Practice your understanding on Private Sub with this Assignment
Auto Delete on Saving
1 question
+ Function Routines
3 lectures 19:59
Introduction
01:24
Understand How to create a Basic Function (Static output)
10:19
Understand How to make your Function Dynamic (Using Cell references as input)
08:16
Use your learning from this section and see if you can build a useful function all by yourself.
Create a Function to Extract Numbers
1 question
+ Global Macros
6 lectures 31:34
Introduction to Global Macros
02:59
What is an Excel ADD IN?
06:09
Global Macros - SUB
09:35
Global Macros - FUNCTION
04:05
Global Macros - PRIVATE SUB
04:42
Closing
04:04