Absolute Beginners Guide to Quattro Pro X3
Absolute Beginners Guide to Quattro Pro X3
ISBN: 0789734265
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 128
Pages: 128
Authors: Elaine Marmel
- 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
Absolute Beginners Guide to Quattro Pro X3
ISBN: 0789734265
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 128
Pages: 128
Authors: Elaine Marmel