Microsoft Excel - VBA

Extend your knowledge of recorded macros using Excel VBA. Learn about Forms, Loops, Defined Functions and Automation
4.1 (79 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.
481 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 55
  • Length 4.5 hours
  • Skill Level Expert 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 9/2013 English

Course Description

The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.

What are the requirements?

  • Advanced knowledge of Excel

What am I going to get from this course?

  • If you are performing repeated actions on workbooks or sheets, it may be possible to automate that work. Importing data, cleaning that data, archiving existing information and similar activities are good candidates for automation in Excel. VBA provides extra options for developers looking to automate Excel.

What is the target audience?

  • Users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed.

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: Introducing VBA
01:19

This section includes the exercise files and sample database for VBA. Please download these before you start the course.

Excel Overview
Preview
01:29
Recording a Macro
Preview
02:39
Reviewing Macro Code
Preview
02:03
Overview Of VBA And Office
Preview
03:18
Objects, Methods And Properties
Preview
11:26
Differences Between Office 2003, 2007, 2010 And 2013
Preview
03:31
Creating A Macro Enabled Workbook
Preview
01:40
Section 2: Macro Recorder Part 1
Introduction
Preview
00:45
Recording A Macro To Format Cells
Preview
09:12
Recording A Macro To Format Cells As Currency
05:11
Recording A Macro To Swap Two Columns
01:14
Recording A Macro Using Relative References Rather Than Absolute
02:30
Recording A Macro To Turn Gridlines On And Off
05:18
Tweaking Macros To Change Their Functionality
05:47
Section 3: Macro Recorder Part 2 - a larger example
Introduction
Preview
01:23
Some Useful Functionality In Excel For Cell Selection
Preview
02:12
Importing A Text File
11:57
Filling Blank Cells With Data
07:19
Adding A Column With The Date
01:58
Creating A Pivot
02:19
Creating A Chart
01:58
Deleting Sheets And Charts
01:57
Putting Them All Together
03:51
Section 4: Forms
Introduction
Preview
01:43
Creating A Simple Switchboard Form To Call Our Previous Macros
Preview
09:10
Adding A Button To The Ribbon To Display The Form
05:16
Using The Auto Open Events To Display The Form
05:08
The Name List Form, Dealing With Events
16:29
Using String Functions To Manipulate Text
07:13
Creating A Form To Interact With Data On A Sheet
05:19
Section 5: Loops
Introduction
Preview
02:53
Looping Through Data In A Column With The For Loop
Preview
09:15
The While Loop
05:09
Using ‘Cells’ To Access A Cell
02:45
Looping Through Variable Length Lists
04:05
Looping Through Data In A Column With Spaces
05:30
Calling Formula To Determine When To Stop A Loop
07:06
Creating Reusable VBA Code
04:34
Finding And Formatting Data Using Loops
10:31
Section 6: User Defined Functions
Introductions
Preview
01:06
Creating A User Defined Function (UDF)
Preview
06:56
Creating A Variable Discount Calculation UDF
09:52
Error Handling In VBA
14:48
Debugging In VBA
06:18
Section 7: Automation
Introduction
Preview
00:33
Automating Word From Excel
Preview
07:52
Automating Powerpoint From Excel
07:07
Automating Outlook From Excel
02:25
Getting Data From Access Into Excel Using VBA
04:09
Section 8: Security
Introduction
Preview
00:31
Personal Macro Workbook
Preview
02:43
Macro Security Levels
02:25
Using A Digital Signature
02:26
Section 9: VBA Language review
VBA Language review
12:18

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

eLearnExcel, Leading provider of Online Excel training

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.

Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.

Ready to start learning?
Take This Course