Tag: Average
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...
Friday Challenge – Analyzing Attendance Records with Six Sigma Charts
The following is a guest post from Pete on his answer to the most recent Friday Challenge.
Pete applied his knowledge of Six Sigma to...
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. ...
