Introduction to Microsoft Excel 97

Download the tutorial in:  Word6 format    Acrobat Reader

Connect to Microsoft Web Page for Excel 97 Frequently Asked Questions

Table of Contents

• Screen Layout
  • Title Bar
  • Menu
  • Toolbars
  • Scroll Bar
  • Status Bar
• Function Keys
• Transition Navigation Keys
• Full Screen Edit
• Keys for Windows 95
• Format Data by Using Shortcut Keys
• Work in Cells or the Formula Bar by Using Shortcut Keys
• Enter Data by Using Shortcut Keys

Using Help

• Microsoft Excel Help (F1)
• Contents and Index
• What’s This?
• Microsoft on the Web
• Lotus 1-2-3 Help
• About MicroSoft Excel

Worksheet Basics

• Page Setup
•     Page
•     Margins
•     Headers/Footers
•     Sheet
• Creating a Worksheet
•     Entering and Editing Data
•     Entering Data
•     Active Cell
•     Corrections
•     Working with a Range of Cells
•     Move Backwards
•     Insertion Point Movement
• Moving Around in a Worksheet
  
• Selecting Cells
• Saving the Workbook
•     File, Save
•     File, Save As
•     File Names
• Printing a Worksheet
• Overview of Error Values
• Formatting the Cell
•     Format, Cell, Number
•     Format, Cell, Alignment
•     Format, Cell, Font
•     Format, Cell, Border
•     Format, Cell, Patterns
•     Format, Cell, Protection
•     Format, Row
•     Format, Column
•     Format, Sheet
•     Format, AutoFormatting
•     Format, Styles
• Deleting Text
•     Undo
•     Redo
• Replacing Text

Worksheet Formulas and Functions

• How Formulas Calculate Values
• Formula Syntax
• Formula Cell References
• Worksheet Function
• Frequently Used Formulas
• Calculation Operators in Formulas
• Arithmetic Operators
• Comparison Operators
• Text Operators
• Reference Operators
• Using Cell and Range References
• Using the Formula Palette
• Using Functions to Calculate Values
• Using the Formula Palette to Enter and Edit Formulas
• Types of Arguments

Workbook Functions listed by Category

• Database & List Management Functions
• Date and Time Functions
• Engineering Functions
• Financial Functions
• Information Functions
• Logical Functions
• Lookup and Reference Functions
• Math and Trigonometry Functions
• Statistical Functions
• Text Functions

Direct questions regarding this site to the University of North Texas Computing Center Helpdesk. We can be reached by e-mail at helpdesk@unt.edu , or by phone at 940.565.2324.   Hours:  Sunday 1pm-midnight, Monday-Thursday 8am-midnight, Friday 8am-8pm, Saturday 9am-5pm.

UNT Computing Center - UNT Box 305398 - Denton, TX 76203