Skip to main contentSkip to main navigationSkip to footer content

Excel Level 3 (Clinton)

Date: December 4, 2026
Time: 9:00 a.m. – 4:00 p.m.
Duration: 7 Clock Hours (One 7-Hour Session)
Location: State Fair Community College | Clinton Campus | in-person
Instructor: Sherry Coker
Registration Deadline: November 20, 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.

Company Address: Please enter the address of the company location where the trainees are employed and will be attending the training from.
Company Address: Please enter the address of the company location where the trainees are employed and will be attending the training from.
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.

List of Trainees (include yourself if applicable)
*****CLICK HERE TO ADD ADDITIONAL TRAINEE*****
Payment Method
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