Conditional Formatting to Visualize Data - Built-in and Logical Formulas

Overview

Explore advanced conditional formatting techniques in Excel 2016 to effectively visualize data using built-in features and logical formulas. Learn how to highlight specific cells, rows, and records based on various criteria, including cell contents, below-average values, and top performers. Discover the power of data bars, color scales, and icon sets for creating visually appealing reports. Dive into complex formatting scenarios using logical formulas with AND and OR conditions, and master functions like SIGN, MATCH, and NETWORKDAYS. Gain insights on optimizing spreadsheet calculation time and apply formatting to weekends, holidays, and items not in a list. Download accompanying files to practice these skills and enhance your Excel proficiency in data visualization and analysis.

Syllabus

) Introduction.
) Built-in Feature: Cell Contains.
) Logical Formula: Highlight Row (Record) where cell contains a value..
) Built-in Feature: Below Average.
) Logical Formula: Highlight Row (Record) where sales are below average..
) Discussion about Volatile nature of Conditional Formatting and how it affects Spreadsheet Calculation Time..
) Built-in Feature: Top 3 values.
) Logical Formula: Highlight Records that contain the top 3 values.
) Built-in Feature: Data Bars.
) Adding Borders to Report.
) Built-in Feature: Color Scales (Heat Map).
) Built-in Feature: Icons.
) Logical Formula: Format Whole Column Based on a condition. Learn about SIGN function..
) Logical Formula: Format with complex criteria (AND Logical Test).
) Logical Formula: Format with complex criteria (OR Logical Test). See how to use MATCH function..
) Logical Formula: Format Weekends and Holidays. Learn about NETWORKDAYS function..
) Logical Formula: Format items NOT in List.
) Summary.