Event Calendar

Tuesday, February 5, 2019

Excel Intermediate - 2/05/19

Start Date: 2/5/2019 8:00 AM CST
End Date: 2/5/2019 4:00 PM CST

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

Location:
12345 College Blvd.
Overland Park, KS  United States  66210

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

Organization Name: MCAKC

Contact:
Jacki Conn
Email: jconn@mcakc.org
Phone: 913-948-9200

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 Intermediate
Expand Excel knowledge with an in-depth look at conditional formatting, advanced text and analysis functions, vlookup, outlines and subtotals. This course is a component of the Excel Specialist Certificate.Textbook included in course fee. Textbooks distributed in first course meeting.

Topics Covered Include:
  • Advanced Formatting - Themes, Cell Styles, Customizing Page Setup
  • Date and Time Functions, Conditional Formatting
  • Advanced Functions for Text and Analysis - IF Criteria, Troubleshooting Formulas
  • Lookup Function and the Outline Features
Prerequisite: Excel Fundamentals or equivalent experience. 

Cost: FREE to employees of Signatory Members, Associate Members, and Partner Trade Organizations.

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

CEU: 0.7

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 (jconn@mcakc.org) or phone (913-948-9200).

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. 

Partner Trade Associations include organizations such as SMACNA-KC, NECA-KC, or other Affiliate Organizations.