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

The compound annual growth rate of a metric over time is equal to the average annual increase (or decrease) in that figure, compounded each year. It’s the “compound” here that is key. Essentially, ...

Excel wants to help you when writing formulas, so it’s always looking at what you type and interpreting it. But if you need to write a fraction or something with slashes or symbols so it’s readable ...