Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

AVERAGEIF and AVERAGEIFS aren't the only functions in Excel that calculate the average of a dataset. For example, the AVERAGE function produces a straightforward arithmetic mean of a set of data, and ...

Learn how to create interactive dashboards and dynamic workflows in Excel using modern functions like SUBTOTAL, AGGREGATE, and SWITCH.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Learn how to improve your Microsoft Excel data analysis using new features in the form of GROUPBY and PIVOTBY. Functions offering easier data ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Q. I receive regular spreadsheets with all of our company’s accounts, departments, employees, and balances, and I have to subtotal the amounts by accounts, departments, etc. I have been manually doing ...

SERIESSUM function returns the sum of a power series based on the formula. Learn how to use the SERIESSUM function in Excel.