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.

There are dozens of reasons to make a spreadsheet like business presentations, school presentations, budgeting, habit-tracking, book-tracking and managing the kids’ chores. But how do you make your ...

Add Popular Science (opens in a new tab) More information Adding us as a Preferred Source in Google by using this link indicates that you would like to see more of our content in Google News results.

Excel is a never-ending learning curve.

Learning how to use tools like Excel and Google Sheets more effectively will quickly enhance your daily work. Alas, spreadsheets can be a pain in the ass. Grids of numbers, obscure menus, arcane ...

Learn how to add, configure and use checkboxes in Excel to create interactive task lists and trigger formatting without relying on macros. Recently, Microsoft has introduced the ability to add ...

What is a Custom Template? When you work with Excel, you often find yourself performing the same tasks repeatedly. This is where creating custom templates can be a catalyst. By learning how to create ...

Implementing a drop-down list in Excel is a quick and efficient way to choose predefined data. In the process, you’re able to save time compared to manually entering such data into a given spreadsheet ...

Microsoft 365’s UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula. Lists are a fundamental part in almost any Microsoft Excel ...