1. Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria

    Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria

    6
    0
    9
  2. Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

    Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

    3
    0
    15
  3. Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    3
    0
    8
  4. Excel Slicer Trick - Use Symbols instead of Text in Pivot Slicers

    Excel Slicer Trick - Use Symbols instead of Text in Pivot Slicers

    3
    0
    8
  5. Excel Arrow Variance Chart: Dynamic Arrows in Chart to Show Change to Previous Year / Budget

    Excel Arrow Variance Chart: Dynamic Arrows in Chart to Show Change to Previous Year / Budget

    5
    0
    25
  6. Better Excel Variance Charts to show percentage change (Simple & uncommon technique)

    Better Excel Variance Charts to show percentage change (Simple & uncommon technique)

    5
    0
    23
  7. TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

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

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

    3
    0
    6
  9. Skip Dates in Excel Charts (Ignore gaps in Excel horizontal chart axis)

    Skip Dates in Excel Charts (Ignore gaps in Excel horizontal chart axis)

    3
    0
    8
  10. 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
    6
  11. How to Conditionally Format Symbol colors in Excel Tables (without Conditional Formatting)

    How to Conditionally Format Symbol colors in Excel Tables (without Conditional Formatting)

    4
    0
    7
  12. Excel NETWORKDAYS function: Calculate the number of working days between two dates

    Excel NETWORKDAYS function: Calculate the number of working days between two dates

    3
    0
    5
  13. More On Media Consumption

    More On Media Consumption

    4
    0
    359
    4
  14. Excel Tables: Use Smart Conditional Formatting for great table layout

    Excel Tables: Use Smart Conditional Formatting for great table layout

    4
    0
    8
  15. Optimized Excel Line Charts: Prevent drop to zero & dynamic Legend positioning

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

    4
    0
    9
  16. Excel Charts: Total Values for Stacked Charts in Excel

    Excel Charts: Total Values for Stacked Charts in Excel

    4
    0
    6
  17. Excel Solver - Example and Step-By-Step Explanation

    Excel Solver - Example and Step-By-Step Explanation

    3
    0
    17
  18. How to add series lines / connectors to stacked column charts in Excel

    How to add series lines / connectors to stacked column charts in Excel

    3
    0
    14
  19. Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

    Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

    3
    0
    14
  20. Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    6
    0
    14
  21. Alternative to Doughnut Charts: BMW report study (Part 2)

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

    3
    0
    17
  22. The Top 5 Richest People In the World

    The Top 5 Richest People In the World

    61