You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

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.

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

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Most people overlook the row of function keys at the top of their keyboard. They often ignore, misunderstand, or underuse them. If you work with Excel spreadsheets regularly, those F-keys can be ...