Excel Yourself/Macros 1 - Recording tips,tricks and traps

Macros 1 Recording Tips, Tricks and Traps

It is easy to create a recorded macro. It is not so easy to create a flexible and re-usable recorded macro. Learn the techniques that can allow you to record effective macros that can handle different ranges and changes to sheet names.

Macros can speed up your work and reduce the time taken for tedious tasks, as well as adding functionality to Excel.

This is the first in a series of webinars dedicated to macros. Future sessions will expand on the techniques taught in this session.

Session includes bonus macros that you can use straight away to save time and effort.

  • Free

Macros 1 - Recording tips,tricks and traps

  • Closed

Learn how to reduce keystrokes, automate tasks and speed up your work.

Contents

Course materials

The pdf manual plus the Excel file to work through during the session and the completed file.
Recorded Macros tips and tricks 2020.pdf
Recorded Macros 2020.xlsm
Recorded Macros 2020 crashed completed.xlsm

Course Video recording

Macros1 Recording tips.mp4

Course Quiz

Macros 1 Quiz