In-depth with Excel's Conditional Formatting (2 hours) [NT] – On-Demand Webcast

Overview

The conditional formatting feature of Excel allows you to format a cell based on its value. In this session, we’ll quickly get warmed up by covering the basics and then look in-depth at its more useful capabilities, including using a formula to define the formatting rule, using icon sets to create alerts and filtering for duplicates. Presented in Excel for Windows. (Please note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.) The webcast was originally broadcast on June 1, 2016. Note: There is a minimum passing rate of 70% for this course.

Highlights

• Conditional formatting basics
• Conditional formatting icon sets
• Conditional formatting formulas

Designed For

Accountants using Excel for Windows.

Objectives

• Identify the feature in Excel that allows you to format a cell based on its value.
• Recall the steps for conditionally formatting and filtering duplicate values.
• Determine the steps that create an alert with icon sets.

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!