Skip to content Skip to site navigation Skip to service navigation

Introduction to Excel Macros

New session times will be displayed below upon confirmation.

Effective immediately in response to COVID-19, all Technology Training classes will be delivered online until further notice.


In advance of each session, Tech Training will provide you with a Zoom link to your class, 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


 

University IT Technology Training classes are only available to Stanford University staff, faculty, students and Stanford Hospitals & Clinics employees. A valid SUNet ID is needed in order to enroll in a class.

Igor Ovchinnikov

Igor Ovchinnikov has been teaching software productivity classes for over 20 years. Stanford staff have enjoyed his training since around 2007. His training philosophy stems from a strong belief that learning is a perpetual cycle of new discoveries and improvement.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training


University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.