VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

If you want to learn how to use Microsoft 365 Copilot in Excel, here's a detailed guide that will demonstrate to how to enable the feature and use it to your advantage.

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.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.

Excel offers several built-in conditional formatting rules you can apply to your data. (Click image to enlarge it.) We’ll demonstrate using Excel for Windows under a Microsoft 365 subscription.

In this guide, we'll show you the different ways to reduce the size of a Microsoft Excel spreadsheet to make it easier to share and store.

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

Lists is available with Microsoft 365 on Windows 10 and 11. We’ll get data from an Excel file, but Lists doesn’t limit you to Excel — you can upload data from other spreadsheet software.

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