Home Products Skill Assessment Contact Us Become a Reseller Enterprise License


Quattro Pro 9 – Intermediate

Netscape 4.05 & earlier & Microsoft IE 4.5 for Macintosh Y2K Browser Bug

Call Us at 317-881-3826

Or

Click here:

Chat Live: Instant Message  


Lesson 1: Opening Quattro Pro 9, Creating A Database, Creating Database Fields, Entering Records Using Data Forms, Entering Records Manually, Sorting The Records, Multiple Sort Criteria, Navigating Records With The Data Form Dialog Box, Locating A Record Using Search Criteria, Changing A Record, Deleting Records Using The Data Forms Dialog Box, Saving A File, Using The Database Desktop, Opening A File Using The Database Desktop, Close Database Desktop


Lesson 2: Opening An Existing File, Setting Filters, Simple Filters, Top 10 Filters, Custom Filters, Creating A Criteria Table, Using AND Queries, Using OR Queries, Using AND/OR Queries, Extract Unique Records, Using Database Functions, Import Data, Creating A Cross-Tab Report, Editing The Cross Tab Reports


Lesson 3: Introduction, Working With Multi-Sheet Notebooks, Changing Column Width Using Sheet Properties, Naming Notebook Sheets, Copying From Sheet To Sheet, Setting Spreadsheet Tab Color, Setting Spreadsheet Borders, Setting Spreadsheet Gridlines, Setting Spreadsheet Zoom Factor, Copying From Notebook To Notebook, Creating Group Names, Editing Multiple Sheets Using Group, Creating Multi-Sheets Formulas, Creating Multi-Notebook Formulas, Inserting Another Notebook, Managing Links, Deleting Notebook Links


Lesson 4: Opening An Existing Document, Copying From Another Application, Paste Special, Inserting Date, Formatting The Date, Formatting The Time, Creating Absolute Cell Reference, Hiding Spreadsheet Data, Using Passwords, Using Low Level Password, Opening The Low Level Password File, Using High Level Password, Opening The High Level Password File, Protecting Cells, Unprotecting A Part Of Protected Spreadsheet, Using Conditional Color


Lesson 5: Introduction, Opening An Existing File, Preparing A Macro Area For Storing Macros, Record A Macro, Naming Macros, Playing A Macro, Copying A Macro, Debugging A Macro, Editing Macro Cells From The Debugger, Exiting From The Debugging Mode, Naming A Debugged Macro, Playing A Debugged Macro, Recording A Macro For Toggling QuickFilter, Creating QuickButtons, Labeling A QuickButton, Attaching Macro To A QuickButton, Running A Macro Through QuickButton, Deleting A Macro, Deleting All The Macros