Skip to content Skip to site navigation Skip to service navigation

Introduction to Excel Macros (Lecture)

Class Sessions

Date Location Cost
  • Mon Jun 22, 9:00 am to 12:00 pm
Polya Hall 111 (Turing Auditorium) $175
  • Mon Jul 20, 1:00 pm to 4:00 pm
Polya Hall 111 (Turing Auditorium) $175
  • Wed Aug 12, 9:00 am to 12:00 pm
Polya Hall 111 (Turing Auditorium) $175

Class Code

ITS-1175

Class Description

Note: This is a lecture. Laptops are recommended, but not required. 

Macros in Excel can eliminate repetitive tasks, reduce errors and save time, among other things. In this lecture we will demonstrate the recording and playing back of macros, and some basic editing. By the end of the lecture, you will know 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.

You will learn the different ways in which you can record macros. By recording a macro, you can save your steps and replay them with the 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, or students. A valid SUNet ID is needed in order to enroll in a class.