Print Page   |   Contact Us   |   Your Cart   |   Sign In   |   Join
In-depth with Excel's Conditional Formatting 4173131A
View Registrations Tell a Friend About This EventTell a Friend
 

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.

8/11/2017
When: 9:30 AM to 11:30 AM
Where: Webcast
CALCPA
4173131A
United States
Presenter: Jeff S. Lenning, CPA, CITP
Contact: April Deneault
801-466-10299


Online registration is closed.
« Go to Upcoming Event List  

Curriculums:   Computers and Technology

NASBA Credit Category:  Computer Software and Applications

CPE Hours:  2

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.

Materials are provided as an ebook.



Major Subjects

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

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.

Level:  Beginning

Designed For

Accountants using Excel for Windows.

Advanced Prep:

None.

Prerequisite

None.

Price:

Members: $60

Nonmembers: $94

Membership Management Software Powered by YourMembership  ::  Legal