Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

Use Excel Conditional Formatting to Enhance Data Analysis

John Smith, Business Owner

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