Event Calendar

Start Date: 12/2/2022 8:00 AM CST
End Date: 12/2/2022 4:00 PM CST

Venue Name: JCCC Main Campus, Regnier Center, 253

Location:

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

Organization Name: MCAKC

Contact:

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

Excel Fundamentals

December 2, 2022
8:00 am - 4:00 pm

Start your adventure with tools and features of Microsoft Excel. Upon completion you can enter, edit and format data. Manage workbooks, link worksheets and create basic functions to calculate data. Design and edit charts. Organize large amounts of data with freeze panes, sorting and data filtering tools.

Course Outline

1. Introduction to Microsoft Office - Common features in Microsoft Office Apps
2. Introduction to Excel Worksheets - Entering and Editing Data, Formatting Cells, Numbers and Dates, Autofill, Navigation Methods
3. Rearranging Data - Working with Rows, Cells and Columns
4. Managing Multiple Worksheets - Insert and Delete, Cell Reference, Edit Multiple Sheets and One Time
5. Functions in Formulas - AutoSum, SUM, AVERAGE, COUNT, MAX and MIN
6. Data Visualization and Images - Create, Edit using Chart Tools, Add Images
7. Organizing Large Amounts of Data - Sorting, Filters, Freeze Panes

Instructor: Phyllis Mohr has been teaching 9+ years. She teaches introductory computing courses using the Microsoft Office suite. She has experience guiding new users through unfamiliar applications and programs.
Phyllis is also an excellent tutor and offers 1:1 opportunities to expand your knowledge of your computer or the Microsoft application or the iPad.

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

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)  Students who "No Show" for JCCC seminars will be invoiced the registration costs for the seminar. 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.