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...
Challenge Answer – Negative AverageIf for Non-Continuous Range
In our last Friday challenge:
Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous Ranges
I wanted to see how you...
Friday Challenge: What is your answer vs. Excel?
There is a Facebook post going around and I thought it would be a fun Friday Challenge edition.
What is your answer to this this...
How-to Show All Formulas in Excel Spreadsheet
Have you ever wondered which cells have actual values entered and which ones are calculated formulas in your Excel spreadsheet? Perhaps you are auditing...
The Tricks to Writing a Conditional Formatting Rule Formula
When you build your Excel Dashboard, you will frequently want to use Conditional Formatting to create color callouts and other table based dashboard components. ...
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...
How-to Make a Dynamic Chart Using Offset Formula
In previous posts I have described how to make a Dynamic Chart in Excel for your Dashboard using Tables. This is a very easy...
How-to Easily Paste a Defined Name in Chart Dialog Box
As you are learning to use Excel to develop your Executive Dashboard Templates, you will quickly learn that Defining Names are your friend.
Defined names...
Excel Formula Formatting Quick Tip
Excel Formula Formatting Quick Tip
Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use...
