Link: UCOP's e-newsletter

Stay Informed. Stay Connected.

Loading Events

« All Events

  • This event has passed.

Excel Macro and VBA

Wednesday, August 2, 2023, 9:00 am12:00 pm

|Recurring Event (See all)

One event on Wednesday, August 2, 2023 at 9:00am

In this two-part series, the learner will understand how Macros and VBA (Visual Basic for Applications) help users customize and automate repetitive tasks in Excel. Macros can automate those tasks to be repeated when needed. Where macros are limited, VBA coding can expand a user’s ability to perform those necessary tasks.

We strongly recommend that the learner has successfully completed MS Excel Intermediate or have the requisite skills taught in this class before enrolling.

Key concepts for parts one and two includes:

  • Recording and Executing Macros
  • Editing Macros
  • Adding Visual Basic to Enhance Macros
  • Creating Interactive VBA Procedures
  • Design Decision-Making VBA
  • Looping VBA Procedures
  • Debugging and Error Handling VBA Techniques

Participants must attend both sessions:

  • Wednesday, July 26 (9am-12pm)
  • Wednesday, August 2 (9am-12pm)