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

From duplicating worksheets to selecting cells, these simple tricks made me realize I'd been doing things the hard way.

Let’s say you have an Excel workbook with one worksheet that holds data and another worksheet for an income statement. As you construct the income statement, you realize that it would be helpful to ...

Importing data into Excel from other sources can a real headache, especially if you’re copying and pasting from an Internet source. Data that’s exported from a mainframe; from another program such as ...