Course Outline
Quattro Pro - Basics
Versions 5.0/6.0/7.0/8.0

Phone:717-560-3552
Fax:717-569-1135
E-Mail: Registrar@pceasy.com

Program Objectives: Students will learn basic worksheet functions and formulas and how to work with data in spreadsheets.

• Introduction to Quattro Pro
  • Electronic Spreadsheet
  • Database
  • Charting Package
• Explanation of the Quattro Pro Screen
• Menu Bar
• Pull-Down Menu Conventions
• Menu Bar Commands
• Speed Bar
• Toolbar
• Input Line
• Status Line
• Mode Indicator
• Quattro Pro Mouse Shapes
• Moving the Cell Pointer
• Correcting Errors in Your Spreadsheet
• Undo Feature
• Text as Labels
• Numbers as Labels
• Numbers as Values
• Selecting Cells
• Ways to Enter Data
• Creating Formulas
• Circular Reference
• Additional Formulas
• Rules for Entering Formulas
• Saving Your Document
• Opening a File

• Opening a Lotus Spreadsheet
• Cloning a File
• Save Vs. Save As
• Starting a New Spreadsheet
• Switching Between Spreadsheets
• Closing a Spreadsheet
• Help Feature
• Changing Column Widths
• Centering Text Over Several Columns
• Formatting Options
  • Realigning Text Entries
  • Bolding Text
  • Italicizing Text
  • Changing Font and Point Size
  • Changing Other Type Styles
• Inserting/Deleting Columns or Rows
• Printing Your Worksheet
• Move Feature
• Drag and Drop Method
• Copy Feature
• Copying Formulas
• Cleaning the Contents of a Cell or Range
• Entering the Current Date in a Cell
• Exiting From Quattro Pro
• Exiting From Windows