Home » How To » Excel » Page 2

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

Read moreHow to make a pie chart 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 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. …

Read moreHow 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, …

Read moreHow to create a Macro in Excel

How to make a graph in Excel

Once you’ve wrapped your head around how to manage your data in Excel, you’ll probably want to use it to enhance your presentations. Graphs are a powerful way to flex your creativity while showing off your vital information. Here are a few tips on how to make a graph in Excel. The process of creating …

Read moreHow to make a graph in Excel