2026 Training & Development Catalog

Schedule by Category continued

Leadership & Skill Building

LEARNIT: Excel Intermediate: Data Management & Analysis Tools Workshop

Date: Time:

November 18, 2026 10:00am - 12:00pm

Platform/Location:

Virtual/TBD

Mandatory: Registration:

No

Required. Limited to 20 participants.

Description: Mastery of Excel is developed in stages: first you learn basic formatting, functions and formulas, and build a few spreadsheets yourself. Easy enough. But moving to the next level of proficiency is hard! To create truly professional-looking spreadsheets, you’ll need to know how to organize data into elegant, interactive tables that dynamically generate colorful charts and graphs.

What We’ll Explore: Advanced tables, charts, pivot tables, conditional formatting, and data validation.

Course Outline: Module 1 Working with Lists, Tables & Charts What is a well-defined list? Inserting Tables Flash Fill Multi-Level Sorting Removing Duplicates Filtering Records Using Slicers to filter The Quick Analysis Tools Inserting Data Charts Recommended Charts Editing Chart Elements Adding/Removing Data From A Chart Creating Custom Chart Templates Printing Charts Inserting Sparklines

Module 2: PivotTables, Data Validation & Protection Creating PivotTables from Lists or Tables

Filtering PivotTables Multi-Select Slicers Working with Pivot Charts Data Validation Rules

Applying Built-in Conditional Formatting Creating Custom Conditional Formats Comments Linking Data

Who Should Attend: This class is for those who already use functions, formulas and cell references — but want to en hance their spreadsheets with responsive tables, advanced charts and pivot tables.

Return to Table of Contents | Return to Schedule at a Glance | Return to Catalog Overview

17