Working with Quattro Pro Experts
Quattro Pro Experts guide you step by step through many spreadsheet tasks. You can access Quattro Pro Experts from a toolbar or from a menu. The following Experts are available:
•
|
|
PerfectExpert — helps you quickly perform many common Quattro Pro tasks
|
•
|
|
Analysis Expert — helps you make many analysis calculations, such as advanced regression, correlation, covariance, exponential smoothing, F-test, moving average, sampling, T-test, and Z-test
|
•
|
|
Budget Expert — guides you in creating five different budget templates for both home and business use
|
•
|
|
Consolidate Expert — lets you combine cells using statistical operators (SUM, AVG, COUNT, MIN, MAX, STD, STDS, VAR, VARS), after which you can sort the combined data
|
•
|
|
External Data Expert — lets you easily import data from a database, such as a Paradox or dBASE database. It also supports Query By Example (QBE) and Open Database Connectivity (ODBC).
|
•
|
|
Map Expert — builds a map from selected cells of data
|
•
|
|
Scenario Expert — lets you create and display groups of scenarios (data conditions and results) based on models in your notebook
|
•
|
|
What-If Expert — lets you create tables that show the effect of changing one or two variable cells referenced in a formula
|
To access a Quattro Pro Expert from a toolbar |
1.
|
|
Right-click a toolbar, and click Experts and numeric tools.
|
2.
|
|
From the Experts and numeric tools toolbar, click the Expert you wish to use.
|
•
|
|
You can point to a toolbar button to see a description of a particular Expert.
|
To access a Quattro Pro Expert from a menu |
•
|
|
Follow the menu path in the table below to access a particular Expert.
|