Formulas
Excel Formulas: Average a Range and Ignore Zero’s (0 Value)
How to use Excel 2003, 2007 and 2010 formula to calculate the average of a range excluding zeros from the average
EXPLORE THE LIBRARY
Tag: Formula
Chart
How-to Hide a Zero Pie Chart Slice or Stacked Column Chart Section
Hiding Excel Pie Chart Slice when equal to 0 also how to hide stacked bar chart section using NA()
Concatenate
How NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard Templates
Advice and Ways to build Concatenate formulas in your Excel Dashboard Templates.