Excel Macros Essentials: Automate Tasks with Macros for Efficiency and Accuracy

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.
 

By the end of this session, you will have had the opportunity to learn how to record, edit and implement macros within Microsoft Excel and have explored the best practices on how to automate files and tasks with macros. 

By recording a macro, you can save your steps and replay them with a single click of a button or keyboard shortcut. We will debug macros by stepping into the code, learning how to assign keyboard shortcuts and custom buttons to macros, and learning how to access the code directly for minor edits. Understand the purpose and use of the "Personal Macro Workbook" and how to share these macros with your colleagues.

Topics covered:

• Recording Macros
• The Developer toolbar
• Relative vs. Absolute Macros
• Where to save Macros
• Creating Custom Buttons
• How to Edit a Macro
• The Visual Basic Editor
• Sharing Macros
• Security and Macros