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
Group bookings are available and can be tailored to your needs. Courses may be delivered onsite, virtually, in person, or on campus. To arrange a private course, you can register your interest Register interest in a private course
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.
More Info
Note: Our advanced Excel courses are regularly updated to include the latest AI releases and best practice.
Entry Requirements
None
Prerequisites
- Basic understanding of Microsoft Excel.
- Stable internet connection.
- No previous understanding of macros is required.