1. 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
  2. Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

    6
    0
    11
  3. Excel VBA FIND Function (& how to handle if value NOT found)

    Excel VBA FIND Function (& how to handle if value NOT found)

    3
    0
    12
  4. 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
    4
  5. Excel Tables: Use Smart Conditional Formatting for great table layout

    Excel Tables: Use Smart Conditional Formatting for great table layout

    4
    0
    7
  6. Microsoft MO-211 Certification Exam: Sample Questions and Answers

    Microsoft MO-211 Certification Exam: Sample Questions and Answers

    4
  7. Excel Charts: Sorted Bar Chart as Alternative to the Pie Chart

    Excel Charts: Sorted Bar Chart as Alternative to the Pie Chart

    4
    0
    7
  8. 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
  9. 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
    6
  10. Easiest Step Chart in Excel (this trick will surprise you!)

    Easiest Step Chart in Excel (this trick will surprise you!)

    3
    0
    8
  11. Quick Gantt Chart in Excel (Unusual technique)

    Quick Gantt Chart in Excel (Unusual technique)

    3
    0
    22
  12. 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
  13. Excel Slicer Trick - Use Symbols instead of Text in Pivot Slicers

    Excel Slicer Trick - Use Symbols instead of Text in Pivot Slicers

    3
    0
    8
  14. 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
  15. 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
  16. 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
  17. Excel: Extract unique items for dynamic data validation drop down list

    Excel: Extract unique items for dynamic data validation drop down list

    3
    0
    5
  18. Excel Picture Lookup: 5 easy steps for dynamic images

    Excel Picture Lookup: 5 easy steps for dynamic images

    3
    0
    3
  19. Excel Exteriors LC - (928) 365-8325

    Excel Exteriors LC - (928) 365-8325

    1
  20. Excel conditional formatting icon sets in under 5 minutes!

    Excel conditional formatting icon sets in under 5 minutes!

    4
  21. Excel Dependent Drop Down List with Tabular Data without Named Ranges

    Excel Dependent Drop Down List with Tabular Data without Named Ranges

    4
    0
    15