Here’s a neat trick that will allow you to see “at-a-glance” summary statistics for any range you highlight in Excel. With this you’ll be able to see a calculated average, count, minimum, maximum and sum for any range with numerical values.

Enable the summary statistics.

1. Right click on the status bar.
2. Select the items you would like to see.
3. Highlight a range of numbers and the summary statistics for that range will appear in the status bar.

Wow, the average salary for the Galactic Empire is $5,890,400, sign me up!