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)

Opinion

From the critics


Community Activity

Comment

Add a Comment

There are no comments for this title yet.

Age

Add Age Suitability

There are no ages for this title yet.

Summary

Add a Summary

There are no summaries for this title yet.

Notices

Add Notices

There are no notices for this title yet.

Quotes

Add a Quote

There are no quotes for this title yet.

Explore Further

Recommendations

Subject Headings

  Loading...

Find it at DCL

  Loading...
[]
[]
To Top