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. ...
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...
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...
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 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...
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 NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard...
It may seem like a weird title, but I will explain.
As you build your Excel Dashboard, you will want to use text for data...
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...
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...
How-to Make Excel STOP Selecting Range/Extending Range
While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on...
