Mastering MS Excel VBA For Beginners
4.5 (177 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.
3,857 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering MS Excel VBA For Beginners to your Wishlist.

Add to Wishlist

Mastering MS Excel VBA For Beginners

Learning MS Excel VBA from beginner level to advanced level
4.5 (177 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.
3,857 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Write VBA Code to automate the things you do in Excel
Use VBA Code to do things in Excel that otherwise wouldn't be possible
Save precious time at work by automating repetitive Excel tasks
Impress your colleagues and managers
Improve your hiring skils
View Curriculum
Requirements
  • MS Excel 2007 and later
  • No prior programming knowledge
  • No prior VBA knowledge
  • Very basic MS Excel knowledge (Like how to reference a cell by row and column and how to write a simple excel formula in a cell.)
Description

Interested in learning VBA for Microsoft Excel? Well, you’ve come to the right place. My Mastering VBA for Excel will take you from beginner to master in a very short time. Join me on this journey and allow me to teach you VBA for MS Excel.

So why learn MS Excel VBA. MS excel is already a very easy to use piece of software and very flexible. It has a myriad of uses. Learning VBA for MS Excel, will allow you to automate existing things you do in Excel, so that you can save time and make your life easier. It can also make excel do things that you would never have been able to do without VBA.

You can use these skills to make your day to day working life easier, impress your colleagues or your boss.

Learning MS Excel VBA is a life skill that will not be wasted. There will always be an opportunity to use it.

This course consists of over 50 easy to follow videos. That equates to over 5 hrs of fun learning. If you want to, you can learn excel VBA in one week, by spending an hour each day. With some extra time for practicing. However, I would recommend doing it a bit slower, say 2-3 videos a day, with lots of coding practice.  All code used in the videos are made available for you to download.

Who is the target audience?
  • Anyone that uses MS Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 55 Lectures Collapse All 55 Lectures 05:58:10
+
1. Introduction
3 Lectures 08:58

1.1 Introduction to VBA for MS Excel
03:46

1.2 Download Course Materials
00:12
+
2. Getting Started
8 Lectures 01:16:28



2.4 Object Hierarchy
14:33

2.5 Variable Basics
11:41

2.6 Set Command
05:05

2.7 Range vs Cell
13:11

2.8 Debugging and Debug Windows
11:56
+
3. Useful Procedures / Techniques
12 Lectures 01:16:25
3.1.1 Contiguous Data Range - Part 1
13:11

3.1.2. Contiguous Data Range - Part 2
04:08

3.2 Copy & Paste
11:25

3.3 With Command
08:38

3.4 Formulas
06:28

3.5 Question Box
04:38

3.6.1 Inputbox
04:29

3.6.2 Inputbox Validation
04:57

3.7 Sorting
06:50

3.8.1 Error Handling - Part 1
05:33

3.8.2 Error Handling - Part 2
03:34

3.8.3 Error Handling - Part 3
02:34
+
4. VBA Programming Techniques
21 Lectures 02:08:54
4.1.1 Variables and Datatypes - Part 1
09:54

4.1.2 Variables and Datatypes - Part 2
08:58

4.2 Public, Private & Constant Variables
06:51

4.3.1 If Then Else - Part 1
09:45

4.3.2 If Then Else - Part 2
02:53

4.4 If Then ElseIf
10:43

4.5 Select Case
03:41

4.6.1 For Loop - Part 1
06:36

4.6.2 For Loop - Part 2
01:23

4.7 Do Until Loop
03:12

4.8 Do Loop Until
04:16

4.9 Do While Loop & 4.10 Do Loop While
03:59

4.11 Calling Procedures
10:44

4.12.1 Functions - Part 1
06:01

4.12.2 Functions - Part 2
04:12

4.13.1 Arrays - Static Arrays
11:07

4.13.2 Arrays - Dynamic Arrays
08:19

4.13.3 Arrays - Erase Static Array
02:18

4.13.4 Arrays - Two Dimensional Arrays
05:09

4.13.5 Arrays - Read From and Write To Sheet
05:03

4.13.6 Arrays - Quick Read From and Write To Sheet
03:50
+
5. Interesting Examples
4 Lectures 32:33

5.2 Add Sheet to Workbook
05:11

5.3.1 Duplicate Counter - Part 1
10:14

5.3.2 Duplicate Counter - Part 2
09:52
+
6. Worksheet Events
3 Lectures 20:46
6.1 Activate Sheet Event
04:45

6.2 Deactivate Sheet Event
04:15

6.3 Change Sheet Event
11:46
+
7. Workbook Events
4 Lectures 14:06
7.1 Open Workbook Event
02:26

7.2 New Sheet Event
02:04

7.3 Sheet Deactivate Event
02:51

7.4 Before Save Event
06:45
About the Instructor
Mr Alvin Pillay
4.5 Average rating
179 Reviews
4,262 Students
2 Courses
VBA for MS Excel and MS Access Enthusiast

I am an engineer with over 20 years expierence using Microsoft Office products. I have used MSAcess and MSExcel for various data migration and data analysis projects. More recently I have been doing a lot of work with MSExcel VBA. With the knowledge I have gained, I thought it beneficial that I share this with others that are wanting to get up to speed quickly with MSExcel VBA.