Microsoft Office Excel Lesson

1
Microsoft Office Excel Lesson

• An introduction to the basic use of Excel
• By Samantha Simons

2
Introduction

• Excel is a software program that lets you use
  spreadsheets to depict different data
  relationships

3
Features

• Excel has many parts, from the picture on the
  next screen label the parts of the screen
  indicated.

Column Heading
Title Bar
Drawing Toolbar
Active Cell
Status Bar
Active Worksheet
Standard Toolbar
Close Window
Menu Bar
Close Program
Row Heading
Function Box
4
1
12
2
3
11
5
6
4
7
8
9
10
5
Answers

1. Title bar
2. Menu bar
3. Standard toolbar
4. Active cell
5. Function box
6. Column heading
7. Row heading

• 8. Active sheet
• 9. Drawing toolbar
• 10. Status bar
• 11. Close window
• 12. Close program

6
Inserting Data

• To insert data, click on desired cell and begin
  typing and hit Enter
• Insert the following data
• A1 your name
• A2 your grade
• A3 the date

7
Adding Basic Formulas

• To get a sum of a row of numbers
• sum(C1C9)
• Input the values in the table on the right

C1 25
C2 36
C3 87
C4 45
C5 35
C6 59
C7 49
C8 67
C9 83
8
Sheets with formulas
What yours will look like
Just showing the formula
9
Creating Charts and Graphs

• Basic charts show the relationship between two
  different criteria's
• To begin, insert data into Excel Spreadsheet
• Highlight the area of data and Click on Insert
  Chart
• From there follow the ChartWizard to complete the
  chart

10
(No Transcript)
11
Inserting New Worksheets

• On Menu Bar, Click Insert, Worksheet
• A new worksheet will appear

12
Renaming the Worksheet

• Double-Click on Worksheet Tab, will highlight
  text
• Type in Sales
• Press Enter
• The Tab name is now Sales

13
Summary

• Excel is a spreadsheet software that shows the
  relationship between data series
• Features include charts, graphs, calculating
  totals, adding new worksheets and renaming them
• In the next chapter, we will continue to learn
  more about Excel and its many features

14
Summary cont.

• The next objectives will be to format the cells,
  highlight important values/text, embed pictures,
  and more
• Any questions so far?

15
Assignment

• Open your textbook to page 25 and do the review
  questions at the bottom of the page
• When you are finished get a handout of the Excel
  screen and fill out the names of the icons