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

Imagine you’re tasked with analyzing two datasets—one containing a list of products and another with customer segments. How do you uncover every possible pairing to identify untapped opportunities?

If you want to show or hide the list of formulas while typing in an Excel spreadsheet, here is how you can do that. You can enable or disable the autocomplete of ...

Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For ...