Exploring Microsoft Excel 97 - PowerPoint

Document Sample
Exploring Microsoft Excel 97 - PowerPoint Powered By Docstoc
					                      Exploring
                      Microsoft
                      Excel 97
Chapter 1
Introduction to
Microsoft Excel: What
is a Spreadsheet?


     Office graphic copyright by Microsoft Corp.
            Objectives
              (1 of 2)

 Describe what a spreadsheet is
  and potential applications
 Distinguish between a formula
  and a constant
 Open, save, print a workbook;
  insert and delete rows and
  columns
 Distinguish between a pull-
  down menu, shortcut menu and
  toolbar


Exploring      Chapter 1           2
Excel 97
            Objectives
              (2 of 2)

 Describe the three-dimensional
  nature of a workbook;
  distinguish between a
  workbook and a worksheet
 Print worksheet with values or
  formulas
 Use Page Setup to print
  worksheet and preview before
  printing



Exploring      Chapter 1           3
Excel 97
            Overview

 Introduction to
  Spreadsheets and Excel
 Show wide diversity of
  spreadsheet applications
 Fundamentals of
  spreadsheets using Excel
 Worksheet recalculates
  automatically after changes

Exploring     Chapter 1     4
Excel 97
   Spreadsheet Basics

 Spreadsheet is a
  computerized ledger
 Divided into Rows and
  Columns
 Cell References
 Constants--entries that do
  not change
 Formulas--combination of
  constants and functions
Exploring   Chapter 1          5
Excel 97
            Excel Basics
 Common user interface of
  all Office 97 applications
 Worksheet is an Excel
  spreadsheet
 Workbook contains one or
  more worksheets
 Toolbars--Standard and
  Formatting
 File menu--Save, Open and
  Print commands
Exploring       Chapter 1    6
Excel 97
       Excel 97 Screen




Exploring    Chapter 1   7
Excel 97
       Excel 97 Screen




Exploring    Chapter 1   8
Excel 97
       Introduction to
       Microsoft Excel
Hands-On Exercise 1
 Welcome to Windows
 Obtain the Practice Files
 Start Microsoft Excel
 Open the Workbook
 The Active Cell, Formula Bar
  and Worksheet Tabs
 Experiment (What If?)
 The Office Assistant
 Print and Close the Workbook
Exploring      Chapter 1         9
Excel 97
            Modifying the
             Worksheet
 Insert and Delete
  Commands for both rows
  and columns
 Page Setup Commands--
  Portrait versus Landscape,
  Margins, Header/Footer,
  and Sheet Tabs



Exploring        Chapter 1     10
Excel 97
            Modifying a
            Worksheet
Hands-On Exercise 2
 Open the Workbook
 The Save As Command
 Delete a Row
 The Undo Command
 Insert a Row and Second Row
 Insert a Column
 Display the Cell Formulas
 The Page Setup Command
 The Print Preview Command

Exploring       Chapter 1       11
Excel 97
   Excel Features and
      Commands
 Active cell
 Formula bar
 Shortcut menu
 Status bar
 Toolbars
 ScreenTips
 Edit Delete versus Edit Clear
 Incompatible File Type from
  Excel 95
 Save as Command

Exploring     Chapter 1           12
Excel 97
  Chapter 1 Summary

 Spreadsheet is
  computerized accountant’s
  ledger
 Spreadsheet is generic term
 Cells contain formulas or
  constants
 Editing worksheets
 Print worksheets with
  values and formulas
Exploring   Chapter 1       13
Excel 97
   Practice with Excel

1. More with Grade books
2. Exotic Gardens
  Nurseries
3. Residential Colleges
4. Budget




Exploring   Chapter 1      14
Excel 97
            Case Studies

Buying a Computer
Portfolio Management
Accuracy Counts
Microsoft Online




Exploring       Chapter 1   15
Excel 97