When

Monday, April 12 from 9 AM - 12:30 PM

and

Tuesday, April 13 from 9 AM - 12:30 PM

Add to Calendar  

Where

This is an online event. 
 

 
 

Contact

Carly Carmosino 
Mechanical Contractors Association of Eastern Missouri 
314-571-6600 
carly@mca-emo.com 
 

Microsoft Excel 2016 for Business: Advanced

This course is offered jointly by the MCA and SMACNA and is available to members of these associations at no cost. 


This is a 2-part course on April 12 & 13 from 9 AM - 12:30 PM. 

Course Description:

Continue to expand your Excel expertise as you manage multiple workbooks and worksheets, and build three-dimensional calculations and file linking. Explore the power of the all-important lookup functions and related concepts. Become adept at using formula auditing tools, data validation, and sharing and protecting workbooks. Also, explore the use of major data analysis tools, such as Scenario and Data tables. Create and edit macros to save time and create consistency across workbooks.  

Prerequisite: Microsoft Excel 2016 for Business: Intermediate or equivalent experience. 

*Class materials will be provided to participants ahead of the start date. 

*Registration closes at 15 people to provide a better learning experience.

Instructor: Cris Heffernan, St. Louis Community College - Corporate College