O'Reilly logo

Absolute Beginner’s Guide to Quattro Pro X3 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

14. More Data Analysis

In This Chapter

Creating an amortization schedule

Auditing spreadsheet formulas

Solving for a variable

Creating a frequency distribution

Quattro Pro contains a wide variety of analysis tools; in the last chapter, I introduced you to some of the tools you can use in a spreadsheet database, and you also saw a few tools you can use in a regular spreadsheet. In this chapter, we’ll explore some additional tools you might find useful in a regular spreadsheet.

We’ll start by walking through one of the tools available through the Analysis Expert. The Analysis Expert is a wizard that asks you to provide answers to questions needed to solve a mathematical formula. Using the Analysis Expert is a little like having a helper ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required