High Impact Excel: Conditional Formatting

Conditional formatting is one of the most under-appreciated features in Excel. It allows you to identify duplicate or unique items on a list, or to filter lists based on formatting that you have applied.

With just a few mouse clicks you can use Conditional Formatting to enliven your data with icons, in-cell graphs, or colors so that you can see patterns in your data. After this session you'll never look at lists of data the same way again.

This course is taught by Excel expert David Ringstrom, CPA - who is also the Tech Editor-at-Large for AccountingWEB. David will teach from primarily from Excel 2010, but will demonstrate new features in Excel 2013 when warranted, as well as disclose any differences in Excel 2007. Coverage of Excel 2003 will be limited to questions raised by the audience.

Learning Objectives:

• Use the Quick Analysis feature in Excel 2013 to get a jump start with conditional formatting
  
• Use Conditional Formatting to identify unprotected worksheet cells
  
• In Excel 2007 and later use the Filter feature in conjunction with conditional formatting to filter by color or cell icon
  
• Use Conditional Formatting to identify duplicate values in a list
  
• See how the Quick Analysis feature in Excel 2013 empowers any use to get started with Conditional Formatting
  
• Understand the nuances that sometimes apply to using Conditional Formatting successfully
  
• Identify groups of data by using color scales, data bars, and cell icons
  
• Filter data based on conditional formatting
  
• Use Excel’s CEILING function with Conditional Formatting to color code rows in groups of 3, 5 or whatever number you choose
  
• Use Conditional Formatting to identify unlocked cells that the user can enter data into
  
• Transform dates and numbers into various formats without retyping by way of custom number formats

Webcasts, audio conferences, and podcasts are presentations that you attend via the Internet, phone, or mobile device at a specified date and time for "live" versions, or at your convenience for "recorded" and "On-Demand" versions.

The live versions are interactive, meaning that participants can ask questions in real time, plus are a very cost-effective form of training because 1) you receive fast, convenient learning without any out-of-office time; 2) you can invite as many colleagues as you'd like to listen in on a single phone line; 3) you incur no travel expenses; and 4) you and your colleagues are back at work immediately after the session ends!

And though with recorded versions you do lose the ability to ask questions, you gain the ability to hear the presentation numerous times and to share it with others in your office.

Handout materials and the phone number for live presentations are made available to you prior to the event via email from the presenter and from the "MyAccount" link on the menu bar. Copies of the presentations are included with recorded versions.