DoIT Academic Technology provides countless opportunities to gather on campus to learn and discuss a variety of topics. This includes pedagogical discussions and technology demonstrations through Faculty Engagement programs, learning technology trainings from Learn@UW, on-campus sessions for Information Technology Academy scholars, technology workshops from Software Training for Students and special campus events we host or co-host. See the below calendar for upcoming events.

You can filter the calendar using Audience or Categories, which are the names of the DoIT AT service hosting the event. For Software Training for Students, you may use Tags to narrow it down to specific software workshops.
Loading Events

« All Events

STS: Excel 3: Macros and VBA

April 1 @ 6:00 pm - 8:00 pm

NOTE! This class is taught using Excel for Windows. The Excel features used in this course are not available in the Mac version of Excel.

This workshop covers the basics of automating excel with macros using Visual Basic for Applications (VBA). This course will utilize Excel but the knowledge can easily transfer to other programs that have VBA capabilities. This course will focus on the thought process behind creating macros more than the syntax of the programming language.

Topics include:

  • What macros are
  • VBA and the Visual Basic Editor
  • Recording macros
  • Programming basics
  • Saving macros and add-ins

Workshop Manual and Class Files:

Training Manual

Class Files

Note: these files are available through the STS Canvas course. If you are not enrolled, click here to enroll


Anyone looking to automate Excel and learn some basic programming concepts in the context of Excel


Previous experience with Excel is essential, and some previous programming experience will help with understanding programming concepts.

Note: Software Training for Students services are only available to currently registered undergraduate or graduate students of UW-Madison. Faculty, staff and former students are not eligible to attend our training workshops or consultations.


April 1
6:00 pm - 8:00 pm
Event Category:
Event Tags:
, , , ,


Room B1144A, DeLuca Biochemistry Building
420 Henry Mall
Madison, WI United States


Primary Trainer
Aarish Mirza


2 out of 30 available STS: Excel 3: Macros and VBA

Please fill in all required fields