Excel Conditional Formatting Training: 1 Day

Excel Conditional Formatting Training Course Excel Conditional Formatting Training
By TED Integrated
Microsoft® Excel Series:

Interactive Conditional Formatting in Excel 2013-2016

“One of the most useful, but underutilized tools in Excel...”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Email Customer Service [email protected] Contact Customer Service +603-2386-7788
Course Title:
Interactive Conditional Formatting in Excel 2013-2016
Training Category:
Information Technology
Target Audience:
For users who have completed Microsoft Excel Basic & Intermediate.
Duration:
1 Day
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Workshop
  • Presentation Handouts
  • Computer Lab Work
  • Lecture
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

Conditional formatting is one of the most useful, but underutilized tools in Excel. By instantly "visualizing data", conditional formatting is capable of highlighting important information that often unaware of us. It's great for busy managers and executives who like to scan for the most important information as quicker as possible. Conditional formatting is a great way to visually highlight important information in a worksheet.

You can think of conditional formatting as an automated formatting that is triggered by conditions you defined. For instance, you can use conditional formatting to automatically change the color of cells that contain values greater than or less certain values.

This course covers the basics of conditional formatting and from there moving towards applying specific formulas to further enhance the criteria settings of each condition. This course will also guide you on how to apply conditional formatting to Pivot. For users of Excel 2013 - 2016 we further guide you on how you can use Slicers effectively to be linked to tables with Conditional Formatting.

Course Objectives ›

At the end of the course, participants should be able to understand and perform the following:

  • Basics of Conditional Formatting
  • Leveraging Conditional Formatting
  • Conditional Formatting with Formulas
  • Conditional Formatting in Pivot
  • Conditional Formatting with Slicer (2013-2016 only)

Prerequisites ›

Completion of Microsoft Excel (Basic & Intermediate) course or equivalent knowledge.

Course Outline ›

DAY 1

Module 1- Basics of Conditional Formatting

  • What is excel conditional formatting?
  • Applying Cell Highlighting
  • Applying Top, Bottom, and Average Rules
  • Applying Data Bars, Color Scales, and Icon Sets
  • Data Bars
  • Icon Sets

Module 2 - Leveraging Conditional Formatting

  • Cells with negative numbers
  • Creating an Excel conditional formatting rule from scratch
  • Excel conditional formatting based on cell's value
  • Apply several conditional formatting rules to one cell / table
  • Using "Stop If True" in conditional formatting rules
  • Edit conditional formatting rules in Excel
  • Delete conditional formatting rules

Module 3 - Conditional Formatting with Formulas

  • Relative and Absolute Cell References in Conditional Formatting
  • Multiple Selection using OR function
  • Highlight Cells with Odd numbers
  • Formula logic
  • Highlight orders from specific State
  • Highlight dates in the next 30 days
  • Highlight column differences
  • Highlight missing values
  • Highlight cells that match 2 criteria
  • Highlight top values (dynamic example)
  • Highlight Max and Min values in a range
  • Simple search box
  • Hide Errors
  • Hide Duplicate Values
  • Highlight Duplicate Records in a List
  • Highlight Cells with Formulas
  • Show Temperatures with a Color Scale
  • Highlight Upcoming Expiry Dates
  • Colour Cells Based on 2 Conditions
  • Fix Conditional Formatting Extra Rules
  • Data Bars Tips

Module 4 - Conditional Formatting in Pivot

  • Conditional Formatting in Pivot Table
  • Apply Formatting to Pivot Table Cells
  • Problems After Updating the Pivot Table
  • Change the Formatting Range
  • Moving data around
  • Limiting conditional formats

Module 5 - Conditional Formatting with Slicer (2013-2016 only)

  • Identifying Report Area
  • Make a list of Style Names
  • Add a Slicer
  • Apply Conditional Formats to the Report

Delivery Methods ›

This course is Instructor led group-paced, hands-on classroom-training with activities. Manuals are provided for each student for after-class reference.

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,