fbpx

How to separate first and last name in Excel

You can use Excel for so much more than formulas and data management. It’s also an excellent way to manage your contacts. When you import all your contacts from another source, you’ll likely have a first and last name in a single cell. There’s nothing wrong with that,...

How to find duplicates in Excel

As you continue to grow your Excel skills, you’ll probably find yourself working with large amounts of data. Whether you’re using it as data points or searching for unique answers, it’s crucial to be able to find duplicates to ensure your calculations are correct....

How calculate age in Excel

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as hard as it sounds, and there’s a handy function in Excel that can give you an exact age to...

How to add cells in Excel

The most essential features in Excel are often the simplest ones. You’ll find that almost every project requires some degree of math. In this case, we’re talking about the essential skill of adding cells. However, there are quite a few different ways to accomplish...

How to unhide columns in Excel

Hiding and unhiding columns in your spreadsheet is a convenient way to show just the data that you need to focus on. Now and then, you may accidentally hide a column and wonder where it went. Here’s how to unhide columns in Excel. Read more: How to add, hide, or...