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 ...

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.

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.

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

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

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 ...

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.

How to use the Excel Columns function. Type into any of the cells =COLUMNS(D1:E8). Then press Enter. The result is 2 because it is the number of columns in the reference.

Excel Forecasting and Trend Functions. To use the TREND function, you start by selecting the range of known data points. This function fits a straight line (using the least squares method) ...

How to use COUNTA() to count the items in the unique list in Excel We have the list, so all we need to do is count the number of items in that list using COUNTA() as follows: J3: =COUNTA(H3#) ...

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 ...