As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...

Old-school Excel functions like SUMPRODUCT, INDEX/MATCH, and IFERROR remain essential for stable, readable, and maintainable ...

Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.

Will Kenton is an expert on the economy and investing laws and regulations. He previously held senior editorial roles at Investopedia and Kapitall Wire and holds a MA in Economics from The New School ...