Event Calendar

Wednesday, December 18, 2019

Annual Membership Meeting

Date(s): December 18, 2019

Time: 10:00 AM  CST - 2:00 PM  CST

Featured Guest:

Brian Helm - MCAA President
President, Mechanical, Inc.

10:00 a.m.        Associate Member Expo
11:00 a.m.        Luncheon, State of the Industry, and Featured Guest

Questions: Contact Cathy Paulson at 913-948-9200

Excel Advanced - 12/18/19

Date(s): December 18, 2019

Time: 8:00 AM  CST - 4:00 PM  CST

This session takes place at JCCC. To register, contact Jacki Conn.
If you've already registered, click "Add to my Calendar" above to add this session to your calendar.

Excel Advanced
This course is designed for students looking for discussion on tables, pivot tables, pivot charts, financial functions, structured references, goal seek, and workbook protection.

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. 

Cost: FREE to employees of Signatory Members, Associate Members, and Signatory Non-Members.

All Microsoft Office instructor led courses are version 2016 unless otherwise noted. We offer other versions through customized training.

CEU: 0.7

Cancelation and Transfer Policy:
Cancellations for all MCAKC events must be received at least 2 Business Days prior to the event by email to jconn@mcakc.org or by phone at 913-948-9200. Cancellations received after this time will be assessed a $100 cancellation fee.

No Shows” will be assessed a fee (see below) and invoiced accordingly.

$50 Event Duration: Up to 4 Hours
$100 Event Duration: Over 4 Hours (Should the event cover more than one day, this fee will apply for each day of event) 

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 received less than two (2) days prior to the start date of the course. 

Change Category: