Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introducing VBA|
This section includes the exercise files and sample database for VBA. Please download these before you start the course.
Recording a MacroPreview
Reviewing Macro CodePreview
Overview Of VBA And OfficePreview
Objects, Methods And PropertiesPreview
Differences Between Office 2003, 2007, 2010 And 2013Preview
Creating A Macro Enabled WorkbookPreview
|Section 2: Macro Recorder Part 1|
Recording A Macro To Format CellsPreview
Recording A Macro To Format Cells As Currency
Recording A Macro To Swap Two Columns
Recording A Macro Using Relative References Rather Than Absolute
Recording A Macro To Turn Gridlines On And Off
Tweaking Macros To Change Their Functionality
|Section 3: Macro Recorder Part 2 - a larger example|
Some Useful Functionality In Excel For Cell SelectionPreview
Importing A Text File
Filling Blank Cells With Data
Adding A Column With The Date
Creating A Pivot
Creating A Chart
Deleting Sheets And Charts
Putting Them All Together
|Section 4: Forms|
Creating A Simple Switchboard Form To Call Our Previous MacrosPreview
Adding A Button To The Ribbon To Display The Form
Using The Auto Open Events To Display The Form
The Name List Form, Dealing With Events
Using String Functions To Manipulate Text
Creating A Form To Interact With Data On A Sheet
|Section 5: Loops|
Looping Through Data In A Column With The For LoopPreview
The While Loop
Using ‘Cells’ To Access A Cell
Looping Through Variable Length Lists
Looping Through Data In A Column With Spaces
Calling Formula To Determine When To Stop A Loop
Creating Reusable VBA Code
Finding And Formatting Data Using Loops
|Section 6: User Defined Functions|
Creating A User Defined Function (UDF)Preview
Creating A Variable Discount Calculation UDF
Error Handling In VBA
Debugging In VBA
|Section 7: Automation|
Automating Word From ExcelPreview
Automating Powerpoint From Excel
Automating Outlook From Excel
Getting Data From Access Into Excel Using VBA
|Section 8: Security|
Personal Macro WorkbookPreview
Macro Security Levels
Using A Digital Signature
|Section 9: VBA Language review|
VBA Language review
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.