Mobile Edition


In-depth with Excel's Conditional Formatting (4173131B)

 
Date:Friday, January 12, 2018
Time:11:30AM - 1:30 PM
(Registration at 11:00AM)
Facility:Webcast or Webinar, Online
CPE Credit:2.0 Technical Business
Instructor: Jeff S. Lenning
Vendor:California CPA Education Foundation
Course Level:Basic
Early Bird Price:$60.00 FICPA Members, $90.00 Non-Members

Description:

The conditional formatting feature of Excel allows you to format a cell based on its value. In this session, quickly get warmed up by covering the basics and then look in-depth at its more useful capabilities. These capabilities include using a formula to define the formatting rule, using icon sets to create alerts and filtering for duplicates. Presented in Excel for Windows.

Note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.



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.


Major Topics:
  • Conditional formatting basics
  • Conditional formatting icon sets
  • Conditional formatting formulas


Who Should Attend:

Accountants using Excel for Windows.



Prerequisite:
None.

Advanced Preparation:
None.

Session/Options

If listed below, select the appropriate sessions or options to continue with your purchase.

Registration Status: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (800) 342-3197 if you wish to inquire about registering.