1. Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)

    Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)

    3
    0
    39
  2. 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
  3. 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
  4. 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
  5. Excel Workday function: Find end date - exclude weekends & holidays

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

    4
    0
    31
  6. How Power Query Will Change the Way You Use Excel

    How Power Query Will Change the Way You Use Excel

    4
    0
    45
  7. 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
  8. Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)

    Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)

    3
    0
    14
  9. 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
  10. 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
  11. 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
  12. Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

    Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

    3
    0
    19
  13. 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
  14. Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    3
    0
    17
  15. Excel A to Z mashup #1 (session 1 to 16)

    Excel A to Z mashup #1 (session 1 to 16)

    25
    3
    4
  16. Calculating Returns On a Rental Property (ROI with Excel Template)

    Calculating Returns On a Rental Property (ROI with Excel Template)

    5
    0
    79
  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. Update - News to Share and Upcoming Excel Videos, Tutorials & Courses

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

    4
    0
    41
  19. Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)

    Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)

    4
    0
    11
  20. Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

    Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)

    3
    0
    120
  21. 4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1

    4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1

    3
    0
    26