Mastering MS Excel VBA For Beginners

Learning MS Excel VBA from beginner level to advanced level
4.8 (3 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.
12 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 55
  • Length 6 hours
  • Skill Level Beginner Level
  • 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 10/2016 English

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

What are the 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.)

What am I going to get from this course?

  • 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

What is the target audience?

  • Anyone that uses MS Excel

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: 1. Introduction
Promo Video
Preview
05:00
1.1 Introduction to VBA for MS Excel
03:46
1.2 Download Course Materials
Article
Section 2: 2. Getting Started
2.1 Setting up the Environment
Preview
05:07
2.2 Recording a Macro
Preview
05:42
2.3 Your First VBA Program
Preview
09:13
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
Section 3: 3. Useful Procedures / Techniques
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
Section 4: 4. VBA Programming Techniques
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
Section 5: 5. Interesting Examples
5.1 Make Contents Sheet
Preview
07:16
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
Section 6: 6. Worksheet Events
6.1 Activate Sheet Event
04:45
6.2 Deactivate Sheet Event
04:15
6.3 Change Sheet Event
11:46
Section 7: 7. Workbook Events
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mr Alvin Pillay, 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.

Ready to start learning?
Take This Course