Quantcast
Home Tags Excel Formula

Tag: Excel Formula

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

Excel Formulas: Average a Range and Ignore Zero’s (0 Value)

6
Excel formulas are a wonderful thing, but they may not provide all the flexibility you want when calculating information for your Executive Dashboard display. ...

How-to Show All Formulas in Excel Spreadsheet

0
Have you ever wondered which cells have actual values entered and which ones are calculated formulas in your Excel spreadsheet?  Perhaps you are auditing...

How-to Show All Named Ranges/Formulas in a List

2
In our previous posts we discussed how to build your dynamic Excel dashboard template charts by using an Offset formula and named ranges/formulas.  Then...
Sample File of Excel Template Dashboard Tutorial Offset Function

This is the Bomb: or How I came to love the Offset function

7
Wouldn’t that be awesome if Excel can just change my chart every month or week when I add more data? This can happen for...

QUICKLY Change Microsoft Excel Dashboard Template Cell References

1
Learn Excel Quickly: Okay, when you are making your Excel Dashboard Templates you will spend a lot of time settin up formulas and copying them...
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