2. Excel Conditional Formatting with Symbols and Icons (for better reports)

    Excel Conditional Formatting with Symbols and Icons (for better reports)

    3
    0
    10
  3. Excel Dependent Drop Down List with Tabular Data without Named Ranges

    Excel Dependent Drop Down List with Tabular Data without Named Ranges

    4
    0
    15
  4. Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)

    Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)

    3
    0
    12
  5. Charting Survey Results in Excel (Visualize Employee Satisfaction results)

    Charting Survey Results in Excel (Visualize Employee Satisfaction results)

    3
    0
    7
  6. Excel IF Function with PARTIAL Text Match (IF with Wildcards)

    Excel IF Function with PARTIAL Text Match (IF with Wildcards)

    3
    0
    8
  7. Why you SHOULD be USING Custom Number Formatting in Excel

    Why you SHOULD be USING Custom Number Formatting in Excel

    3
    0
    7
  8. Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!

    Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!

    3
    0
    11
  9. VBA to BROWSE & COPY Data from SELECTED File in Excel

    VBA to BROWSE & COPY Data from SELECTED File in Excel

    4
    0
    16
    1
  10. Excel Reset Week Number Every Month - (WeekDay & WeekNum Functions Explained)

    Excel Reset Week Number Every Month - (WeekDay & WeekNum Functions Explained)

    3
    0
    8
  11. 5 Eye-Tracking Discoveries for OPTIMAL Chart Design - Do you use these?

    5 Eye-Tracking Discoveries for OPTIMAL Chart Design - Do you use these?

    3
    0
    10
  12. Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability

    Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability

    4
    0
    9
  13. Easiest Step Chart in Excel (this trick will surprise you!)

    Easiest Step Chart in Excel (this trick will surprise you!)

    3
    0
    7
  14. Excel Dynamic Chart with Drop down List (column graph with average line)

    Excel Dynamic Chart with Drop down List (column graph with average line)

    3
    0
    8
  15. Alternative to Doughnut Charts: BMW report study (Part 2)

    Alternative to Doughnut Charts: BMW report study (Part 2)

    3
    0
    13
  16. Excel Charts: How To Show Percentages in Stacked Charts (in addition to values)

    Excel Charts: How To Show Percentages in Stacked Charts (in addition to values)

    5
    0
    5
  17. Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder

    Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder

    3
    0
    17
  18. Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioning

    Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioning

    4
    0
    5
  19. Excel Filter Basics (for quick data analysis)

    Excel Filter Basics (for quick data analysis)

    3
    0
    4
  20. TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    3
    0
    8
  21. Excel Formula Lookup Multiple Results: Return headers based on matrix values

    Excel Formula Lookup Multiple Results: Return headers based on matrix values

    3
    0
    5
  22. Excel Sum(ifs) between dates, sum month & sum with multiple criteria

    Excel Sum(ifs) between dates, sum month & sum with multiple criteria

    3
    0
    19
  23. Return Multiple Match Results in Excel (2 methods)

    Return Multiple Match Results in Excel (2 methods)

    3
    0
    4
  25. Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

    Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

    3
    0
    4