Automating Excel: An Introduction to VBA 2018

Topics

• A tour of the VBA Editor
• Jargon-busting: Collections, Objects, Methods and Properties
• Writing your first VBA Procedure
• Adding comments and notes to your code
• Troubleshooting - what to do when it all goes wrong
• Commonly used VBA elements: Variables, Logic and Loops
• Roll your own Excel Function
• The Macro Recorder - when should I use it?

Who should Attend

Any user of Excel for Windows or Excel for Mac.