The LearningForce

Excel Level 3 (Sedalia)

Date: November 5, 2026
Time: 8:30 a.m. – 3:30 p.m.
Duration: 7 Clock Hours (One 7-Hour Session)
Location: State Fair Community College | Sedalia Campus | in-person
Instructor: Sherry Coker
Registration Deadline: October 23, 2026
Cost: $499 per participant
Category: Business and Operations
Prerequisites: Completion of Microsoft Excel Level 2 or equivalent experience using formulas, PivotTables, lookup functions, and data analysis tools.

Training Description

Microsoft Excel Level 3 is an advanced, hands-on course designed for professionals who work extensively with data and are ready to maximize Excel's analytical and automation capabilities. Participants will build upon foundational and intermediate Excel skills to create dynamic reports, automate repetitive tasks, and manage complex datasets efficiently.

Through practical exercises and real-world business scenarios, participants will learn to use advanced tools such as structured references, PivotTables, PivotCharts, macros, data consolidation, and advanced functions. The course also explores data import techniques, workbook protection, accessibility features, and best practices for maintaining accurate and secure workbooks.

By the end of the course, participants will be able to leverage Excel's advanced features to improve productivity, streamline reporting processes, and support data-driven decision-making.

Learning Objectives

Upon completion of this training, participants will be able to:

Organize and manage data using Excel tables and structured references.
Create and apply advanced filters to analyze data effectively.
Build, customize, and analyze PivotTables and PivotCharts.
Create calculated fields and interactive dashboards using slicers.
Record, run, and manage macros to automate repetitive tasks.
Import and consolidate data from multiple sources.
Apply advanced formulas and functions for data analysis and decision-making.
Create reusable chart templates and visualize trends effectively.
Improve workbook accessibility, navigation, and usability.
Protect workbooks and inspect files for security and compliance issues.

Course Outline

Data Management and Analysis

Managing data using tables
Creating custom filters
Naming tables
Using structured references in formulas
Creating sparklines to visualize trends
Creating data series using multiple methods

PivotTables and PivotCharts

Creating PivotTables
Modifying and formatting PivotTables
Applying filters to PivotTables
Using slicers for interactive analysis
Creating calculated fields
Building and customizing PivotCharts

Automation and Productivity Tools

Understanding macro security settings
Recording and running macros
Creating macro buttons for quick access
Automating repetitive tasks

Advanced Data Integration

Importing data from multiple sources
Consolidating data from multiple worksheets
Managing linked data and workbook connections

Advanced Functions and Visualization

Applying advanced lookup and logical functions
Charting trends and creating chart templates
Creating hyperlinks for workbook navigation

Workbook Management and Protection

Inserting comments and notes
Adding alternative text to objects
Inspecting workbooks for hidden information and accessibility issues
Creating forms for data collection
Protecting worksheets and workbooks

Instructional Methods

Instructor-led demonstrations
Guided hands-on exercises
Individual practice activities
Real-world business scenarios
Interactive problem-solving exercises

Materials Provided

Participant workbook
Practice files and exercises
Quick reference guide
Digital resources
Certificate of completion

Who Should Attend

This training is designed for professionals who regularly work with large datasets, create reports or dashboards, manage business information, or want to automate routine tasks using advanced Excel features. It is ideal for analysts, administrative professionals, project managers, accountants, supervisors, and operations personnel.

If a company representative is registering one or more employees for an open enrollment training, all training communications will be sent to the company representative unless the employee's email address is provided.

Name of Company

Company Representative - First and Last Name

Company Representative - Phone Number

Company Representative - Email Address

Company Address: Please enter the address of the company location where the trainees are employed and will be attending the training from.

Country

Street

City

Region

Postal Code

Open Enrollment Registration

As part of the registration process, you may be asked to provide optional information, including your email address and date of birth. This information helps SFCC maintain accurate student records, document completed training, and identify potential opportunities for credit for prior learning. All information is securely maintained in accordance with college privacy policies.

DeleteTrainee _ID_
List of Trainees (include yourself if applicable)
First Name* Last Name* Email Address* Date of Birth Date of Birth Cost (internal)

***CLICK HERE TO ADD ADDITIONAL TRAINEE***

Payment Total

Payment Method

Select this option if utilizing MISSOURI ONE START grant funds

Invoice/Check - Payable to: State Fair Community College

Credit/Debit Card - Once your registration is processed, a payment link will appear on the confirmation page and in your confirmation email.

Refund Policy:

The college reserves the right to cancel if sufficient registration is not achieved. Every effort will be made to notify registrants by phone or email if an event is cancelled. Full refunds will be issued for events cancelled by the college.

If you need to cancel your registration, please contact our office seven (7) days before the start date to receive a full refund, less 10% service charge if payment was made by credit or debit card. Expenses such as supply fees, food costs, tour fees or other costs associated with the event besides the event fee will be refunded only if The LearningForce has not incurred those costs. If an event has a deadline, that date is also considered the cancellation deadline.

If you have a situation that warrants an override of the above policy, an explanation of the circumstances should be made in writing to The LearningForce office. The request will be reviewed to determine if a refund can be granted, and you will be notified accordingly. Refunds should be received within 30 days.

Contact Information:

Phone: (660) 530-5822
Email: thelearningforce@sfccmo.edu

The LearningForce

Excel Level 3 (Sedalia)

Toll Free (877) 311-7322

Leave Ready!