1. How to use Excel Index Match (the right way)

    How to use Excel Index Match (the right way)

    5
    0
    41
  2. Excel FILTER Function TRICK for Non Adjacent Columns

    Excel FILTER Function TRICK for Non Adjacent Columns

    4
    0
    69
  3. Calculate Percentages the Right Way in Excel (% Change & Amount after % increase)

    Calculate Percentages the Right Way in Excel (% Change & Amount after % increase)

    4
    0
    23
  4. 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
    37
  5. Excel NETWORKDAYS function: Calculate the number of working days between two dates

    Excel NETWORKDAYS function: Calculate the number of working days between two dates

    3
    0
    5
  6. Excel 2016 Waterfall Chart - Advantages and Limitations - Ultimate guide to Excel's Bridge Graph

    Excel 2016 Waterfall Chart - Advantages and Limitations - Ultimate guide to Excel's Bridge Graph

    4
    0
    33
  7. How to Create an Excel Interactive Chart with Dynamic Arrays

    How to Create an Excel Interactive Chart with Dynamic Arrays

    5
    0
    89
  8. Complete: Excel Hidden SHORTCUTS to Select Data Column including Blanks

    Complete: Excel Hidden SHORTCUTS to Select Data Column including Blanks

    3
    0
    28
  9. Excel Hidden Shortcut to Select Data Column including Blanks

    Excel Hidden Shortcut to Select Data Column including Blanks

    3
    0
    43
  10. 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
    9
  11. Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    6
    0
    11
  12. Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

    Automatically skip blanks in Excel charts with formulas (ignore gaps in Excel chart axis)

    3
    0
    15
  13. Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT

    3
    0
    8
  14. Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)

    Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)

    3
    0
    10
  15. Excel Conditional Formatting the Lookup result in data table (Index Match)

    Excel Conditional Formatting the Lookup result in data table (Index Match)

    4
    0
    9
  16. Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel

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

    3
    0
    15
  17. This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)

    This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this)

    3
    0
    18
  18. Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells

    Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells

    3
    0
    19
  19. 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
  20. How To Create A Histogram in Excel (& change the bin size)

    How To Create A Histogram in Excel (& change the bin size)

    4
    0
    76
  21. Consolidate & Clean Multiple Excel Sheets in One Pivot Table

    Consolidate & Clean Multiple Excel Sheets in One Pivot Table

    4
    0
    70
  22. Excel Dynamic Filled Map Chart with Power Query

    Excel Dynamic Filled Map Chart with Power Query

    4
    0
    45
  23. How Power Query Will Change the Way You Use Excel

    How Power Query Will Change the Way You Use Excel

    4
    0
    40
  24. Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)

    Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)

    4
    0
    98
  25. 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
    32