Beginning

Intermediate

 Advanced

Module 1: Quattro Pro Basics. Navigate Quattro Pro, Explore the Menus, Select Multiple Cells, Create a Spreadsheet, Edit the Spreadsheet, Use Help

Module 2: Basic Formulas. Write a Formula, Use @ Functions, Use the Formula Composer, Copy Formulas, Create Absolute References

Module 3: Formatting and Printing. Check Spelling, Use SpeedFormat, Add Graphic Elements, Set Up a Printout, Create Headers and Footers, Scale the Print Area, Print the Spreadsheet

Module 4: Charts. Create a Chart, Explore Chart Types, Modify a Chart, Rotate a Chart, Create a Pie Chart, Create a Map

Module 5: Database Basics. Create a Database, Sort a Database, Perform Multiple Sorts, Locate Records, Delete Records

Module 6: Database Management. Extract Records, Extract Unique Records, Use Compound Criteria, Use Database Functions, Use the Data Modeling Desktop, Use the Database Desktop

Module 7: Link and Protect Notebooks. Formula-Link Worksheets, Command-Link Worksheets, Use Named Blocks, Link Notebook Files, Group Worksheets, Combine Files, Protect Cells, Assign a Password

Module 8: Macros. Record a Macro, Debug a Macro, Edit a Macro, Create a QuickButton

Module 9: Using IF Logic. Use Solve For, Determine Frequency Distribution, Use the Scenario Manager, Use the @IF Function, Nest @IF Functions, Combine Logical Functions

Module 10: Advanced Data Management. Use @HLOOKUP, Use @VLOOKUP, Create a One-Variable Table, Create a Two-Variable Table

Module 11: Advanced Macros. Write an Interactive Macro, Use the {IF} Command, Control Macro Flow, Control Data Entry

Module 12: Customizing Quattro Pro. Create a Custom Menu, Create a Custom Toolbar, Add Custom Buttons, Auto-Execute a Macro, Autoload a File, Create a Dialog Box