The VLOOKUP function is one of the most useful when pulling information from an Excel database. Here's how it works and how you can start using it in your work.

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

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.

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.

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel.

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT() function in Excel.

In Microsoft Excel, the IMPRODUCT function is an Engineering function; its purpose is to return the product of 1 to 255 complex numbers.

Learn how to harness the Microsoft Copilot AI assistant in Office apps such as Word, Excel and PowerPoint to help ease your workload on a ...

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