Past Event

Microsoft Office - Excel 2016 The Fundamentals of Macros

April 11, 2019
1:30 PM - 4:30 PM
Event time is displayed in your time zone.
Studebaker Building, 622 W. 132 St., New York, NY 10027 - Conference Room 160

Course description: Learn advanced formulas and work with various tools to analyze data in spreadsheets specifically using Macros.  

Category: Productivity & Software

Price: $130.00

Target audience: All Faculty, Managers and Staff who are interested in learning skills to create and modify Excel workbooks.  

By the end of the workshop participants will: 

Working with Macros 

  • The Record Macro Window 
  • Rules for Macro Names 
  • Recording a Macro 
  • Saving a Macro-Enabled Workbook 
  • Executing a Macro 
  • Creating a Macro Button
  • Working with Macro Buttons  

Configuring Excel for Macros 

  • The Developer Tab 
  • Macro Security 
  • Trust Center 
  • Saving Files 

Running Macros 

  • Running a Macro from the Developer Tab 
  • Running a Macro Using a Shortcut Key 
  • Running a Macro from a Button 

Creating Dynamic Macros 

  • Absolute versus Relative References

Contact Information