Event Calendar

Wednesday, March 24, 2021

Excel - Formulas, Formatting and Functions - Virtual Course: Mar. 22 & 24, 2021

Start Date: 3/22/2021 8:00 AM CDT
End Date: 3/24/2021 4:30 PM CDT

Venue Name: Live Online Instructor Led Course

Location:
Zoom
KS  United States 

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

Organization Name: MCAKC

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

This seminar takes place online and is offered by JCCC.
Signatory & Associate Members: Contact Jacki Conn to register for FREE.
All others may register by visiting JCCC.

Excel - Formulas, Formatting and Functions

Live Instructor-Led Online Course

March 22 & 24, 2021 
8:00 am - 4:30 pm


Get ready for interactive learning.  Focus on complex examples from the textbook to reinforce your skills. We'll also utilize the eLab system for instant feedback on a few practice problems. Expand your Excel knowledge with an in-depth look at conditional formatting, analysis functions, vlookup, outlines, and subtotals. Your eLab access is available for 24 months. This is a component of the Microsoft Office Essentials Certificate and the Excel Specialist Certificate.

This section is facilitated by an instructor online. Within 2 business days of the class start date, you will receive instructions about how to access the class online.

Prerequisite:  Excel Fundamentals/Foundations

Topics Covered 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
Cost: FREE to employees of Signatory Contractors and Associate Members.

CEU: 1.5
 
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.