Completed
) Logical Formula: Highlight Records that contain the top 3 values
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
