Excel Intermediate Part 3
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
$425 per Student
8 CPE Credits
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.
1 Day
- Understanding Data Validation
- Data Validation Rule Setting
- Data Validation Tool Tips
- Data Validation Custom Error Messages
- 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
- Waterfall Chart
- Histogram Chart
- Pareto Chart
- Treemap Chart
- Geography Filled Maps
- 3D Geography Maps
- Sparkline Cell Chart
- List Box
- Spin Button
- Check Box
- Option Button
- Scroll Bar
- Radio Button
- Solver Overview
- Framing the Problem
- Setting Objective
- Setting Constraints
- Understanding Results
- Goal Seek
- Macros Overview
- Recording a Macro
- Executing a Macro
- Modifying a Macro
- Running Macro from Button
Excel Intermediate Part 3 Schedule
In-Person Classes Schedule
| Date | Location | Price | Registration |
| March 12, 2026 9:15 AM to 5:00 PM |
Hurst, TX | $425.00 | Class is Full. Waiting List |
| April 9, 2026 9:15 AM to 5:00 PM |
Hurst, TX | $425.00 | Class is Full. Waiting List |
| May 14, 2026 9:15 AM to 5:00 PM |
Hurst, TX | $425.00 | Register |
| June 11, 2026 9:15 AM to 5:00 PM |
Hurst, TX | $425.00 | Class is Full. Waiting List |
| August 13, 2026 9:15 AM to 5:00 PM |
Hurst, TX | $425.00 | Class is Full. Waiting List |
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 |
Don't see a Class Date that works for you?
Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.
Classes
Contact Us
Phone
817-841-9560
Office Address
227 NE Loop 820
Suite 161
Hurst, TX 76053
Mailing Address
Aledo, TX 76008
For common questions, the chatbot located in bottom right of screen can answer most common questions about pricing, classes, and many other topics.