Home » How To » Excel » Page 3

How to make a line graph in Excel

As you learn to use Excel, you’ll find that different graphs work well in different situations. Pie charts and bar graphs have their place, but sometimes a line graph is the best graph to get your point across. Line graphs are great if you want to show growth trends or track data across multiple time …

Read moreHow to make a line graph in Excel

How to split cells in Excel

Excel is great for data management, but files don’t always import just how you want them. You can end up with a ton of information in one cell when you wanted it nicely separated. This is where splitting cells comes in. The process is very easy to do and is similar to that of merging …

Read moreHow to split cells in Excel

How to set a print area in Excel

You’ve probably put in hours of time and effort to build your Excel spreadsheet, and now it’s time to print off a small section of it. The process isn’t as simple as printing a single page from Microsoft Word, but you’ve no reason to fret. You could print the entire sheet and highlight the important …

Read moreHow to set a print area in Excel

How to add cells in Excel

The most essential features in Excel are often the simplest ones. You’ll find that almost every project requires some degree of basic math. In this case, we’re talking about the wide world of adding cells. However, there are quite a few different ways to accomplish your goal. Here are a few tips on how to …

Read moreHow to add cells in Excel

How to protect cells in Excel

You’ve already put in the hard work to build your Excel spreadsheet and make your data shine. Now it’s time to share your work, but you have to make sure that your data is safe from accidental edits. Here’s how to protect your cells in Microsoft Excel. By default, all of your cells will be …

Read moreHow to protect cells in Excel

How to calculate age in Excel

Finding the exact difference between two dates in Excel may not be a popular use, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as hard as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. …

Read moreHow to calculate age in Excel

How to filter data in Excel

When you’re managing a mountain of Excel data, you don’t usually need it all at once. Sooner or later, you’ll have to find a way to simplify the information staring you in the face. Whether you want to narrow down categories or compare specific sales, you’ll need to learn how to filter in Excel. Filtering …

Read moreHow to filter data in Excel