Macros Deep Dive Workshop

Using Excel Macros can speed up work and save you a lot of time, increasing productivity!
In this ‘Deep Dive’ into the topic, 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 Microsoft Excel.
In this course, participants will be introduced to Excel macros and then develop a deeper understanding of advanced and custom macros including an introduction to VB (Visual Basic) coding for macros

What you will learn:

• Introduction to macros
• How to use the macro recorder
• Save your file with support for macros
• Using absolute versus relative cell referencing when recording
• Using absolute AND 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 the VBA Editor
• Add IF condition to macro VBA code
• Add Loop to macro VBA code
• Introduction to debugging VBA code
• Copy macros between workbooks

  Duration: 1 Day

  This course is delivered on our open schedules in Edinburgh and Glasgow We can also deliver this workshop via a virtual classroom over two half sessions, using Zoom or Teams.