Using statistic formulas to deliver key metrics.
Beginning with a simple set of test sales data, I employed some simple statistic Excel formulas to display metrics regarding the data.
In addition to using Conditional Formatting to show revenue values in both the high (green) and low (red) ranges, I also show for all the values the Average and Median sales figures, as well as the highest and lowest values.