A Word About the Quattro Pro Experts

Quattro Pro contains eight wizards that guide you through performing certain tasks, and Quattro Pro refers to these wizards as experts. Table 5.1 describes what each expert can help you do. You can work with any of these experts by choosing the appropriate command using the menu commands listed in the table.

Table 5.1. Quattro Pro Experts

Expert	Function	Menu Commands
PerfectExpert	Use this expert to quickly perform many common Quattro Pro tasks.	Open the Help menu and click PerfectExpert.
Analysis Expert	You can use the Analysis Expert to make analysis calculations that include moving average, advanced regression, and correlation.	Open the Tools menu, point to Numeric tools, and click Analysis tools.
Budget Expert	You can use the Budget Expert to create five different budget templates.	Open the Tools menu, point to Numeric tools, and click Budget.
Chart Expert	Use this expert to create a chart from spreadsheet data.	Open the Insert menu and click Chart.
Consolidate Expert	Use the Consolidate Expert to combine cells using statistical operators like SUM or AVG and then sort the combined data.	Open the Tools menu, point to Consolidate, and click New.
Map Expert	Use the Map Expert to produce a map from spreadsheet data.	Open the Insert menu, point to Graphics, and click Map.
Scenario Expert	Use the Scenario Expert to model spreadsheet data and display the resulting scenarios.	Open the Tools menu, point to Scenario, and click New.
What-If Expert	Use the What-If Expert to create tables and then change one or two cells and show the effects of the changes.	Open the Tools menu, point to Numeric Tools, and click What-If Tables.

Tip

Most of the experts are on the Experts and Numeric Tools toolbar for easy access. To view this toolbar, open the View menu and click Toolbars. In the Options dialog box that appears, click Experts and Numeric Tools.

The Absolute Minimum

Now that you've read this chapter along with Chapters 3 and 4, you've learned the most commonly used editing techniques that you'll need in Quattro Pro.

• In this chapter, you learned how to automatically fill a range with numbers using the Fill Series dialog box.

• Using the Cell Names dialog box, you learned how to assign names to ranges so that you can refer to a range using its name instead of cell addresses.

• Using the Find and Replace feature, you learned how to quickly change all occurrences of information you specify.

• You learned how to use QuickCorrect and the spell-checking features in Quattro Pro.

You've now finished the basics of Quattro Pro; in the next chapter, you move on to intermediate topics, beginning with printing.