Part VII – Learning the Essentials of Quattro Pro

Chapter 22 - Getting Started with Quattro Pro
Getting Comfortable with Quattro Pro
  Starting Quattro Pro
  Learning Parts of the Screen
Entering Information
   Entering Values and Labels
   Navigating Around the Notebook Window
   Editing Cell Entries
   Using Undo
Managing Notebook Sheets
   Naming a Sheet
   Navigating to Another Sheet
Saving and Naming a Notebook
Printing the Spreadsheet
   Setting the Print Area
   Adding Headers and Footers
   Adjusting Print Margins
   Setting Print Scaling
   Using Print Preview
Locating and Opening a Notebook
Getting Help
Exiting Quattro Pro

Chapter 23 - Learning Important Editing Skills
Selecting Cells, Rows and Columns
   Selecting Cells
   Selecting Rows and Columns
Moving and Copying Information
   Moving Cells, Rows and Columns
   Copying Cells, Rows and Columns
Using the QuickFill and Fill Series Features
   Entering Data Quickly with QuickFill
   Selecting a Fill Series
   Defining a Custom QuickFill Series
Adding Names to Cells
   Naming Cells
   Creating a Cell Name Table
   Redefining a Cell Name
Using the Writing Tools
   Finding and Replacing Information
   Spell Checking a Document
   Using QuickCorrect

Chapter 24 - Formatting Spreadsheets
Inserting, Clearing, and Deleting Cells, Rows and Columns
   Inserting Rows and Columns
   Clearing the Contents
   Deleting Cells, Rows and Columns
Adjusting Column Width and Row Height
   Adjusting Column Width
   Adjusting Row Height
   Assigning Precise Dimensions to Columns and Rows
Formatting Cells
   Assigning a Format to Values
   Aligning Entries in Cells
   Using Font Attributes in Cells
   Adding Borders Around Cells
   Adding Shading to Cells
   Protecting Cells
   Joining Cells
   Copying Cell Formatting
Simplifying Spreadsheet Navigation
   Inserting Page Breaks
   Locking Title Rows and Columns
   Hiding Columns and Rows
Using SpeedFormat
Creating Styles
   Defining a New Style
   Applying Styles to Cells
   Copying Settings Between Styles
   Changing the Default Settings in Quattro Pro

Chapter 25 - Working with Formulas and Functions
Creating Formulas
   Understanding Cell References
   Understanding the Order of Operations
   Entering Formulas
   Editing Formulas
   Copying Formulas
   Using QuickSum
Understanding Functions
   Using the Formula Composer
   Entering Spreadsheet Functions Manually
Troubleshooting Calculation Errors
   Looking for Errors in the Formula
   Tracing Errors in the Formula

Chapter 26 - Organizing and Using Data
Sorting Data
Filtering Data
Outlining Data
   Creating Manual Outlines
   Creating Automatic Outlines
   Creating Subtotals and Totals
Consolidating Data

Chapter 27 - Analyzing Data
Finding the Best Solutions
   Using Optimizer
   Using Solve For
Using What If Analysis
Using Cross Tabs
Using the Analysis Expert
   Refinancing a Mortgage
   Calculating Rank and Percentile

Chapter 28 - Graphing Data
Creating Charts
   Selecting the Data
   Editing the Chart Contents
   Adding or Deleting a Data Series
Formatting Charts
   Changing the Chart Type
   Enhancing a Data Series
   Changing Other Properties
Adding Objects to a Notebook Sheet
Printing Charts
   Using Optimizer
   Using Solve For
Using What If Analysis
Using Cross Tabs
Using the Analysis Expert
   Refinancing a Mortgage
   Calculating Rank and Percentile

Chapter 29 - Exploring Advanced Features
Publishing Spreadsheets on the Web
   Publishing to HTML
   Publishing to PDF
Advanced Formulas
Advanced Experts
Building Dialog Boxes
Creating Macros
Importing Data from the Web