Excel Intermediate Part 3

Overview

This is the third part of our three Excel Intermediate classes, and it is focused on data validation, conditional formatting, advanced charts, form controls, optimization with Solver and Goal Seek, and recorded Macros. You will learn the following:

How to control what users enter with Data Validation
How to dynamically change formatting based on the values of the data using Conditional Formatting
How to enrich the user experience by putting website like controls like scroll bars using Form Controls
How to optimize problems using Solver and Goal Seek
How to record Macros and execute recorded Macros

Price

$425 per Student

CPE Credits

8 CPE Credits

Prerequisites

For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, and Excel Intermediate Part 2 classes.

Duration

1 Day

Class Outline

Data Validation

Understanding Data Validation
Data Validation Rule Setting
Data Validation Tool Tips
Data Validation Custom Error Messages

Conditional Formatting

Understanding Conditional Formatting
Highlight Cell Rules
Top/Bottom Rules
Data Bars
Color Scales
Icon Sets
Custom Rules
Advanced Rules based on Formulas
Creating a Schedule (Gantt Chart) using Conditional Formatting

Advanced Charts

Waterfall Chart
Histogram Chart
Pareto Chart
Treemap Chart
Geography Filled Maps
3D Geography Maps
Sparkline Cell Chart

Form Controls

List Box
Spin Button
Check Box
Option Button
Scroll Bar
Radio Button

Optimization & What If Analysis

Solver Overview
Framing the Problem
Setting Objective
Setting Constraints
Understanding Results
Goal Seek

Recorded Macros

Macros Overview
Recording a Macro
Executing a Macro
Modifying a Macro
Running Macro from Button

Excel Intermediate Part 3 Schedule

In-Person Classes Schedule

This class currently has no scheduled public sessions. Since there are no public dates available, you can choose to schedule a private one-on-one class or arrange a private group class. For more information on these options, on the top menu bar click on Private Classes or 1 on 1 Classes.

Date

Location

Price

Registration

Live Online Classes Schedule

Date	Location	Price	Registration
March 19, 2026 9:15 AM to 5:00 PM	Live Online	$425.00	Class is Full. Waiting List
April 16, 2026 9:15 AM to 5:00 PM	Live Online	$425.00	Class is Full. Waiting List
May 21, 2026 9:15 AM to 5:00 PM	Live Online	$425.00	Class is Full. Waiting List