USING OUTLOOK

1
USING EXCEL
How to Format Worksheets
2
What is Excel?
Excel is a spreadsheet program that allows users
to organize data, complete calculation, graph
data and develop professional looking reports
3
Getting Started
Perhaps the best way to learn HOW TO is to go
through an example problem and actually DOING
certain processes. For this tutorial, we will set
up a sample worksheet and use several techniques
in formatting the sheet to be used in data input.
Before we get started, we need to go over a few
of the Basics of Excel worksheets.

• First open up the Excel program
• Double-click on the EXCEL icon on your desktop
  to open the program.

This is an example of the worksheet that will
open.
The next couple of slides will familiarize you
with some of the parts of an Excel worksheet.
4
BLANK worksheet
Excel allows data entry into cells that are
arranged and identified by column (vertical
line) and row (horizontal line). (see the
example below)
CELL F10
ROWS
FYI Excel opens a new workbook with three
worksheets adding additional worksheets will
be discussed later.
COLUMNS
Three worksheets
5
Excel Toolbars
Formatting Toolbar
Contain buttons and boxes that allow you to
perform tasks more quickly than when using the
menu bar. Each button has a picture on it to
help remember the function. (pg. EX13)
Standard Toolbar
Main Toolbar
With these basics under our belts, lets move
on to setting up a worksheet.
6
Opening a Workbook
There are 3 ways to start an EXCEL workbook

• LEFT click on File in the main toolbar menu and
  select NEW
• LEFT click on the New toolbutton in the Standard
  toolbar

• OR
• LEFT click on the Create a new workbook in the
  right-hand Getting Started menu and then LEFT
  click Blank workbook

7
FORMATTING in Excel is basically the same as that
used in Word PowerPoint. The individual cells,
rows or columns as well as groups of cells or the
entire worksheet can be formatted. You can
change Font Type, Font Size, Color, Bold, Italic
and format cells or groups of cells to handle
specific types of data currency, dates you can
even embed charts that show your information
HOW to Select areas to be formatted

• To select the entire worksheet

• Move cursor to the box in the top left corner of
  the worksheet
• LEFT click on the corner, that will highlight the
  entire worksheet
• Now you can format ALL the cells

8

• To select an entire column

• Move cursor to the header of the column that you
  want to format
• LEFT click on the column header, that will
  highlight the entire column
• Now you can format ALL the cells in that column

• To select an entire row

• Move cursor to the number of the row that you
  want to format
• LEFT click on the row number, that will highlight
  the entire row
• Now you can format ALL the cells in that row

• To select an individual cell

• Move cursor to the cell that you want to format
• LEFT click on the cell, that will place a heavy
  black border around the cell (highlighting) it.
• Now you can format the cell

9
To ENTER Text
For our purposes in this tutorial well use the
example of entering a title to your worksheet
(shown on page EX17 in your text)

• Since the title should go at the top of your
  worksheet, LEFT click on cell A1
• A1 is now the active cell and you can type in
  the title Extreme Blading

Notice that when you type in the title in cell
A1, that it also appears in the formula bar above
10

• The next thing would be to type in the subtitle
  Second Quarter Sales in cell A2, the Column
  headings Direct Mail, Outlets, Telesales and Web
  in cells B2,C2,D2E2 and the Row titles Inline
  Skates, Quad Skates, Custom Skates Accessories
  in cells A4-7
• And dont forget that youre probably going to
  need totals for the table as well.

Now youve got the basic setup for your
tablebut, it doesnt have any data (page EX21)
nor does it look too professional
11
Adding data doesnt seem to improve the looks of
the table so in the next few steps, lets see if
we cant fix it up a bit and make it more
professional.

• Center the Title, resize change the color of
  the font
• Select cells as shown
• On the Format toolbar, Left click Merge Center

Excel merges the cells into one large cell and
centers the text
12

• Center the Title. resize change the color of
  the font (contd)
• Change the size style of the font
• In the Format toolbar, change the font style to
  Arial Rounded MT Bold and
• Change the font size to 24
• Change the color of the font by LEFT clicking on
  Font Color and then selecting Light Blue

Using these same steps, center the text, change
the font size (16), the font style (Arial Rounded
MT Bold) and color (light blue) of the tables
subtitle Second Quarter Sales
13
At right you see what your table should look like
after the changes in the Title and Subtitle.
AutoFormat Body of Worksheet

• Highlight the body of the worksheet as shown

• LEFT click on Format and select AutoFormat

14

• For this example, we will use Accounting 2. So,
  LEFT click on Accounting 2 and then click OK.

The cells in the range A3F8 have now been
formatted to Accounting 2. Notice that all the
columns have automatically widened and the
currency symbols have been inserted into the data.
15
This tutorial has shown you just the basics of
dealing with Excel worksheets basic components
of an Excel worksheet, selecting cells, entering
text, centering changing font of text and
auto-formatting.
Please refer to other tutorials for information
on conditional formatting, using
arithmetic/functions and other topics.
16
Thanks for viewing this Tutorial. Any questions,
comments or complaints can be registered at the
next class meeting, via email or drop by my
office.
Email rstrube_at_mail.accd.edu
17
REFERENCES
Shelly, Cashman Vermaat. 2006. Microsoft Office
2003, Introductory Concepts Techniques. Thomson
Course Technology. Boston, MA.