Quattro Pro X3

Beginning (6-8 hours)

  • Spreadsheet Basics
  • Windows Basics
  • Accessing Help
  • Perfect Experts
  • Entering, Editing & Deleting Data
  • Working with Blocks
  • Adjusting Column Widths
  • Adjusting Row Heights
  • Creating & Copying Formulas
  • Saving the Notebook
  • Using QuickCorrect
  • Spell Checking
  • Previewing and Printing
  • Opening and Closing Notebooks
  • Creating New Notebooks
  • Moving and Copying Blocks
  • Aligning & Formatting Blocks
  • Inserting & Deleting Rows/Columns
  • Using Built-In Functions
  • Borders & Fill Patterns
  • Using QuickFormat & SpeedFormat
  • Creating and Working with Charts
  • Absolute Cell Addressing
  • Using Quick Templates
  • Sending a File

Intermediate (6-8 hours)

  • Using Block Names
  • Displaying Locked Titles
  • Hiding Columns/Blocks
  • Creating a Database
  • Sorting Records
  • Querying, Extracting & Deleting Records
  • Creating, Customizing and Printing Charts
  • Combining Data from Multiple Files
  • Linking Files
  • Protecting Blocks/Pages
  • Using Find & Replace
  • Working with Multiple Pages
  • Grouping Notebook Pages
  • Working with Multiple Windows
  • Creating a Notebook Group
  • File Properties and File Management
  • Working with Projects
  • Working with Maps

Advanced (6-8 hours)

  • Date Arithmetic
  • The @IF Function
  • Using the Solver
  • The Scenario Manager
  • Creating Macros
  • Macro Libraries
  • Inserting Comments
  • Using Quickcells
  • Adding Hyperlinks
  • QuickButtons
  • OLE Objects
  • Working with Maps
  • Annotating the Notebook
  • Adding Textart
  • Consolidating Data
  • Importing/Exporting
  • Customizing Toolbars
  • Setting Sheet Properties
  • Setting Notebook Properties
  • Setting Program Preferences
  • Creating & Editing Styles

EZ-REF Home Page
Home Page

© 2004 EZ-REF Courseware.
 The copying of text, images, source code or other
information from this Web site without permission from
EZ-REF Courseware constitutes a copyright violation.