Formatting Tables

Introduction Once you have entered information into a spreadsheet, you may want to format it. Formatting your spreadsheet can not only improve the look and feel of your spreadsheet, but it also can make it easier to use. In a previous lesson, we discussed many manual formatting options such as bold and italics. In this lesson, you'll learn how to format as a table to take advantage of the tools and predefined table styles available in Excel...

Read More

Filtering Data

Introduction Filters can be used to narrow down the data in your worksheet and hide parts of it from view. While it may sound a little like grouping, filtering is different because it allows you to qualify and display only the data that interests you. For example, you could filter a list of survey participants to view only those who are between the ages of 25 and 34. You could also filter an inventory of paint colors to view anything that ...

Read More

Outlining Data

Introduction If the amount of data in your worksheet becomes overwhelming, creating an outline can help. Not only does this allow you to organize your data into groups and then show or hide them from view, but it also allows you to summarize data for quick analysis using the Subtotal command (for example, subtotaling the cost of office supplies depending on the type of product). In this lesson, you will learn how to outline your worksheet...

Read More