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.
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
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.
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.