Completed
) Discussion about Volatile nature of Conditional Formatting and how it affects Spreadsheet Calculation Time.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Conditional Formatting to Visualize Data - Built-in and Logical Formulas
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Built-in Feature: Cell Contains
- 3 ) Logical Formula: Highlight Row (Record) where cell contains a value.
- 4 ) Built-in Feature: Below Average
- 5 ) Logical Formula: Highlight Row (Record) where sales are below average.
- 6 ) Discussion about Volatile nature of Conditional Formatting and how it affects Spreadsheet Calculation Time.
- 7 ) Built-in Feature: Top 3 values
- 8 ) Logical Formula: Highlight Records that contain the top 3 values
- 9 ) Built-in Feature: Data Bars
- 10 ) Adding Borders to Report
- 11 ) Built-in Feature: Color Scales (Heat Map)
- 12 ) Built-in Feature: Icons
- 13 ) Logical Formula: Format Whole Column Based on a condition. Learn about SIGN function.
- 14 ) Logical Formula: Format with complex criteria (AND Logical Test)
- 15 ) Logical Formula: Format with complex criteria (OR Logical Test). See how to use MATCH function.
- 16 ) Logical Formula: Format Weekends and Holidays. Learn about NETWORKDAYS function.
- 17 ) Logical Formula: Format items NOT in List
- 18 ) Summary
