1. 3 REALLY Useful Excel Chart Tips You May Have Missed

    3 REALLY Useful Excel Chart Tips You May Have Missed

    4
    0
    10
  2. Excel Hack: Copy Formula Without Changing Cell References (or Without File References)

    Excel Hack: Copy Formula Without Changing Cell References (or Without File References)

    3
    0
    16
  3. Make better Excel tables: BMW report to the test (Part 3)

    Make better Excel tables: BMW report to the test (Part 3)

    3
    0
    10
  4. Count Day of Week Between Dates in Excel (How many Fridays?)

    Count Day of Week Between Dates in Excel (How many Fridays?)

    3
    0
    10
  5. 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
  6. Excel Waterfall Charts: Business Examples of Waterfall Charts and When to Use Them in Your Reports

    Excel Waterfall Charts: Business Examples of Waterfall Charts and When to Use Them in Your Reports

    4
    0
    22
  7. Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook

    Excel VBA Arrays: Practical Example of a 2 dimensional array to create a New Workbook

    3
    0
    16
  8. Excel SUM based on Partial Text Match (SUMIFS with wildcards)

    Excel SUM based on Partial Text Match (SUMIFS with wildcards)

    3
    0
    12
  9. Excel Workday function: Find end date - exclude weekends & holidays

    Excel Workday function: Find end date - exclude weekends & holidays

    4
    0
    31
  10. 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
  11. Excel VBA: Loop through cells inside the used range (For Each Collection Loop)

    Excel VBA: Loop through cells inside the used range (For Each Collection Loop)

    3
    0
    7
  12. 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
  13. Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)

    Excel VBA basics: Data types, DIM & SET (Learn to use them correctly)

    3
    0
    6
  14. Update - News to Share and Upcoming Excel Videos, Tutorials & Courses

    Update - News to Share and Upcoming Excel Videos, Tutorials & Courses

    4
    0
    42
  15. 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
  16. Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT

    Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT

    4
    0
    12
  17. Easiest Excel Waterfall Chart (Bridge graph) from Scratch - Works with minus values

    Easiest Excel Waterfall Chart (Bridge graph) from Scratch - Works with minus values

    4
    0
    18
  18. Excel Hidden Shortcut to Select Data Column including Blanks

    Excel Hidden Shortcut to Select Data Column including Blanks

    3
    0
    47
  19. Why You Need to know the Time Value of Money Formula (Excel NPV)

    Why You Need to know the Time Value of Money Formula (Excel NPV)

    3
    0
    70
  20. 3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

    3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

    3
    0
    125
  21. How to Create a Pivot Table in Excel

    How to Create a Pivot Table in Excel

    14