Loading Events

« All STS Events

  • This event has passed.

STS: Excel 3: Macros and VBA

Friday, March 26 @ 6:00 pm - 8:00 pm

Register

Attending STS Sessions Online

All Software Training for Students workshops sessions are currently being delivered remotely via Zoom. Our room can be accessed from the following link:

https://go.wisc.edu/stszoom

To attend the workshops, we recommend the following:

  1. Enroll in the STS Canvas Course (if you are not already enrolled)
  2. After enrolling, click the following link to join our Zoom room
  3. Recommended: Download the Class Files before attending your scheduled workshop.

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


Audience:

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


Prerequisites:

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.

Details

Date:
Friday, March 26
Time:
6:00 pm - 8:00 pm
Cost:
Free
Event Category:
Event Tags:
, , , ,

Venue

online

Other

Audience
Students
Primary Trainer
Vinayak Malik
Tickets are not available as this event has passed.