Microsoft

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

How to sort in Excel

When you’re knees deep in your spreadsheet with column after column full of important data, it can get overwhelming. You have more information than you can shake a stick at but you can’t always find just what you need. This is exactly when you need to know how to sort in Excel. You may have …

Read moreHow to sort in Excel

How to add in Excel

Basic math is one of the most important things that you can do in Excel, and it’s usually quite straightforward. Adding is important because it is one of the ways you’ll start to work with some basic formulas. The SUM formula may not be the most advanced, but mastering it will help you wrap your …

Read moreHow to add in Excel

How to divide in Excel

Basic mathematical functions are a fundamental part of Excel. They’re key to data analysis, but dividing isn’t as simple as some of the other functions. You have to know how to work around the lack of a function, so here are some tips on how to divide in Excel. We’ll walk through a few of …

Read moreHow to divide in Excel

How to find the mean in Excel

When you work with large Excel spreadsheets, you’re bound to need the average of a data set sooner or later. You can add up all of the cells and divide them by the total number, but that’s usually slow and tedious. If you really want to save time, you have to know how to find …

Read moreHow to find the mean in Excel

How to create a Macro in Excel

Once you have a pretty good grasp of Excel basics, such as formulas and graphs, you’re ready to try automation. Called Macros, these functions save time by automating repetitive tasks. Here are a few tips on how to create a Macro in Excel. This is one of the most advanced tasks we’ve covered so far, …

Read moreHow to create a Macro in Excel