This great 1 day class is all you need to know about macros!
Do you tend to repeat tasks multiple times? Do you have to do the same thing day in and day out?
Why not make your process in 1 click? In this class you will see the beauty of recording macros and how to edit them without ever writing one line of code. ( This course is for Excel users who want to explore a broader scope of Excel without resorting to using VBA.)
What We Will Cover:
What is a macro?
The absolute macro
- The concept
- How to record
- The 1-2-3 Macro!
The relative macro
- The concept
- Why do a relative macro?
- The active cell
- How to record
- The template macro!
The mixed macro
- The concept
- Why do a mixed macro
- How to record
- The database macro
Viewing macros
- Why view
- How to read
- Absolute code
- Relative code
- Mixed code
Merging macros
- How to merge macros
- Copy/paste code efficiently
- Macro efficiency
Editing macros
- Make a broken macro
- Fixing it with another recording
- Looking at code and creating the missing part