Did you know Excel has a hidden average function? It’s called =TRIMMEAN. It chops off the top and bottom 10% of your data. Why? If you and Beyoncé are in a room, the average income is insane. Trimmean kicks out the Beyoncé outlier. Now you look normal. You’re welcome.
You can average dates. Yes, really. Excel sees dates as numbers. The average of July 4th and July 8th is July 6th. That’s how you find the middle of your vacation. It also works with times. The average of 8 AM and 12 PM is 10 AM. You just became a time wizard.
Fun fact: Excel’s statisticians are nerds. They added a function called =AVERAGEA. It counts text as zero. So if you have "Apple," "Banana," and 5, the average is 1.67. That’s meaningless. But now you know it exists. Show off at parties.
