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

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.

• 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