1. Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)

    Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)

    4
    0
    16
  2. Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells

    Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells

    4
    0
    23
  3. Change CASE of text in Excel (3 ways including NO Formulas)

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

    3
    0
    16
  4. Dynamic WordArt in Excel with Bar in Bar Chart (Info-chart that shows % completion)

    Dynamic WordArt in Excel with Bar in Bar Chart (Info-chart that shows % completion)

    3
    0
    4
  5. Lookup & Return Multiple Values in Single Cell in Excel (NO VBA | Easy Dynamic Array Formula)

    Lookup & Return Multiple Values in Single Cell in Excel (NO VBA | Easy Dynamic Array Formula)

    1
  6. Excel Simple Dependent Drop down List based on numbers (Index without match)

    Excel Simple Dependent Drop down List based on numbers (Index without match)

    4
    0
    12
  7. Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability

    Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability

    4
    0
    17
  8. The Top 10 Excel Inventory Management Hacks You Need To Know - WITHOUT VBA

    The Top 10 Excel Inventory Management Hacks You Need To Know - WITHOUT VBA

    42
  9. 3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

    3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa)

    3
    0
    126
  10. Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    3
    0
    25
  11. 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
  12. FREE FULL COURSE Learn MS Excel and Data Analysis

    FREE FULL COURSE Learn MS Excel and Data Analysis

    34
    7
    77
  13. Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

    Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

    4
    0
    9
  14. 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
    51
  15. (Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter

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

    4
    0
    45
  16. Excel 2021 In Practice - Ch 9 Independent Project 9-5 - Placer Hills Real Estate (Full answer 2025)

    Excel 2021 In Practice - Ch 9 Independent Project 9-5 - Placer Hills Real Estate (Full answer 2025)

    47
  17. 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
  18. Excel Formula Lookup Multiple Results: Return headers based on matrix values

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

    3
    0
    9
  19. Excel Conditional Bar Chart with Drop-down & Icons (This Chick's Trouble for Excel Hash)

    Excel Conditional Bar Chart with Drop-down & Icons (This Chick's Trouble for Excel Hash)

    4
    0
    19
  20. Exp19_Excel_Ch11_CapAssessment_Deans - Cap Assessment Deans - Microsoft Excel

    Exp19_Excel_Ch11_CapAssessment_Deans - Cap Assessment Deans - Microsoft Excel

    120
  21. TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin

    3
    0
    10