Quattro Pro, Level 3

DescriptionThis course presents advanced function, database, and macro uses. Data sorting, finding, and extracting along with automation macros allow controlled access to information. Creation of custom macro menus will be introduced to aid users to create fully-functional models that minimize data loss and increase the ease of use for complex worksheets. A must for a well-rounded understanding of Quattro Pro.

Prerequisite: Quattro Pro, Level 2

Outline:

Review

Data Tables

• @VLOOKUP function
  
• Using the lookup
  
• How the @VLOOKUP works
  
• Multiple option lookups
  

  Database Sorting

• Data sorting
  
• Multiple key sorting
  

  Database Finding

• Finding a record
  
• Creating the input range
  
• Creating the criteria range
  
• Entering criteria
  
• Finding records
  
• Finding the next record
  

  Database Extracting

• Database extracting
  
• Preparing the ranges
  
• Creating the input range
  
• Creating the criteria range
  
• Creating the output range
  
• Specifying and extracting records
  
• Repeating an extraction
  

  Criteria Examples

• Greater than
  
• Logical and with greater than
  
• Logical and with logical or
  
• Logical and with not equal to
  
• Numerical greater than
  
• Numerical greater than with label
  
• Multiple wildcard
  
• Single wildcard
  

  Advanced Financial Functions

• @PMT, payment
  
• @PV, present value
  
• @FV, future value
  
• @NPV, net present value
  

  Macros

• Saving a file
  
• Writing a macro
  
• Naming a macro
  
• Playing a macro
  
• Macro notes
  
• Creating a menu
  
• Playing a menu
  
• Returning control to the menu
  
• Exiting the menu
  
• Additional menu options
  

Return to DGL homepage