CPATrainingCenter.com offers CPA exams, accounting degree training, CPE, and professional development for accountants and CPAs
Course/Product Description
Title:

Excel Training: Conditional Formatting

SKU:WT-1001714
Format: Webinar
Description:

Excel Training: 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
About Your Speaker:

David Ringstrom, CPA, is the Tech Editor-at-Large for AccountingWEB and Going Concern. David speaks at conferences nationally and presents dozens of webinars annually on Excel and other topics. He offers Excel training and consulting services nationwide, and has written numerous articles on spreadsheets.


Other Excel Topics

This course is just one of several Excel training courses we offer as part of our Excel training line. Go to www.CPATrainingCenter.com/Excel-Training-For-Accountants.asp to see the full list of Excel training courses.

About The Provider: The Industry Calendar creates and sells webinars, audio conferences, and seminars for busy business professionals.

For over ten years we've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily learn about key training topics that keep you up-to-date on trends and best practices, all while helping to keep you in compliance with the various rules and regulations affecting your organization.
Price: $239.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Webcast
Course TitleDatePrice
High Impact Excel: Conditional FormattingCD/On-Demand$239.00

Sales &Use Tax Workshop
Sales &Use Tax Workshop

Audit Training
Audit Training

Retirement Plan Training Courses
Retirement Plan Training Courses

Payroll Training
Payroll Training

Peachtree Seminars
Peachtree Seminars

Project Management Workshop
Project Management Workshop

Microsoft® Excel® 2007/2010 Basics
Microsoft® Excel® 2007/2010 Basics

How To Use QuickBooks
How To Use QuickBooks

Securities Licensing
Securities Licensing

Multi-State Payroll Tax Compliance
Multi-State Payroll Tax Compliance

Compliance Tips For Gifts, Awards, &Other Fringe Benefits
Compliance Tips For Gifts, Awards, &Other Fringe Benefits

Payroll Requirements For Terminated Employees
Payroll Requirements For Terminated Employees

Payroll Paycards: How To Save Costs AND Maintain Compliance
Payroll Paycards: How To Save Costs AND Maintain Compliance

Managing Exemptions And Resale Certificates
Managing Exemptions And Resale Certificates

Chartered Tax Professional Certificate Program
Chartered Tax Professional Certificate Program

Comprehensive Income Tax Course with Career Package
Comprehensive Income Tax Course with Career Package

Google+CPATrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-9941 | support@CPATrainingCenter.com
Copyright CPATrainingCenter.com 2018 | Web Site Development by OTAU
Facebook