New Lecture Has Been Added - Skillshare

# Use Excel Conditional Formatting to Enhance Data Analysis

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
35 Videos (1h 19m)
• What Is Conditional Formatting?

3:49
• More Examples of Using Conditional Formatting

2:53
• Excel Knowledge Prerequisites Before Taking This Course

1:01
• How to Remove Conditional Formatting

1:59
• Greater Than

1:50
• Less Than

1:36
• Between

1:10
• Equal To

1:46
• Text That Contains

1:32
• A Date Occurring

2:49
• Duplicate Values/Unique Values

2:53
• Top and Bottom X Amount of Items Conditional Formatting

1:14
• Top and Bottom X% of Items Conditional Formatting

1:24
• Above and Below Average Conditional Formatting

1:27
• Gradient and Solid Data Bar Fills

3:41
• Introduction and Explanation of Icon Sets

1:26
• Directional Icon Sets

1:03
• Shapes and Indicator Icon Sets

1:35
• Ratings Icon Sets

1:05
• Conditional Formatting Based on a Specific Cell (Highly Recommended)

1:40
• Using Conditional Formatting In Filters

1:59
• Order of Conditional and How to Change It

3:17
• Copy and Paste Conditional Formatting in Different Sheets and Workbooks

6:09
• Introduction to Creating Your Own Custom Conditional Formatting Rules

4:24
• Before Creating Custom Formulas You Need to Know How to Lock Rows and Columns

2:45
• Highlight Cells Containing Time Information Using Formulas

4:05
• Creating Custom Icon Set Ranges

2:01
• Highlighting the Whole Row Based on a Column

2:52
• Dynamic Way of Selecting Whole Row Based on a Cell

2:15
• Comparing Values In Two Columns Using Formulas

1:30
• Comparing Two Different Lists For Matches or Mismatches

2:44
• Changing Colours of Alternating Rows Using Formulas in Conditional Formatting

3:05
• Finding Duplicates Using Formulas in Conditional Formatting

1:06
• Finding Duplicates Using Criteria From Two Columns

1:30
• Using Conditional Formatting to Find Discrepancies

1:43