Lesson 1Plan your macro before the recording process, and understand the principles of recording.Lesson 2Recognise the versatility of a Relative Referenced macro.Lesson 3Name a macro, record and run macros in an Excel file.Lesson 4Run macros with keyboard shortcuts, Quick Access toolbar and Ribbon buttons.Lesson 5Save files containing macros as Excel Macro-Enabled Workbook file type.Lesson 6Produce macros that run across all your Excel files by saving to the Personal file.Lesson 7Unhide, hide and manage the Personal file.Lesson 8What is VBA? Coding without programming.