Microsoft Excel tips, tricks, and ideas for accountants and CPAs.

Excel pro tips: How to create, define, and use Named Ranges Named ranges can speed up formulas, macros and more.

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 ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Think you know how to use Excel? Check our list of Microsoft Excel tips and tricks to learn more about this spreadsheet software.

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

While Microsoft Excel isn’t a dedicated project management tool, its versatility and widespread availability make it a surprisingly robust option for managing projects. Although I tried several ...

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

Excel's formidable talents stretch into word processing and even graphics. Here's how to create a calendar, customized just the way you want it.

If you don’t want to spend money on Word and Excel, there are options for getting these programs for free—options that are legal and above board, and offered by Microsoft.