Make Excel evaluate your data for you.

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

Recently, I have been doing quite a bit of work involving the use of functions inside Excel spreadsheets. Although functions are probably most often used for computational purposes, functions can also ...

In the world of corporate finance, spreadsheets are core. Whether it’s managing a profit and loss statement or developing financial and headcount plans, spreadsheets are a daily part of a corporate ...

The INDIRECT function has a rep for being a "nightmare," but for building reactive dashboards, it’s irreplaceable. Here is ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...

Spreadsheets are a nerd’s data-driven dream. For most regular people, though, they’re a complicated mess. Fortunately, they don’t need to be. Here’s how to bend data to your will with Microsoft Excel ...

Google has announced that Google Sheets is getting the ability to intelligently suggest formulas and functions for your spreadsheet, based on the data you’re trying to analyze. For example, typing “=” ...