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.

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...

To make full use of the INDIRECT function, you would benefit from first knowing how to create named references in Excel. The ...

To use the function, you simply enter the function name at the sheet level, as you would any of Excel’s built-in functions. That’s all great, but there’s more.

If you’d like to learn about XLOOKUP(), read How to use the newish XLOOKUP() dynamic array function in Excel. I’m using Microsoft 365 on a Windows 10 64-bit system.

Note that the following content is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently. If you would like to follow along in using this function, you can download this ...

While using Microsoft Excel for data analysis, you may sometimes need to search for and retrieve specific values. In such cases, Excel's LOOKUP function can be extremely useful. It allows you to ...

I discovered artificial intelligence tool GPT Excel in my quest to cut down on all the busywork it takes to create and update spreadsheets.

Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic counterparts. It also has built-in functions ...

How to Use Excel's Functions to Solve Systems of Equations. Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of ...

You can even merge and unmerge cells in Excel. How to use functions and formulas. The real power behind Microsoft Excel is the ability to manipulate data that includes using functions and formulas.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel. By Kelly L. Williams, CPA, Ph.D. April 1, 2025. Related. July 1, 2025. 3 ways to use ChatGPT-4o with Excel.