Home Formulas

# Formulas

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

### Friday Challenge – AverageIf NOT Blank or NOT Zero – NOT So Easy

As an Excel dashboard engineer you will often need to create complex calculations for your charts, tables and displays. So today's challenge is one...

### How-to Make a Dynamic Hotel Ballroom Occupancy Chart

In a previous Friday’s challenge, I presented the following user request. Here was the question again and what you would have seen in the download...

### How-to Show Gaps in a Line Chart When Using the Excel NA() Function

4
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart.  In essence, he wanted to...

### How-to Eliminate Statistical Outliers in an Excel Line Chart

4
Okay, I posted this Excel Chart Challenge on Friday.  How did you do?  I am sure your solution is better than mine.  This was...

### Friday Challenge – Eliminating outliers in and Excel Chart

4
Okay, apologies again .  I have been so swamped with my Go-Live project this week that I have been too tired to finish the...

### Getting to Know Excel Text Fuctions and Functions

0
Frequently I have to take other data sets and make sense of them.  Sometimes there is very little sense of the data, but every...

### Removing Array Formulas Around Your Excel Charts and Dashboards

0
Yesterday I posted a quick tutorial on protecting your Excel Dashboard Charts by using Array Formulas. You can check out that posting here: Protecting Your Excel...

### Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

2
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...

### The Tricks to Writing a Conditional Formatting Rule Formula

0
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
Want to Receive the Next Post?