Classroom Instructor Led Microsoft Excel Training 817-841-9560 excel@dfwexcel.com

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

$395 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/Time Event Registration
October 21, 2021
9:00 am - 5:00 pm
Excel Intermediate Part 3
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List
November 18, 2021
9:00 am - 5:00 pm
Excel Intermediate Part 3
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List
December 16, 2021
9:00 am - 5:00 pm
Excel Intermediate Part 3
Bedford Training Facility S8, Bedford TX
Class is Full. Add Your Name to the Waiting List

Date Location Price Registration
#_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}
Live Online Classes Schedule
Date/Time Event Registration
October 15, 2021
9:00 am - 5:00 pm
Excel Intermediate Part 3 Class is Full. Add Your Name to the Waiting List
November 19, 2021
9:00 am - 5:00 pm
Excel Intermediate Part 3 Class is Full. Add Your Name to the Waiting List
December 17, 2021
9:00 am - 5:00 pm
Excel Intermediate Part 3 Class is Full. Add Your Name to the Waiting List

Date Location Price Registration
#_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}

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.

Public Classes

Need to Pay via an Invoice?

No problem. If you need to pay with an invoice, please use our contact form and let us know what class you would like to attend and we will email you an invoice you can pay via your Accounts Payable department.

Contact Us

Phone

817-841-9560

Email

excel@dfwexcel.com

Office Address

5608 Malvey Ave,
Suite 14620,
Fort Worth, TX 76107

Mailing Address

PO Box 712
Aledo, TX 76008

Communication Preference