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

0
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

0
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...
Left Vlookup Formula

Excel VLOOKUP–Left or Right and HLOOKUP Up or Down

0
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...