Modern Excel functions like IFS, SWITCH, XLOOKUP, SUMIFS, and LET replace most nested IF use cases.

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 hacks and tricks you need to know.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...

Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

Affiliate links for the products on this page are from partners that compensate us and terms apply to offers listed (see our advertiser disclosure with our list of partners for more details). However, ...

Tired of erasing holes in your graph paper or having to start over from scratch? Here’s an easy way to create your own custom graph paper in Excel. This past week, I started mapping out new flowerbeds ...