1. Excel Charts: Total Values for Stacked Charts in Excel

    Excel Charts: Total Values for Stacked Charts in Excel

    4
    0
    6
  2. Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    6
    0
    14
  3. Impressive Slide Design: Create Custom Shapes and Typography in PowerPoint

    Impressive Slide Design: Create Custom Shapes and Typography in PowerPoint

    4
    0
    71
  4. 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
  5. Quick Excel Trick to Unstack Data from one Column to Multiple Columns

    Quick Excel Trick to Unstack Data from one Column to Multiple Columns

    3
    0
    140
  6. Excel Dashboard with 4 Strange Features (Excel Hash Episode)

    Excel Dashboard with 4 Strange Features (Excel Hash Episode)

    5
    0
    102
  7. How to create a Step Chart in Excel (that is fully dynamic & easy to read)

    How to create a Step Chart in Excel (that is fully dynamic & easy to read)

    3
    0
    9
  8. Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

    Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

    4
    0
    15
  9. How to create barcodes in Excel that WORK!

    How to create barcodes in Excel that WORK!

    3
    0
    27
  10. Excel Simple Dependent Drop down List based on numbers (Index without match)

    Excel Simple Dependent Drop down List based on numbers (Index without match)

    4
    0
    12
  11. Quick Gantt Chart in Excel (Unusual technique)

    Quick Gantt Chart in Excel (Unusual technique)

    3
    0
    22
  12. Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)

    Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)

    4
    0
    39
  13. TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    3
    0
    10
  14. 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
    15
  15. Excel Filter Basics (for quick data analysis)

    Excel Filter Basics (for quick data analysis)

    3
    0
    18
  16. Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

    Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

    3
    0
    26
  17. 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
    11
  18. 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
  19. Excel Solver - Example and Step-By-Step Explanation

    Excel Solver - Example and Step-By-Step Explanation

    3
    0
    17
  20. 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
  21. 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
  22. Unusual use of Excel's Custom Number Formatting with Conditions & Symbols (Part 2)

    Unusual use of Excel's Custom Number Formatting with Conditions & Symbols (Part 2)

    3
    0
    8
  23. 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
    8
  24. Alternative to Doughnut Charts: BMW report study (Part 2)

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

    3
    0
    19
  25. How to SUM Cells by Color in Excel (Get it to update automatically)

    How to SUM Cells by Color in Excel (Get it to update automatically)

    3
    0
    22