1. Excel BEATS Google Sheets with THESE 10 Features!

    Excel BEATS Google Sheets with THESE 10 Features!

    8
    0
    276
    1
  2. Excel Filter Basics (for quick data analysis)

    Excel Filter Basics (for quick data analysis)

    3
    0
    18
  3. 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
  4. Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)

    Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)

    3
    0
    39
  5. LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)

    LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)

    4
    0
    41
  6. Do's & Don'ts of Excel Spreadsheet Design (with Examples)

    Do's & Don'ts of Excel Spreadsheet Design (with Examples)

    3
    0
    31
  7. SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

    SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

    3
    0
    13
  8. Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

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

    3
    0
    19
  9. Your Excel Printing Problems, Solved!

    Your Excel Printing Problems, Solved!

    3
    0
    21
  10. Why you SHOULD be USING Custom Number Formatting in Excel

    Why you SHOULD be USING Custom Number Formatting in Excel

    3
    0
    9
  11. Fully Dynamic Emails from Excel with a SINGLE FORMULA!

    Fully Dynamic Emails from Excel with a SINGLE FORMULA!

    3
    0
    26
  12. Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

    Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

    3
    0
    51
  13. 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
  14. Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

    Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

    3
    0
    20
  15. Improve readability of Excel Line Charts: Dynamic Legends in Excel

    Improve readability of Excel Line Charts: Dynamic Legends in Excel

    5
    0
    26
    1
  16. Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query)

    Discover the EASY way to Transform Text in Excel (No Formulas - just Power Query)

    3
    0
    38
  17. Excel Dependent Drop Down List with Tabular Data without Named Ranges

    Excel Dependent Drop Down List with Tabular Data without Named Ranges

    4
    0
    17
  18. Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

    Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

    4
    0
    38