Table of Contents


book cover
Absolute Beginner's Guide to Quattro Pro® X3
By Elaine Marmel
...............................................
Publisher: Que
Pub Date: February 08, 2006
Print ISBN-10: 0-7897-3426-5
Print ISBN-13: 978-0-7897-3426-6
Pages: 352
 



Table of Contents  | Index

   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



Absolute Beginner's Guide to Quattro Pro X3
Absolute Beginners Guide to Quattro Pro X3
ISBN: 0789734265
EAN: 2147483647
Year: 2007
Pages: 128
Authors: Elaine Marmel

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net