Excel 2016: Conditional Formatting in Depth

Excel 2016: Conditional Formatting in Depth

Website or Online Data - 2017
Rate this:
Excel's conditional formatting feature allows you to highlight data based on cell contents, making it easy to spot trends and patterns and emphasize key results. Though this process can be quick and easy, many Excel users don't know how to use conditional formatting to its fullest potential. In this brief course, Excel trainer Dennis Taylor walks you through how to apply and customize conditional formatting to quickly pinpoint variances in your data. Dennis begins with a demonstration of how to format based on cell content or formulas. Next, he shows how to go beyond Excel's default formatting (cell highlighting) by using data bars, icon sets, and color scales. Lastly, Dennis shows how to apply conditional formatting across rows, including how to highlight PivotTable results and incorporate check boxes and data validation pick lists to create dynamic visual displays.
Learn how to use Excel's conditional formatting to highlight data dynamically, to emphasize key results or spot trends and patterns in your spreadsheets.
Publisher: Carpenteria, CA : lynda.com, 2017
Copyright Date: ©2017
Branch Call Number: eResearch
Additional Contributors: lynda.com (Firm)


From the critics

Community Activity


Add a Comment

There are no comments for this title yet.


Add Age Suitability

There are no ages for this title yet.


Add a Summary

There are no summaries for this title yet.


Add Notices

There are no notices for this title yet.


Add a Quote

There are no quotes for this title yet.

Explore Further


Subject Headings


Find it at DCL

To Top