Главная
Study mode:
on
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
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Visualization
0:00 / 0:00
1 of 18

) Introduction