Microsoft Office Tutorials and References
In Depth Information
Formatting Worksheet Data
The data for Joan’s sales report has already been stored in an Excel workbook. Before
going further, you will open the workbook and save it with a new filename.
For hands-on practice of
key tasks in this session,
go to the SAM 2003
Training Companion CD
included with this text.
To open the Sales report workbook:
1. Start Excel and then open the Sales1 workbook located in the Tutorial.03\Tutorial folder
included with your Data Files.
2. On the Documentation worksheet, enter your name in cell B3, and enter the current date
in cell B4.
3. Save the workbook as Sales2 in the Tutorial.03\Tutorial folder.
4. Click the Sales tab to display the unformatted worksheet, shown in Figure 3-1.
The unformatted Sales worksheet
The Sales worksheet contains two tables. The table in the upper portion of the work-
sheet displays the monthly sales figures for three of NewGeneration’s monitors: the
VX100, the VX300, and the FlatScreen. The other table presents an analysis of these sales
figures. Although the data in the worksheet is accurate and complete, the numbers are not
as easy to read as they could be, which also makes interpreting the data more difficult. To
help improve the readability of the data presented in a worksheet, you can change its
appearance by formatting it.
Formatting is the process of changing the appearance of your workbook. A properly for-
matted workbook can be easier to read, appear more professional, and help draw attention