Event Calendar

Start Date: 7/25/2025 8:00 AM CDT
End Date: 7/25/2025 5:00 PM CDT

Venue Name: JCCC: Main Campus, Regnier Center, 254

Location:

Event Website: https://ce.jccc.edu/courseDisplay.cfm?schID=46272

Organization Name: MCA of Kansas City

Contact:

 

This seminar is offered by JCCC. Signatory Contractors & Associate Members: Contact Jacki Conn to register for FREE. All others may register by contacting JCCC.

Excel Advanced

Date: Friday, 7/25/2025  
Time: 8:00 AM - 5:00 PM  

Not your typical course! Focus on complex examples from your textbook to reinforce your skills. You'll have access to additional exercises to use on your own for practice or certification prep. Dive into tables, pivot tables, pivot charts, macros, and data management.

Topics Covered Include:

• Working with Tables - Calculated Columns, Structured References, Table Features
• Financial Functions and What-If Analysis - PMT, PV and NPER Functions
• PivotTables and PivotCharts
• Macros, Workbook Protection and Inspecting Workbooks for Compatibility

Prerequisite: Excel Intermediate or equivalent experience. 

Instructor
Cary Short is an information system pro! Cary feels a sense of satisfaction sharing knowledge. He currently teaches advanced Microsoft Office courses. He received a Bachelor's Degree in business administration and a Master's Degree in Information Systems. He hopes he inspires people to improve technical skills for success professionally.

Cost: FREE to employees of Signatory Contractors and Associate Members.

CEU: 0.7

Complete all three Excel courses to earn your Excel Specialist Certificate from JCCC. LEARN HOW!
 

Registration and Attendance Policy: MCAKC offers several fee or no fee networking and educational opportunities to employees of Signatory Members, Associate Members, and Partner Trade Organizations. Registrants of MCAKC sponsored events, who wish to cancel their registration, must do so at least 2 Business Days prior to the event by either email (learn@mcakc.org) or phone (913-948-9200). “No Shows” will be assessed a fee based on the registration fees for the course. Tax Classes: $25 Excel Classes: $200 to $400 Leadership Classes: $200 to $400 Bluebeam Classes: $400 Transfer Policy Registrants in JCCC continuing education courses may transfer their registration to another course. The transfer request must be received in writing two (2) business days prior to the first day of the course for which you were originally scheduled. A $50 transfer charge will be applied to all transfers.