Microsoft Excel - VBA
4.3 (91 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.
529 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - VBA to your Wishlist.

Add to Wishlist

Microsoft Excel - VBA

Extend your knowledge of recorded macros using Excel VBA. Learn about Forms, Loops, Defined Functions and Automation
4.3 (91 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.
529 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
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 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 55 Lectures Collapse 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
+
VBA Language review
1 Lecture 12:18
VBA Language review
12:18
About the Instructor
eLearnExcel
4.4 Average rating
151 Reviews
1,769 Students
6 Courses
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.