Using the Text to Columns Tool . One way to split data into multiple columns in Microsoft Excel is to use the built-in Text ...

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

This function is especially helpful when you're working with large datasets, where manually searching for values would be inefficient and time-consuming. The basic LOOKUP function in Excel comes ...

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.

Let’s use the UNIQUE function in one more example. This time the dataset we have been using has the first and last names in different columns. We would still like to identify unique customers from the ...

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

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.

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.

How to use the FILTER() function in Excel Using FILTER() has one requirement: You must use the same headers in the filtered set range. The original data set in B2:F14 is the source data.

This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.

How to Use the Multiple Rows Function in Excel. In addition to listing data, you can also use Excel to manipulate data. For example, you can compute sales, determine inventory or calculate nearly ...

How to use Excel’s AGGREGATE Function. 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. June 25, 2025 ...