Use Excel Conditional Formatting to Enhance Data Analysis | John Smith | Skillshare

Use Excel Conditional Formatting to Enhance Data Analysis

John Smith, Business Owner

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

      3:49
    • 2. More Examples of Using Conditional Formatting

      2:53
    • 3. Excel Knowledge Prerequisites Before Taking This Course

      1:01
    • 4. How to Remove Conditional Formatting

      1:59
    • 5. Greater Than

      1:50
    • 6. Less Than

      1:36
    • 7. Between

      1:10
    • 8. Equal To

      1:46
    • 9. Text That Contains

      1:32
    • 10. A Date Occurring

      2:49
    • 11. Duplicate Values/Unique Values

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

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

      1:24
    • 14. Above and Below Average Conditional Formatting

      1:27
    • 15. Gradient and Solid Data Bar Fills

      3:41
    • 16. Introduction and Explanation of Icon Sets

      1:26
    • 17. Directional Icon Sets

      1:03
    • 18. Shapes and Indicator Icon Sets

      1:35
    • 19. Ratings Icon Sets

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

      1:40
    • 21. Using Conditional Formatting In Filters

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

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

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

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

      2:45
    • 26. Highlight Cells Containing Time Information Using Formulas

      4:05
    • 27. Creating Custom Icon Set Ranges

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

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

      2:15
    • 30. Comparing Values In Two Columns Using Formulas

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

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

      3:05
    • 33. Finding Duplicates Using Formulas in Conditional Formatting

      1:06
    • 34. Finding Duplicates Using Criteria From Two Columns

      1:30
    • 35. Using Conditional Formatting to Find Discrepancies

      1:43