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
    8
  2. Link Page Header to Cell Value with Excel VBA

    Link Page Header to Cell Value with Excel VBA

    3
    0
    11
  3. Excel VBA FIND Function (& how to handle if value NOT found)

    Excel VBA FIND Function (& how to handle if value NOT found)

    3
    0
    12
  5. 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
  6. 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
    4
  7. 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
    5
  8. Working Days Between Two Dates in Power BI (NETWORKDAYS 🗓️)

    Working Days Between Two Dates in Power BI (NETWORKDAYS 🗓️)

    5
  9. Add Leading Zeroes in Power BI (Text and Number Values)

    Add Leading Zeroes in Power BI (Text and Number Values)

    2
  10. What can Microsoft Excel do for your business & What not

    What can Microsoft Excel do for your business & What not

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

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

    3
    0
    12
  13. 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
    12
  14. How to use the Message Box in Excel VBA (syntax you'll need for msgbox)

    How to use the Message Box in Excel VBA (syntax you'll need for msgbox)

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

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

    4
    0
    35
  16. Convert NUMBERS to WORDS (NO VBA) in Excel

    Convert NUMBERS to WORDS (NO VBA) in Excel

    3
    0
    22
  17. How Power Query Will Change the Way You Use Excel

    How Power Query Will Change the Way You Use Excel

    4
    0
    39
  18. 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
  19. SUPER EASY Excel Data Entry Form (NO VBA)

    SUPER EASY Excel Data Entry Form (NO VBA)

    4
    0
    83
  20. Excel Combo Box without VBA - How to create a drop-down list

    Excel Combo Box without VBA - How to create a drop-down list

    4
    0
    3
  21. Split Each Excel Sheet Into a Separate File

    Split Each Excel Sheet Into a Separate File

    44
    1
  22. XLOOKUP Case Sensitive in Excel | Match Text Exactly

    XLOOKUP Case Sensitive in Excel | Match Text Exactly

    1
  23. Excel VBA: Adjust Fill Color of WordArt with a Macro

    Excel VBA: Adjust Fill Color of WordArt with a Macro

    3
    0
    23
  24. VBA to BROWSE & COPY Data from SELECTED File in Excel

    VBA to BROWSE & COPY Data from SELECTED File in Excel

    4
    0
    17
    1