Data

Your boss wants the big-picture view, but her boss is a micromanager? Give each of them a personally tailored printout by taking advantage of Excel's Custom Views feature and Report Manager add-in. Here's how to find them (the latter was left out of Excel 2002, but you can fix that) and start setting up, saving, and summoning different perspectives on workbook data.

Charts in Excel allow you to quickly see patterns. However, sometimes it is hard to see the overall shape of the forest for the trees in your way.....

You have found a data table that would be good for your class to analyze, but the data goes on forever and it would take more than one class period to record and enter the data.

In this lesson, you are going to learn how to enter data into your worksheet. First, you place the cursor in the cell in which you would like to enter data...

When you select a chart, handles appear on the right and left sides, the top and bottom, and the corners of the chart....

We are going to go a bit deeper in the area of the different types of data that can be introduced in a spreadsheet cell.

To display the Auto Filter dropdown list (in all Excel versions)....

To quickly filter a List, add the AutoFilter and Show All icons to the Standard toolbar....

To save filtering criteria, use Custom Views....

See tip link for description.