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.

I added new rows to my monthly sales data and clicked "Refresh" in the PivotTable. Yet, the added month doesn't appear in the ...

In the laboratory, Professor Tanaka was groaning while looking at his computer screen.“Hmm... I do this every month, but it ...