Microsoft Excel

1
Microsoft Excel
2
Starting a Worksheet

• Click Start, Programs, Microsoft Excel

Click here
3
Identifying the Parts of a Worksheet

• Cell
• Row
• Column
• Range
• Menu Bar
• Tool Bar
• Formula Bar
• Status Bar

4
Menu Bar
Menu bar
5
Standard Toolbar Formatting Toolbar
Toolbar
6
Toolbar Options
7
Formula Bar
Formula bar
8
Tab Scroll / Scroll Bar
Scroll Bar
9
Cell
10
Row
11
Column
12
Range
13
Entering Text in Cells

• Click in Cell A1
• Type your full name (enter, tab or )
• Edit through Formula Bar
• Retyping
• Double click the right boundary of column heading
  A to change the width autofit the columns

Double click here
14
Formatting Text

• Click Format, Font (Just like Word)
• Alignment Cells or Columns (Left, Right,
  Center)
• Style
• Border
• Shading and Color

15
Creating Titles for Worksheets

• Enter title into cell A1
• Highlight area to contain title
• Click on merge and center button on the
  formatting toolbar

Merge and center
16
Correcting Mistakes While Typing

• Use delete and backspace keys
• Click into formula bar and then edit
• Autocorrect options
• Type over existing information

17
Autocorrect

• Setting up Autocorrect
• Create school name
• Use lower case
• (Choose one or your own)
• chs
• lhs
• mhs

18
Entering Numbers

• Type number into cell (enter 1 into cell C1)
• Enter 10.5 into cell C2
• Formatting numbers While in C2 click Format,
  Cells, Number, Decimal, (choose three places)
• Notice that numbers automatically align to the
  right
• Cells can be formatted like text for color and
  background

19
Formatting Currency and Dates

• In A2 enter today's date (ex. 2/18/03)
• While in A2 click on Format, Number, Date
  (choose the long form)
• Click on A3 then click on the currency button
  from the formatting toolbar
• Click on B3 and make it currency format

Currency button
20
Entering Formulas
fx

• Choose cell where you want answer to appear
• Enter an equal () sign
• Create a formula Example
• A3B3
• 500D4
• (D452)(.075/12)
• Click on x and choose the function formula
• ? or AutoSum

21
Creating a New Worksheet

• Click on the new sheet button
• Create title
• Type and format title (with the Merge Center
  key)

22
Enter Column Headings and Borders

• Enter the column headings
• Create Border
• Enter data into cells

23
Entering Formulas

• Enter formula for first student
• Highlight the Range F3F8
• Use Fill-Down to copy the formula for other
  students

24
More Formulas

• Click on drop down arrow for AutoSum
• Choose Average
• Do the same for
• All three tests
• Student average

25
Creating Charts

• Select the area you want used to create the
  chart
• Click on the Create Chart Wizard Button and
  follow directions to create the chart at the
  right

26
Using Templates

• You do not have to reinvent the wheel
• Use available templates whenever possible
• Make changes to the template to suit your
  individual needs
• Microsoft has many templates which are a simple
  click away

27
The Technology Committee of Logan County Schools
Thanks from all of us