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 …
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 …
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 …
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 …
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 …
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: Everything You Need to Know
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 …
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 …
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. …
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, …