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 multiply in Excel
Moose Photos/Pexels While it’s not as easy as tapping a few keys on a calculator, you can use Microsoft Excel to perform simple math, such as multiplying numbers. In order…
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…
‘Fallout but in Excel’ Lets You Visit the Wasteland While Your Boss Thinks You’re Working
Image: Bethesda/Excel If you thought that Excel spreadsheets were just for mind-numbing office work, think again. A gaming hobbyist has created an Excel-based RPG game that he based on the…
How to Use Microsoft Office on the Web for Free
As someone with a tech-related job, I’m regularly bombarded with questions about the best smartphones, why emails might have suddenly stopped showing up, and how to back up photos and…
How to use ChatGPT to write Excel formulas
Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you’re having trouble figuring…
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.