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

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

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

How-to Make a Dynamic Hotel Ballroom Occupancy Chart

0
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

1
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

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...
This how Not to use Concatenate Template Formulas in Excel for Dashboards

How NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard...

0
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

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

How-to AverageIf Excluding Zeros and Blanks for Non-Contiguous Ranges in Excel

11
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

6
While building your Excel Dashboard Templates, have you had the frustrating problem where Excel keeps highlighting a range of cells as you click on...
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