| | Copyright |
| | About the Author |
| | Acknowledgments |
| | We Want to Hear from You! |
| | Introduction |
| | | Some Key Terms |
| | | Things to Keep in Mind |
| | | How to Use This Book |
| | | Conventions Used in This Book |
| | Part I: The Basics |
| | | Chapter 1. Getting Started |
| | | Opening the Program |
| | | Understanding Spreadsheets and Notebooks |
| | | Getting Help |
| | | Exiting the Program |
| | | Chapter 2. Working with Windows |
| | | Working with Windows |
| | | Exploring Views |
| | | Chapter 3. Navigating in a Notebook |
| | | Selecting Cells |
| | | Moving Around in a Spreadsheet |
| | | Moving to a Different Spreadsheet |
| | | Entering Information |
| | | Correcting Mistakes |
| | | Saving a Notebook |
| | | Chapter 4. Editing in a Spreadsheet |
| | | Renaming a Spreadsheet |
| | | Moving Information |
| | | Copying Information |
| | | Inserting and Deleting Rows and Columns |
| | | Hiding and Redisplaying Rows and Columns |
| | | Locking Row and Column Titles Onscreen |
| | | Chapter 5. More Editing in a Spreadsheet |
| | | Working with Ranges |
| | | Finding and Replacing Information |
| | | Checking Spelling |
| | | Using QuickCorrect |
| | | A Word About the Quattro Pro Experts |
| | Part II: The Intermediate Stuff |
| | | Chapter 6. Printing |
| | | Setting Up the Spreadsheet for Printing |
| | | Printing All or Part of a Notebook |
| | | Chapter 7. Managing Notebooks |
| | | Closing a Notebook |
| | | Creating a New Notebook |
| | | Opening an Existing Notebook |
| | | Rearranging Spreadsheets |
| | | Inserting and Deleting Spreadsheets |
| | | Grouping Spreadsheets |
| | | Linking Notebooks |
| | | Chapter 8. Formatting Notebooks |
| | | Using SpeedFormatting |
| | | Aligning Information |
| | | Joining Cells |
| | | Applying Numeric Formatting to Cells |
| | | Setting Row Height and Column Width |
| | | Swapping Rows and Columns |
| | | Chapter 9. More Notebook Formatting |
| | | Changing Fonts |
| | | Using Color |
| | | Adding Borders to Cells |
| | | Hiding and Displaying Gridlines |
| | | Underlining Totals |
| | | Copying Cell Formatting |
| | | Chapter 10. Working with Calculations |
| | | Calculating Within Cells |
| | | Creating Mathematical Calculations |
| | | Copying Formulas and Functions |
| | Part III: The Advanced Stuff |
| | | Chapter 11. Graphing Data |
| | | Understanding Chart Types |
| | | Creating a Chart |
| | | Printing a Chart |
| | | Modifying Chart Information |
| | | Chapter 12. Setting Up a Database in Quattro Pro |
| | | Understanding Databases, Fields, and Records |
| | | A Word of Caution Concerning Spreadsheet Databases |
| | | Adding Information to a Spreadsheet Database |
| | | Navigating and Editing in a Notebook Database |
| | | Searching a Database Using a Data Form Window |
| | | Creating Database Queries |
| | | Creating CrossTab Reports |
| | | Chapter 13. Analyzing Data |
| | | Sorting Data |
| | | Filtering Information |
| | | Transposing Rows and Columns |
| | | Creating What-If Tables |
| | | Consolidating Data |
| | | Chapter 14. More Data Analysis |
| | | Preparing an Amortization Schedule |
| | | Auditing Spreadsheet Formulas |
| | | Solving for a Variable |
| | | Creating a Frequency Distribution |
| | | Chapter 15. Customizing Menus and Toolbars |
| | | Customizing Toolbars |
| | | Customizing Menus |
| | | Chapter 16. Customizing Quattro Pro |
| | | Using Workspaces |
| | | Controlling Quattro Pro's Behavior |
| | | Glossary |
| | Index |