## 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 …

## How to insert multiple rows in Excel

So you’re chugging along, filling in your Excel spreadsheet. All of a sudden you realize that you missed a few valuable lines of your data. Now you either have to go back and erase a lot of data or insert a bunch of new rows. The choice is obvious: Here’s how to insert multiple rows …

## 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 …

## 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 …

## How to make a pie chart in Excel

One of the most exciting things you’ll do in Excel is converting heaps of dreary data into stunning graphs and charts. Pie charts are among the most popular graphs to make because you can show data as a percentage of a total. However, it can be tricky to learn how to make a pie chart …

## How to Divide in Excel: Everything You Need to Know

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 …

## 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 …

## 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. However, you’ll probably need to know how to separate first and last names in Excel. If you import all of your contacts from another source, you’ll likely end up with a first and …

## How to insert a checkbox in Excel

There are numerous ways to keep track of tasks in Excel. Maybe you put an X at the end of a row or something similar. However, if you have a sheet that you or others need to repeatedly check off, a checkbox is easier and more professional. Here’s how to insert a checkbox 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, …