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

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

    4
    0
    35
  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. How Power Query Will Change the Way You Use Excel

    How Power Query Will Change the Way You Use Excel

    4
    0
    39
  10. Add Leading Zeroes in Power BI (Text and Number Values)

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

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

    What can Microsoft Excel do for your business & What not

    4
    0
    5
  12. 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
  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. Excel VBA: Adjust Fill Color of WordArt with a Macro

    Excel VBA: Adjust Fill Color of WordArt with a Macro

    3
    0
    23
  15. SUPER EASY Excel Data Entry Form (NO VBA)

    SUPER EASY Excel Data Entry Form (NO VBA)

    4
    0
    83
  16. Free Excel Tool: Unhide Worksheet Utility (select sheets to unhide)

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

    3
    0
    12
  17. VBA to BROWSE & COPY Data from SELECTED File in Excel

    VBA to BROWSE & COPY Data from SELECTED File in Excel

    4
    0
    17
    1
  18. 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
  19. Split Each Excel Sheet Into a Separate File

    Split Each Excel Sheet Into a Separate File

    45
    1
  20. Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

    Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

    3
    0
    30
  21. 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
    17
  22. Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

    Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

    3
    0
    30
  23. Convert NUMBERS to WORDS (NO VBA) in Excel

    Convert NUMBERS to WORDS (NO VBA) in Excel

    3
    0
    22