---

Absolute Beginners Guide to Quattro Pro X3

ISBN: 0789734265
EAN: 2147483647

Year: 2007
Pages: 128

Authors: Elaine Marmel

BUY ON AMAZON

• Absolute Beginner s Guide to Quattro Pro X3
• Table of Contents
• 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
• SYMBOL
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W