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...
Free Excel Dashboard Webinar

Test Your Excel Knowledge

Ever wondered how much knowledge you have of Excel? Well now is the time to find out . I have created a quick quiz that you...

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

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

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

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

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

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

A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link