Learn how to use XLOOKUP in Excel to return multiple columns easily, faster, and more efficiently than traditional VLOOKUP.

All details in this article are correct as of October 29, 2025. Accessibility to some of the latest Excel features depends on ...

Have you ever tried to drag the header columns in an Excel spreadsheet to make them fit the text? I have and just when I think I’ve got it right, a quick glimpse down the line of columns usually ...

Apple's Numbers spreadsheet for Mac, iPhone, and iPad, is not as powerful as Microsoft Excel, but most users will be hard-pressed to find its limitations — and will immediately see how much easier ...

Do you struggle with subtractions in Excel and end up doing calculations by hand or with your phone’s calculator? Good news: with a couple of basic formulas you can automate everything and gain ...

Have you ever found yourself staring at a massive Excel spreadsheet, wondering how to pull the right information from multiple columns without losing your mind? If so, you’re not alone. Whether you’re ...

Excel 365 offers a powerful feature known as calculated columns, which significantly improves your data analysis capabilities. This tool allows you to create dynamic calculations that automatically ...

For many small business owners, Microsoft Excel is not only a powerful tool for internal tracking and bookkeeping, but it can also be used to prepare documents for distribution to partners or ...

The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to interpret the parts of complex formulas. Microsoft ...

Using Microsoft Excel to subtract numbers may take a few more steps than you're used to, but it can be done. In this guide, we'll show you four different ways to subtract in Excel: Within a cell, ...