City of St. Catharines Learning & Development

To take this course participants must have a solid understanding of Excel generally. No specific course(s) are required, but you should be a confident Intermediate + user of Excel.

Ready to save time and cut out repetitive tasks? This course teaches you how to create and tweak macros in Excel—from simple recordings to basic edits and smart ways to run and store them. It’s all about working smarter, not harder.

Recording Macros

• What is a Macro
• Recording Macros
• Running Macros
• Buttons & Illustrations to Run Macros
• Add Macros to Quick Access Toolbar
• Saving and Opening Files with Macros
• Using Relative Referencing
• Workbook vs Personal Workbook Macros

A Quick Look at VBA

• What is Visual Basic
• Working in the VBA Editor
• Basic Editing of Recorded Macros

The next step is Excel Course 7A to more fully understand working in the VBA Editor.