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...
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
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
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...
Find the Last Row or Last Column for Dynamic Excel Dashboards
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)
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
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
Have you ever wondered which cells have actual values entered and which ones are calculated formulas in your Excel spreadsheet? Perhaps you are auditing...
This is the Bomb: or How I came to love the Offset function
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...