Home » How To » Excel

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 important to be able to find duplicates. Like many features in Excel, you can get the job done multiple ways. Here are a few …

Read moreHow to find duplicates in Excel

How to sum a column in Excel

Excel is a productivity essential, with advanced functions like macros and PivotTables. But sometimes, you just need to add a whole stack of numbers in a hurry. If that’s the case, you need to know how to sum a column in Excel. Just like many popular Excel functions, there’s more than one way to reach …

Read moreHow to sum a column in Excel

How to create formulas in Excel

There’s very little that Microsoft Excel can’t do. At an advanced level, it can automate complex tasks and produce stunning graphs, but even a few beginner tips on creating formulas can have it working wonders for you. After entering numbers in cells, the most simple way you can save time using Excel is to create …

Read moreHow to create formulas in Excel

How to subtract in Microsoft Excel

One of the most common functions you’ll find yourself using in Excel is basic math. You’ll find that most operations have straightforward formulas that you can use to add, multiply, and more. However, there is no formula in Excel that allows you to subtract. Instead, here are a few alternative methods for how to subtract …

Read moreHow to subtract in Microsoft Excel

How to move columns in Microsoft Excel

In Excel, data is entered into cells and those cells are further organized into rows and columns. However, even the most well-planned spreadsheets need to be reorganized sometimes. Whether you’re organizing by data type or searching for trends, it’s important to know how to move columns in Excel. As with many Excel features, there’s more …

Read moreHow to move columns in Microsoft Excel