The GEOMEAN and HARMEAN are advanced statistical functions that typically require a deeper understanding of mathematics. This is probably why they aren't taught as often as the AVERAGE function.
In an excerpt from his new book, bestselling author Mark Murphy explains five different roles on teams and how they work.
One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...