Putting descriptions for columns at the top of your spreadsheet is a great way to label your data and make it easier to understand. This is such a common practice that Excel actually gives a name to it, which is the “title row.” You can even choose to freeze that title row if you would […]

A pie chart can be a helpful visual aid for displaying values in relation to one another. You may be able to tell relatively how large a number is in comparison to other values in a spreadsheet, but the ability to see each piece of data as an individual “slide” of a pie can be […]

Excel is a great tool for performing mathematical operations on data that you have entered into your cells. These operations typically occur with the help of a formula, such as this subtraction formula. One of the operations that you can perform on your data is to calculate a percentage of one cell value compared to […]

If you want to subtract in Excel, there’s a formula that can help you do it. The same goes for other common mathematical operations, as well as some advanced calculations that let you do things like combine data from multiple cells. But sometimes you need to do something in Excel that doesn’t involve math or […]

Excel has a lot of tools that can help you calculate values based on data that you’ve entered. You’ve probably had to add up values in Excel before, or maybe even calculate an average, but there is even more that you can do with numerical values that you have entered into a spreadsheet. One other […]

Are some of the numbers in your spreadsheet currently formatted to display commas as a 1000 separator? This is an option in Excel, and it is one that you don’t need to use if you don’t want it. Our tutorial below will show you how to change the formatting option for cells that are formatted […]

Excel files are often referred to a spreadsheets, but they are actually files called workbooks, and they can contain multiple spreadsheets within them. These spreadsheets are called “worksheets” and can be navigated by clicking a tab at the bottom of the spreadsheet. You might already be familiar with worksheets, and have maybe even figured out […]

Numbering your rows in Excel is helpful when you need to reference a particular cell either to another person, or as part of a formula. So when the labels that typically identify your rows aren’t present, it can make your work a little more difficult. Or perhaps you need to include an additional column in […]

It’s very common for an Excel spreadsheet to be too large to fit on one page. Additional cells are then pushed to another page and, depending upon how your data is organized, you might need to manually shuffle the printed sheets so that they are in the order which is most helpful to the reader. […]

The ability to hide worksheets in an Excel workbook can be very helpful when you need to share a spreadsheet with someone else, but there is data on that sheet that shouldn’t be edited. Simply place that data on a separate worksheet tab, reference it with a formula, then hide the tab to make it […]