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 blanks and zeros. This came from a user questio
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 that was sent in by a reader from another
See how to create a hotel occupancy chart using advanced date functions, countif formulas and conditional formatting. Also included is finding out how many days are in any month and if any d
Learn how to have gaps in a line chart when using the NA function in an Excel Formula
Learn how to create a dynamic Excel chart where you can hide outliers in a Line chart or Line graph. Free Excel Template download file
how to make an excel chart that ignores outliers when plotted in a line chart. Do this without manually deleting the data points.
See how to use a combination of the Excel Find Function, MID Function and Value to get a text ranking from text.
Excel dashboard protection tip and trick using array formulas
detailed how-to create a dynamic excel graph and chart using excel offset functions and formulas
The best tips and tricks about wrting excel conditional formattting rules and formulas for spreadsheet dashboards.