Highline Excel 2016 Class 16

Conditional Formatting to Visualize Data: Built-in & Logical Formulas

DESCRIPTION

In this video learn about Conditional Formatting Topics :
(00:16) Introduction
(00:43) Built-in Feature: Cell Contains
(03:28) Logical Formula: Highlight Row (Record) where cell contains a value.
(10:00) Built-in Feature: Below Average
(10:55) Logical Formula: Highlight Row (Record) where sales are below average.
(13:02) Discussion about Volatile nature of Conditional Formatting and how it affects Spreadsheet Calculation Time.
(16:10) Built-in Feature: Top 3 values
(16:53) Logical Formula: Highlight Records that contain the top 3 values
(19:28) Built-in Feature: Data Bars
(21:16) Adding Borders to Report
(22:54) Built-in Feature: Color Scales (Heat Map)
(24:55) Built-in Feature: Icons
(29:25) Logical Formula: Format Whole Column Based on a condition. Learn about SIGN function.
(31:47) Logical Formula: Format with complex criteria (AND Logical Test)
(34:00) Logical Formula: Format with complex criteria (OR Logical Test). See how to use MATCH function.
(37:00) Logical Formula: Format Weekends and Holidays. Learn about NETWORKDAYS function.
(41:13) Logical Formula: Format items NOT in List
(43:27) Summary

WORKBOOKS

Download “Highline Excel 2016 Class 16” Highline-Excel-2016-Class-16.zip – Downloaded 6 times – 2 MB




Be the first to comment

Leave a Reply