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.
Dates
There are no dates currently scheduled for this course.
Interested in this course?
Suggest a date/location
Description
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.
Prerequisites
None
Content
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.
Certification
College certificate of attendance