Microsoft Excel - Macros Deep Dive
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 coding for macros. Excel macros allow you to automate repetitive tasks and streamline your work processes.
Description
Attending this course will help you to:
- 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.
Prerequisites for attending:
- basic understanding of Microsoft Excel.
- Stable internet connection.
- No previous understanding of macros is required.
Having a second display is beneficial but not required.
More Info
Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.
Entry Requirements
Anyone who wants to take their Microsoft Excel skills to the next level, automate tasks and streamline their
Prerequisites
- Basic understanding of Microsoft Excel.
- Stable internet connection.
- No previous understanding of macros is required.