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

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

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

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

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

    Why you SHOULD be USING Custom Number Formatting in Excel

    3
    0
    9
  4. Calculating Returns On a Rental Property (ROI with Excel Template)

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

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

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

    3
    0
    32
  6. 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
  7. 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
  8. 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
  9. VBA to BROWSE & COPY Data from SELECTED File in Excel

    VBA to BROWSE & COPY Data from SELECTED File in Excel

    4
    0
    21
    1
  10. Impressive Slide Design: Create Custom Shapes and Typography in PowerPoint

    Impressive Slide Design: Create Custom Shapes and Typography in PowerPoint

    4
    0
    70
  11. Excel Charts: Total Values for Stacked Charts in Excel

    Excel Charts: Total Values for Stacked Charts in Excel

    4
    0
    6
  12. (Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter

    (Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter

    4
    0
    45
  13. Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    6
    0
    14
  14. Mysterious Excel Formula Syntax to Count Text Cells (as NEVER Seen Before)

    Mysterious Excel Formula Syntax to Count Text Cells (as NEVER Seen Before)

    5
    0
    102
  15. 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
    70
  16. TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    3
    0
    9
  17. Excel Formula Lookup Multiple Results: Return headers based on matrix values

    Excel Formula Lookup Multiple Results: Return headers based on matrix values

    3
    0
    6
  18. Skip Dates in Excel Charts (Ignore gaps in Excel horizontal chart axis)

    Skip Dates in Excel Charts (Ignore gaps in Excel horizontal chart axis)

    3
    0
    8
  19. Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

    Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

    3
    0
    6
  20. Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)

    Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts)

    3
    0
    15
  21. 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
    22
  22. Excel Solver - Example and Step-By-Step Explanation

    Excel Solver - Example and Step-By-Step Explanation

    3
    0
    17
  23. How to add series lines / connectors to stacked column charts in Excel

    How to add series lines / connectors to stacked column charts in Excel

    3
    0
    14
  24. Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

    Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

    3
    0
    14
  25. Excel Filter Basics (for quick data analysis)

    Excel Filter Basics (for quick data analysis)

    3
    0
    18