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

When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells options. Update the format to help make ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...