MS EXCEL 2003

1
Introduction to
MS EXCEL 2003
2
Chart Wizard Allows you to chart a table of
comparison quickly.
3
(No Transcript)
4
Now Lets GRAPH this information Click INSERT on
the Tool Bar. Select MARKET FORECAST.
5
Click on Chart Type COLUMN and then Click NEXT
6
For the DATA RANGE Highlight the area to be
included in the chart. Click NEXT
7
Enter CATEGORY (X) AXIS Year. Enter VALUE (Y)
AXIS Kids Per Year. Click NEXT
8
Determine where you want the chart
placed. Click FINISH.
9
(No Transcript)
10
To Rename a Worksheet. Double Click the tab you
want to rename. Type your chosen name for the
tab. Hit Enter.
11
Using the Fill Option. Click on the Cell where
you want the data filled. Click Edit. Click Fill
and Determine which option fits your situation.
12
Using the Fill Option.
13
Creating a Header or Footer. Click on the Print
Preview Icon.
14
Creating a Header or Footer. Click on the Setup
button. Click on Header/Footer tab.
15
Creating a Header or Footer. Click on Custom
Header or Footer. Determine the location of your
section and begin typing. Click OK and then OK
again.
Edit font, page numbering, date, time, etc.
Determine the location you prefer your
header/footer.
16
Creating a Header or Footer. You should now see
your header or footer.
17
Print Preview Printing. Click on the print
preview tab. Click Print to print your document.
18
Page Setup Page Breaks. Click on file in the
Menu toolbar. Click Page Setup.
To determine the page orientation, scaling, paper
size, print quality, etc.
19
To adjust margins, create or edit a
header/footer, set print area.
20
Page Breaks. Click on the Cell where you want to
locate the page break. Click on Insert in the
Menu toolbar. Click Page Break.
21
Freeze Panes. Click on the Row where you want to
freeze the panes. Click on Window in the Menu
toolbar. Click Freeze Panes.
This feature allows you to scroll down several
pages and still be able to see the column headers.
To unfreeze the panes repeat the same steps.
22
Questions ?