14. More Data Analysis
In This Chapter
• Creating an amortization schedule
• Auditing spreadsheet formulas
• 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 ...
Get Absolute Beginner’s Guide to Quattro Pro X3 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.