Start Date: 2/20/2026 8:00 AM CST
End Date: 2/20/2026 5:00 PM CST
Venue Name: RC, Regnier Center, 253
Location:
12345 College Blvd.
Overland Park, KS United States 66210
Event Website: https://ce.jccc.edu/courseDisplay.cfm?schID=48359
Organization Name:
MCA of Kansas City
Contact:
| This seminar is offered by JCCC and is offered at JCCC. Signatory Contractors and Associate Members: Contact Jacki Conn to register. All others may register by contacting JCCC. |
Excel Intermediate
Date: Friday 2/20/2026
Time: 8:00 AM
Get ready for interactive learning. Focus on complex examples from the textbook to reinforce your skills. You'll have access to additional exercises to use on your own for practice or certification prep. Expand your Excel knowledge with an in-depth look at conditional formatting, analysis functions, vlookup, outlines, and subtotals.
Topics Include:
- Advanced Formatting - Themes, Cell Styles, Customizing Page Setup
- Date and Time Functions, Conditional Formatting
- Advanced Functions for Analysis - Financial Functions, What-If Analysis Tools
- Text Functions, Conditional Functions, and Formula Auditing - 3-D Cell References, Troubleshooting Formulas
- Lookup Function and Outlines - vlookup and hlookup functions
Prerequisite: Excel Fundamentals or the ability to create a basic formula on your own
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 for employees of MCAKC Member Contractors Signatory to Locals 8 & 533.
$125 for Non-Members Signatory to Locals 8 & 533.
$150 for 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.
|
