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.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

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

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

The IMSUB function's purpose is to return the difference between two complex numbers. Learn how to use the Excel IMSUB formula.

Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of equations is the program's Solver Add-in.

Excel’s database functions are often overlooked, yet they have the potential to transform complex data management tasks.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

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

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.