1. Excel SUM based on Partial Text Match (SUMIFS with wildcards)

    Excel SUM based on Partial Text Match (SUMIFS with wildcards)

    3
    0
    12
  2. 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
  3. 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
  4. Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA

    Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA

    3
    0
    67
  5. Easily Import Data from Web to Excel (2 Practical Examples)

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

    3
    0
    29
  6. Better Excel Variance Charts to show percentage change (Simple & uncommon technique)

    Better Excel Variance Charts to show percentage change (Simple & uncommon technique)

    5
    0
    23
  7. 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
    34
  8. Better Excel Presentations: Increase Font Size of Formula Bar

    Better Excel Presentations: Increase Font Size of Formula Bar

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

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

    3
    0
    12
  10. Excel IF Function with PARTIAL Text Match (IF with Wildcards)

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

    3
    0
    12
  11. Why you SHOULD be USING Custom Number Formatting in Excel

    Why you SHOULD be USING Custom Number Formatting in Excel

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

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

    3
    0
    25
  13. 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
  14. ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)

    ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)

    5
    0
    31
  15. Excel VBA IF THEN Statement (with ELSEIF & Looping in cells)

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

    3
    0
    32
  16. Excel Waterfall Charts: Business Examples of Waterfall Charts and When to Use Them in Your Reports

    Excel Waterfall Charts: Business Examples of Waterfall Charts and When to Use Them in Your Reports

    4
    0
    22
  17. Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

    Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

    3
    0
    40
  18. How to Conditionally Format Symbol colors in Excel Tables (without Conditional Formatting)

    How to Conditionally Format Symbol colors in Excel Tables (without Conditional Formatting)

    4
    0
    7
  19. How to Change the Number Format of a Cell Based on a Condition in Excel

    How to Change the Number Format of a Cell Based on a Condition in Excel

    3
    0
    22
    1
  20. Debits and Credits MADE EASY with ADEx LER

    Debits and Credits MADE EASY with ADEx LER

    4
    0
    54
  21. 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
    16