Microsoft Excel - VBA
3.4 (165 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.
701 students enrolled

Microsoft Excel - VBA

Extend your knowledge of recorded macros using Excel VBA. Learn about Forms, Loops, Defined Functions and Automation
3.4 (165 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.
701 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • 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
  • 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.
Requirements
  • Advanced knowledge of Excel
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.

Who this course is for:
  • 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.
Course content
Expand all 55 lectures 04:35:51
+ Macro Recorder Part 1
7 lectures 29:57
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
+ Macro Recorder Part 2 - a larger example
9 lectures 34:54
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
+ Forms
7 lectures 50:18
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
+ Loops
9 lectures 51:48
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
+ User Defined Functions
5 lectures 39:00
Creating A Variable Discount Calculation UDF
09:52
Error Handling In VBA
14:48
Debugging In VBA
06:18
+ Automation
5 lectures 22:06
Automating Powerpoint From Excel
07:07
Automating Outlook From Excel
02:25
Getting Data From Access Into Excel Using VBA
04:09
+ Security
4 lectures 08:05
Macro Security Levels
02:25
Using A Digital Signature
02:26