Excel VBA Course

Introduction – Excel Overview – Recording A Macro – Reviewing Macro Code – Introduction to Excel – Objects, Methods And Properties – Differences Between Office 2003, 2007, 2010 And 2013 – Creating A Macro Enabled Workbook

Introduction – Recording A Macro To Format Cells – 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

Introduction – Some Useful Functionality In Excel For Cell Selection – 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

Introduction – Creating A Simple Switchboard Form To Call Our Previous Macros – 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

Introduction – Looping Through Data In A Column With The For Loop – 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

Introduction – Creating A User Defined Function (UDF) – Creating A Variable Discount Calculation UDF – Error Handling In VBA – Debugging In VBA

Introduction – Automating Word From Excel – Automating Powerpoint From Excel – Automating Outlook From Excel – Getting Data From Access Into Excel Using VBA

Introduction – Personal Macro Workbook – Macro Security Levels – Using A Digital Signature