Lunch & Learn: Creating Macros in Excel

Date: 
17 Apr 2019 - 12:00pm
Topic: 
Creating Macros in Excel
PDU Category: 
Technical
Description: 

Macros - small "programs" that can be run with the click of a button or a keyboard shortcut - can be useful for automating repetitive or difficult tasks when working with spreadsheets.

We will take a look at creating macros by recording your actions, at the macros thus created (in the VBA language), some of the idiosyncrasies of working with Excel, and making simple modifications to a macro.

Presentation/Instructions: 20190417_Lunch_&_Learn_Excel_Macros.xlsx
Base File for Exercise: 20190417_Lunch_&_Learn_Base_File.xlsx
Resulting File after formatting: 20190417_Lunch_&_Learn_Formatted_File.xlsx
Separate File in which I stored the macro: 20190417_Lunch_&_Learn_Macro_File.xlsm

Facilitator: 
Rob Candee
Facilitator Bio: 

Rob currently teaches "Computer Concepts and Business Applications" at Manhattanville College as an adjunct professor. On the "business applications" side of this course, he focuses on spreadsheets (Excel in particular, as the school is primarily Microsoft-based).

Rob was formerly the lead Webmaster for the PMIW Chapter, and is now serving as the VP of Communications and Marketing.

Event Location: 

This is a virtual meeting. Click here to pre-register.

Note that in order for us to be able to verify your claim in the case of an audit, your PMI Member ID number is a required field when registering.