How to find duplicates in Excel
Image used with permission by copyright holder When you’re working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to,…
The best Excel budget templates
Microsoft Excel is a full-featured spreadsheet application with plenty of features for managing data. With its robust functions and commonly used calculations, it’s also a solid money-management tool. If you…
How to lock cells in Excel
Shutterstock Locking cells in a Microsoft Excel spreadsheet is a super useful thing to know how to do. It’s used to protect a certain segment or an entire worksheet from…
How to alphabetize data in an Excel spreadsheet
Manually organizing data in Microsoft Excel is a real pain. That’s why we don’t recommend doing it. One simple task, learning how to alphabetize in Excel, is not necessarily as…
How to password-protect an Excel file on Windows and Mac
If you use a computer, you probably have some Microsoft Excel documents on your Mac or PC that you wouldn’t want other people to find and read. After all, Excel…
Apple’s Vision Pro to get bespoke Microsoft 365 apps at launch
Microsoft Apple’s Vision Pro is just a couple of days from landing on people’s heads, with many speculating as to how much of a success — or not — the…
Here’s how to quickly and easily convert a PDF to Excel
Just because your co-worker sent you a PDF file instead of the Excel document you wanted doesn’t mean you’re actually stuck with it. In this guide, we’ll teach you how…
How to create a drop-down list in Excel
Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here’s how to create a drop-down list in Microsoft Excel.
How to subtract in Excel
Subtraction methods in Excel aren’t the quickest or simplest, but if you need to get it done, we can certainly show you how to subtract in Excel. Here’s how.