As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ever imagined. These are the tips and tricks you need to know.

The CHOOSECOLS formula is a catalyst when it comes to selecting specific columns from a table. This formula allows you to streamline your data analysis process by quickly and easily extracting the ...

They can generate documents, spreadsheets, and presentations from simple text prompts. Here's how to make the most of it. In the era of AI chatbots, an increasingly wide variety of once time-consuming ...

I’m not a wizard with Word and Excel. Are you? Do we know what to do with all those many menus at the top? Now, thanks to AI, maybe we don’t need to. Microsoft has added AI to those software programs ...

Excel's built-in features cover most jobs, but these five free add-ins make everything from date entry to data analysis ...

On Monday, the company announced that its Copilot AI is now available as an Excel function for Microsoft 365 insiders. That means you can add COPILOT to a formula and then use natural language in a ...

While Microsoft Excel is one of the most powerful spreadsheet applications, it’s also the most intimidating tool in the Microsoft Office suite. If you’ve never used Excel before or are just a bit ...

What is a Custom Template? When you work with Excel, you often find yourself performing the same tasks repeatedly. This is where creating custom templates can be a catalyst. By learning how to create ...