Macros Deep Dive

In this ‘Deep Dive’ we will devote the full day to exploring Macros and how they are used in Excel. We recommend that you have a basic to intermediate understanding of Excel already.

This seminar is also available on demand by virtual classroom. 

What you will learn:

• Introduction to Macros
• How to use the macro recorder
• Save your file support with macros
• Using absolute versus relative cell referencing when recording
• Run a macro from a button you create
• Use keyboard shortcuts to navigate during recording to get the correct result
• Apply macros to different sized data sets
• Add macro to Excel menu tabs
• Introduction to VBA Editior
• Add IF condition to macro VBA code
• Add Loop to macto VBA code
• Introduction to debugging VBA code
• Copy macros between workbooks