Excel's PIVOTBY function and PivotTables both summarize and reorganize data, allowing for detailed analysis by grouping and aggregating your figures. However, despite their similar names, the ...

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

The Excel ISEVEN function aims to return True if the number is even. This tutorial will show you how to use the ISEVEN function in Excel.

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

Learn how to master Excel's MOD function for smarter data management, advanced analysis, and streamlined workflows in your spreadsheets.

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.

It’s not as complicated as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. Read on for tips on how to calculate age in Excel.

Q. How do I use the FILTER function in Excel, and how is this an improvement over the filter feature? A. The FILTER function was introduced five years ago as part of the Excel Dynamic Arrays rollout.