1. 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
    34
  2. 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
    48
  3. Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function

    Create an Interactive Top N Report in Excel (includes duplicate values) with Filter Function

    3
    0
    31
  4. Many SEARCHABLE Drop-Down Lists in Excel (No VBA)

    Many SEARCHABLE Drop-Down Lists in Excel (No VBA)

    4
    0
    44
  5. 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
    21
  6. Do you know these 5 PowerPoint Hacks?

    Do you know these 5 PowerPoint Hacks?

    5
    0
    140
  7. How to Calculate Hours Worked with Excel Power Query (& Properly Sum time)

    How to Calculate Hours Worked with Excel Power Query (& Properly Sum time)

    3
    0
    85
  8. Excel FILTER Function TRICK for Non Adjacent Columns

    Excel FILTER Function TRICK for Non Adjacent Columns

    4
    0
    71
  9. Consolidate & Clean Multiple Excel Sheets in One Pivot Table

    Consolidate & Clean Multiple Excel Sheets in One Pivot Table

    4
    0
    72
  10. Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)

    Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)

    3
    0
    41
  11. 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
    137
  12. Excel: How to Best Import External Data into Excel & Import data from the Web to Excel

    Excel: How to Best Import External Data into Excel & Import data from the Web to Excel

    5
    0
    26
  13. Alternative to Doughnut Charts: BMW report study (Part 2)

    Alternative to Doughnut Charts: BMW report study (Part 2)

    3
    0
    15
  14. Easily Import Data from Web to Excel (2 Practical Examples)

    Easily Import Data from Web to Excel (2 Practical Examples)

    3
    0
    29
  15. 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
  16. Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort

    Excel Sort Data (by Value, Color, Icon, Own List) & How to Unsort

    3
    0
    25
  17. Do's & Don'ts of Excel Spreadsheet Design (with Examples)

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

    3
    0
    25
  18. Change CASE of text in Excel (3 ways including NO Formulas)

    Change CASE of text in Excel (3 ways including NO Formulas)

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

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

    3
    0
    12
  20. Why You Need to know the Time Value of Money Formula (Excel NPV)

    Why You Need to know the Time Value of Money Formula (Excel NPV)

    3
    0
    64
  21. Calculating Returns On a Rental Property (ROI with Excel Template)

    Calculating Returns On a Rental Property (ROI with Excel Template)

    5
    0
    79