Microsoft Excel’s new import functions make handling numbers easier
If you often work with data that starts life as a text file or CSV, Microsoft Excel now has new built-in tools that simplify how that information gets pulled into…
How to use concatenate in Excel
Getty Images The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a…
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.