-<screenbook>

<title realName="M1 Formatting">Formatting</title>

<category realName="Excel 2000">Excel 2000</category>

<subcategory realName="A Sample Project">A Sample Project</subcategory>

<format realName="Tutorial">Tutorial</format>

<version>draft</version>

-<locations>

<location> D:\Documents and Settings\Administrator\My Documents\SBooks\Excel 2000\A Sample Project\Tutorials\M1 Formatting\</location>

</locations>

-<pages>

-<page>

-<text>

-

This is the first in a series of tutorials that will cover Excel in depth.

This is also then first Screenbook in a five book set that walks through some of Excel's most interesting features.

It is customary to start out with the simplest functions and work up to more difficult ones, but let's try starting by walking through a project that shows just how powerful Excel can be.

</text>

<picture>[Empty]</picture>

<title>Starting with a sample project</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

Here we have Excel opened up to a sample spreadsheet.

-

You can download the spreadsheet

and follow along, if you like. Or, view the slides now, and try it yourself later.

</text>

<title>A sample spreadsheet.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

This worksheet is actually showing two tables of data, one of which is incomplete.

First, let's format the tables so that it is clear which data is in which table.

</text>

<picture>[Empty]</picture>

<title>This worksheet is showing two tables of data.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

Clicking on column G selects the entire column.

</text>

<title>Select column G.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Now,

right-click

on the selected area to show the pop-up menu for cells. (The grid with all of the data is called a

worksheet

. A

cell

is one of the squares in the grid.)

</text>

<title>The pop-up menu for cells.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Format Cells

is one of the options in the pop-up menu.

</text>

<title>Format Cells is an options in the pop-up menu.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Clicking on Format Cells opens the

Format Cells dialog.

</text>

<title>Clicking on Format Cells opens the Format Cells dialog.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Column F is the end of one table, and Column G is the start of the next, so let's put a thick line between the two. Click on the

Border

tab.

</text>

<title>Click on the Border tab.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

This displays the

Format Cells

dialog.

</text>

<title>The Format Cells dialog.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

We want to use a thick line when making the border, so first click on the thick line in the

Line Style

box. A dotted line will show around the thick line to indicate that it is selected.

</text>

<title>Choose a line thickness.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Now click on the left line in the

Border box.

This causes a thick black line to appear. This will be the left border on the selected area. (We selected all of column G, remember?)

</text>

<title>Select the target lines.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Now click

OK

to apply the formatting changes and return to the worksheet.

</text>

<title>Applying formatting changes.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

When we first return to the worksheet, the column is still selected, so we can't see the new border.

</text>

<title>The sheet after formatting.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

Click on any cell outside of the column to de-select the column. Then the border becomes visible.

</text>

<title>De-select the column.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

OK, things are starting to clear up a bit. We can see that we have a table of data in columns A - F, and some other information in columns G-I. Lets make the tables easier to see by formatting the column headers (the titles of the columns).

First, let's do the table in columns A-F. Select the column headers by first clicking on column A1 and then dragging the mouse over to column F1. The cells become highlighted to show that they are selected.

</text>

<title>Select the column headers in the second table.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

Now, right-click on the selected area. The pop-up menu shows, just as before.

</text>

<title>Right-click on the selected area.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Clicking on

Format Cells

shows the

Format Cells dialog.

We'll be changing the background color of the column headers, which we can do from the

Patterns

dialog.

</text>

<title>Clicking on Format Cells shows the Format Cells dialog.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Here is the

Pattern dialog

. We have just selected a new background color for the selected cells in the worksheet.

</text>

<title>The Pattern dialog.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Next, we'll be changing the font color via the

Font dialog

</text>

<title>Changing the font color via the Font dialog.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

This is the

Font dialog

. Clicking on the

Color

select item displays a menu of colors.

</text>

<title>The Font dialog.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

We are going to select the color white from the menu.

</text>

<title>Select white from the menu.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

Here the color white has been selected.

</text>

<title>The color white has been selected.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Next we'll be using the

Border

dialog.

</text>

<title>Click OK to apply the formatting.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

First, select a medium thickness border line.

</text>

<title>Select a medium thickness border line.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Next, we choose cyan for the border color. This changes the color of the lines in the

Line Style

menu.

</text>

<title>Choose the line color.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Next, clicking the two border buttons indicated changes the border color for all line in the

Border

box.

</text>

<title>Clicking the two border buttons.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

-

Click

OK

to apply the formatting and return to the worksheet.

</text>

<title>Click OK to apply the formatting.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

Now the column headers are nicely formatted.

There are two more separate tables on this sheet. Next, let's apply similar formatting to these two other tables.

</text>

<title>Now the column headers are nicely formatted.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

-<page>

-<text>

-

Here is the worksheet with the additional tables formatted.

Now that the data is more clearly visible, we're ready to start working with the data in the next tutorial.

</text>

<title>Here is the worksheet with the new formatting.</title>

<sauthor>[Empty]</sauthor>

<authoremail>orrj@jserv.com</authoremail>

</page>

</pages>

</screenbook>