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
| Date | Location | Price | Registration |
| November 21, 2024 9:00 AM to 5:00 PM |
Oklahoma City, OK | $425.00 | Class is Full. Waiting List |
| December 12, 2024 9:15 AM to 5:00 PM |
Oklahoma City, OK | $425.00 | Register |
Live Online Classes Schedule
| Date | Location | Price | Registration |
| November 21, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
| December 12, 2024 9:00 AM to 5:00 PM |
Live Online | $425.00 | Register |
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.
Oklahoma City Public Classes
Contact Us
Phone
405-438-6287
Office Address
100 NE 5th Street
Oklahoma City, OK 73104
Mailing Address
PO Box 712
Aledo, TX 76008
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.