Excel Online Seminar- Mastering the Excel Macro Recorder

Excel macros are a compilation of keystrokes and mouse clicks that are memorized and stored for later use, but you don't have to be a VBA programmer to make use of this outstanding functionality. Simply use the Macro Recorder to create and store macros that will save time and reduce errors in repetitive processes. This session provides the necessary knowledge to use the Macro Recorder effectively. It covers tips on when to use relative references, using the Visual Basic editor to make minor modifications to recorded macros, and saving macros for easy access. Don't miss this opportunity to improve your productivity with Excel macros.

Major Topics

  • Creating your first macro in less than two minutes
  • Recording absolute and relative reference macros
  • Saving macros for future use
  • Modifying macros in the VBA Editor

Learning Objectives Upon completing this course, participants should be able to:

  • Use the Macro Recorder effectively and make minor modifications to recorded macros
  • List the three locations where recorded macros may be stored and the reasons for using each location
  • Differentiate the results when using absolute or relative references when recording macros
  • Describe how to attach macros to buttons on the ribbon or the Quick Access Toolbar

How to Register for this Webinar:

  1. If you do not yet have a CITT account, click here to create an account. If you already have an account, you'll need to be logged in. If you aren't already logged in, please use the "Sign In" fields to the right. If you've forgotten your login information, you can click here to retrieve your username or reset your password here.

  2. Once you're logged in, click on the green Register Myself button

  3. Click the green Proceed to Checkout button

If you need any help registering, please contact Marysa at mmackinnon@citt.ca.

When
2019-04-24 11:30 AM - 1:00 PM
Where
Webinar Online
Online registration not available.