1. Excel IF Function with PARTIAL Text Match (IF with Wildcards)

    Excel IF Function with PARTIAL Text Match (IF with Wildcards)

    3
    0
    8
  2. Why you SHOULD be USING Custom Number Formatting in Excel

    Why you SHOULD be USING Custom Number Formatting in Excel

    3
    0
    7
  3. Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!

    Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!

    3
    0
    11
  4. 5 Excel INTERVIEW Questions You NEED to Get RIGHT

    5 Excel INTERVIEW Questions You NEED to Get RIGHT

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

    VBA to BROWSE & COPY Data from SELECTED File in Excel

    4
    0
    16
    1
  6. The QUICKEST & EASIEST Way to Work with TEXT in Excel

    The QUICKEST & EASIEST Way to Work with TEXT in Excel

    3
    0
    9
  7. 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
    13
  8. Use PowerPoint SLIDE ZOOM the RIGHT WAY

    Use PowerPoint SLIDE ZOOM the RIGHT WAY

    3
    0
    16
  9. Complete: Excel Hidden SHORTCUTS to Select Data Column including Blanks

    Complete: Excel Hidden SHORTCUTS to Select Data Column including Blanks

    3
    0
    27
  10. 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
  11. Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

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

    4
    0
    15
  12. Excel Cell Reference: Absolute, Relative or Mixed?

    Excel Cell Reference: Absolute, Relative or Mixed?

    3
    0
    10
  13. Excel Reset Week Number Every Month - (WeekDay & WeekNum Functions Explained)

    Excel Reset Week Number Every Month - (WeekDay & WeekNum Functions Explained)

    3
    0
    8
  14. Excel Variance Charts: Actual to Previous Year or Budget Comparisons

    Excel Variance Charts: Actual to Previous Year or Budget Comparisons

    5
    0
    22
  15. 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
  16. 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
  17. Excel Custom Data Validation (Use formulas to check for text, numbers & length)

    Excel Custom Data Validation (Use formulas to check for text, numbers & length)

    4
    0
    21
  18. 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
    10
  19. 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
  20. Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability

    Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability

    4
    0
    9
  21. Easiest Step Chart in Excel (this trick will surprise you!)

    Easiest Step Chart in Excel (this trick will surprise you!)

    3
    0
    7
  22. How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)

    How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)

    3
    0
    8
  23. 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
  24. Convert NUMBERS to WORDS (NO VBA) in Excel

    Convert NUMBERS to WORDS (NO VBA) in Excel

    3
    0
    22
  25. Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

    Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

    4
    0
    8