Quantcast
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...
How-to Hide Pie Slices when Value Equals Zero

How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section

5
Okay, we have learned lots of different techniques to build our Company Executive Dashboard using Excel, and today I will give you a taste...

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

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

Find the Last Row or Last Column for Dynamic Excel Dashboards

0
In a previous post “This is the Bomb: or How I came to love the Offset function” I showed you all about the Offset...

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

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

Case Study – Creating a Dynamic Chart in Excel Using Offset Formula

2
A YouTube video subscriber Mili, wanted to know more about creating a Dynamic Excel Column Chart using Offset function.  So Mili sent me the...

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