Microsoft Excel Spreadsheet

1
Microsoft Excel Spreadsheet
Blue Section
2
What is Microsoft Excel?

• Powerful spreadsheet program
• Four major parts
• Worksheets
• Charts
• Databases
• Web Support

3
Moving Within Excel
4
The Excel Worksheet

• The Worksheet
• Row
• Column
• Cell
• Toolbars
• If the toolbar is not displayed, click View,
  Toolbars

5
(No Transcript)
6
Worksheet Window

• Menu Bar
• Standard Toolbar and Formatting Toolbar
• Formula Bar
• Status Bar

7
(No Transcript)
8
Selecting a Cell

• Use mouse to move the block plus pointer to the
  cell and then click
• Use arrow keys to select cells
• A cell is active when a heavy border surrounds
  the cell

9
(No Transcript)
10
Entering Text

• Entering the Worksheet Titles
• Select the cell to type the title in
• Begin typing
• Your title will look like it is outside its cell
  boundary

11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
(No Transcript)
15
Entering Text

• Correcting a Mistake While Typing
• If before clicking the Enter box, use BACKSPACE
  key
• Or cancel the entire entry by clicking on the
  Cancel box or press the ESC key.

16
Entering Text

• AutoCorrect
• Corrects two initial capital letters by changing
  the second letter to lowercase
• Capitalizes the first letter in the names of days
• Replaces commonly misspelled words with their
  correct spelling

17
Entering Text and Numbers

• Entering Column Titles
• Entering Row Titles
• (ex)

18
(No Transcript)
19
(No Transcript)
20
(No Transcript)
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
(No Transcript)
27
Calculating a Sum

• Select Cell
• Auto Sum

28
(No Transcript)
29
(No Transcript)
30
(No Transcript)
31
Using the Fill Handle to Copy a Cell to Adjacent
Cells

• Determining Row Totals
• Enter first formula
• Use Fill Handle to copy
• (ex)

32
(No Transcript)
33
(No Transcript)
34
(No Transcript)
35
(No Transcript)
36
(No Transcript)
37

38
Any Questions?

• What Microsoft Excel Is.
• What makes up an excel spreadsheet
• Adding Text and Numbers in a Worksheet
• Doing Calculations

39
Formatting the Worksheet

• Bolding a Cell (Ctrl B)
• Increasing the Font Size
• Changing the Font Color of a Cell
• Centering the Worksheet Title across Columns
• Formatting the Worksheet Subtitle

40
(No Transcript)
41
(No Transcript)
42
(No Transcript)
43
(No Transcript)
44
(No Transcript)
45
(No Transcript)
46
(No Transcript)
47
(No Transcript)
48
(No Transcript)
49
Formatting the Worksheet

• Use AutoFormat to Format the Body of a Worksheet
• They are built-in templates included with your
  copy of Excel
• They allow you to make your spreadsheets more
  professional
• Format AutoFormat

50
(No Transcript)
51
(No Transcript)
52
(No Transcript)
53
(No Transcript)
54
Using the Name Box to Select a Cell

• The Name box is a tool allowing the user to
  navigate within Excel
• The Name box is very useful for navigating within
  large spreadsheets
• The moves are based on the column-row coordinate
  system
• Ex( B4 from C7)
• The Name box is located to the far left, of the
  formula toolbar

55
(No Transcript)
56
(No Transcript)
57
Adding a Chart to the Worksheet

• Use the Chart Wizard
• It is a 4 step program for creating a chart
• It can be found on the standard toolbar, or go to
  Insert Chart
• Embedded Chart chart included in a worksheet

58
Adding a Chart to the Worksheet

• 4 Step Chart Wizard
• Chart Type
• Chart Source Data
• Chart Options
• Chart Location

59
(No Transcript)
60
(No Transcript)
61
(No Transcript)
62
(No Transcript)
63
(No Transcript)
64
(No Transcript)
65
Adding a Chart to the Worksheet

• Formatting the information in a Chart
• All axis values can be edited, as well as the
  title, legends, background, etc.

66
Saving a Workbook

• Save As vs Save
• Save As First time save of information, no prior
  saves, or data
• Save shortcut for updating your previously saved
  data
• Toolbar button
• The save button looks like a floppy disk.
• This shortcut can even be used for first saves of
  data

67
(No Transcript)
68
(No Transcript)
69
(No Transcript)
70
(No Transcript)
71
(No Transcript)
72
Printing a Worksheet

• Toolbar Button preset specifications created by
  Microsoft to print your document their way
  (Portrait, 8.5X11)
• File Print Allows the user to select the
  layout, position, margins, etc. of your document
  before it is printed

73
(No Transcript)
74
(No Transcript)
75
Quitting Excel

• File Exit
• Close Button

76
(No Transcript)
77
(No Transcript)
78
Starting Excel and Opening a Workbook

• Method 1
• Start on the desktop, Open Office Document
• Method 2
• Start, Programs, Microsoft Excel
• File Open or Open button on standard toolbar

79
(No Transcript)
80
(No Transcript)
81
(No Transcript)
82
Any Questions

• Formatting a Worksheet
• Printing and Quitting Excel Spreadsheets
• Saving spreadsheets
• Inserting Charts
• Opening an Existing Worksheet/Workbook

83
(No Transcript)