Loading...

Highline Excel 2016 Class 16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas

54,019 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 22, 2016

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

Loading...

Advertisement

to add this to Watch Later

Add to

Loading playlists...