# Exploring Microsoft Excel 97 - PowerPoint

Document Sample

```					                      Exploring
Microsoft
Excel 97
Chapter 1
Introduction to
Microsoft Excel: What

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-
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
 Show wide diversity of
 Fundamentals of
 Worksheet recalculates
automatically after changes

Exploring     Chapter 1     4
Excel 97

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
 Workbook contains one or
more worksheets
 Toolbars--Standard and
Formatting
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,
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
 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

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

2. Exotic Gardens
Nurseries
3. Residential Colleges
4. Budget

Exploring   Chapter 1      14
Excel 97
Case Studies

Portfolio Management
Accuracy Counts
Microsoft Online

Exploring       Chapter 1   15
Excel 97

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 11 posted: 2/10/2010 language: English pages: 15