Another exquisit release
Lynda.Excel.2016.Conditional.Formatting.in.Depth-XQZT
Title: Excel 2016: Conditional Formatting in Depth
Publisher: Lynda
Iso Size: 215M (224587776 B)
Files: 5F
Date: 07/18/2017
Course #: 597010
Type: Spreadsheets
Published: 7/17/2017
Modified: N/A
URL: www.lynda.com/Excel-tutorials/Excel-2016-Conditional-Formatting-Depth/597010-2.html
Author: Dennis Taylor
Duration: 1h 1m
Skill: Intermediate
Exercise: [X]
Installation:
Unpack that shit, mount that shit, run that shit
Notes:
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.