How-to AverageIf Excluding Zeros and Blanks for Non-Contiguous Ranges in Excel
In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude...
Understanding How-to Make a Step Chart in Excel Using Index and Match Functions
Here is a quick demonstration on the technique that Peter used for his Step Charts:
Learn More about the Challenge HERE
To try it yourself as...
Better Formulas for Pipeline Matching Stacked Bar Chart Colors to Products without VBA Solution
Hands off to Leonid :) for this awesome solution with much Much BETTER formulas for a recent Friday Challenge.
Here was the original Challenge:
friday-challenge-pipeline-usage-chart
Here was...
Customizing the Standard Excel Chart Titles
Titles on charts are not always necessary but when you use them, you will have many, many choices on formatting of which you may...
VLookup Week at ExcelDashboardTemplates.com
The Awesome Mr. Excel has started a VLOOKUP week. Much like Shark Week, all the Excel sites around the web are posting VLOOKUP learning...
How-to Make a Music Festival Schedule Using Excel Conditional Formatting
Recently, I saw an Excel User posting a question about how to make this Music Festival Schedule using Excel Charts.
However, he originally created the...
Excel VLOOKUP–Left or Right and HLOOKUP Up or Down
Better late than never to the VLOOKUP week as started by Mr. Excel, Bill Jelen.
I have never been a big fan of the Excel...
