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.

I use these functions to summarize data with formulas instead of dialog boxes. That makes it easier to see exactly what's ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

It's that time of the month again: when Microsoft recaps everything new that it introduced in Excel during the past four weeks. This roundup is useful because it allows us to see the improvements ...