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.

It has been about five years now, I suppose. About once a month, I gather with friends at a friend's house to play mahjong with four people.To make it feel like a league, we have been managing mahjong ...

Hello there.Last time, I wrote about how it is also important to consider "what to use" when creating documents. This time, I ...

The old Excel Easter-egg era may be gone, but this open-source project brings the arcade spirit back to our spreadsheets.

Learn to calculate loan payments and design effective repayment schedules using Excel formulas for mortgages and other loan types.

Tony Phillips is an experienced Microsoft Office user with a dual-honors degree in Linguistics and Hispanic Studies. Prior to starting with How-to Geek in January 2024, he worked as a document ...

Being behind major reports like The Mother of All Breaches and RockYou2024, our in-house cybersecurity experts and journalists provide unbiased, real-world testing and in-depth analysis. We maintain ...

Q. I read the JofA article last month about performing horizontal, vertical, and trend analyses in Excel. How can Excel be used to organize these analyses and highlight possible red flags in a company ...

Dynamic arrays have brought significant flexibility to Excel, allowing formulas to automatically expand or contract across cells. However, this functionality introduces a common issue: formatting ...

Q. I often perform horizontal, vertical, and trend analysis for clients. Each time revised financial statements arrive, I find myself recreating formulas, rechecking ranges, and confirming that ...