Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

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.

Read our guide on how to use VLOOKUP in Excel, and you’ll find it much easier to find data within your biggest spreadsheets.

Use Excel in your rate card formulas to calculate discounts, dimensions and unit costs of your advertising rate document. Instead of manually calculating each of these components, use Excel ...

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

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.

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.

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.

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

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

You can search in Excel with the Search Sheet bar, and use Find and Replace to swap out terms or values. Here's how to do it.