Table of Contents


book cover
Excel 2007: The Missing Manual
By Matthew  MacDonald
...............................................
Publisher: O'Reilly
Pub Date: December 01, 2006
ISBN-10: 0-596-52759-4
ISBN-13: 978-0-596-52759-4
Pages: 800
 

Table of Contents    Index

      Copyright
      The Missing Credits
      Introduction
      Part I:   Worksheet Basics
        Chapter 1.   Creating and Navigating Worksheets
        Section 1.1.   Creating a Basic Worksheet
        Section 1.2.   Editing Data
        Section 1.3.   Navigating in Excel
        Section 1.4.   Saving Files
        Section 1.5.   Opening Files
        Chapter 2.   Adding Information to Worksheets
        Section 2.1.   Adding Different Types of Data
        Section 2.2.   Quick Ways to Add Data
        Chapter 3.   Moving Data Around a Worksheet
        Section 3.1.   Selecting Cells
        Section 3.2.   Moving Cells Around
        Section 3.3.   Adding and Moving Columns or Rows
        Chapter 4.   Managing Worksheets and Workbooks
        Section 4.1.   Worksheets and Workbooks
        Section 4.2.   Find and Replace
        Section 4.3.   Spell Check
        Chapter 5.   Formatting Cells
        Section 5.1.   Formatting Cell Values
        Section 5.2.   Formatting Cell Appearance
        Chapter 6.   Smart Formatting Tricks
        Section 6.1.   The Format Painter
        Section 6.2.   Styles and Themes
        Section 6.3.   Conditional Formatting
        Chapter 7.   Viewing and Printing Worksheets
        Section 7.1.   Controlling Your View
        Section 7.2.   Printing
        Section 7.3.   Controlling Pagination
      Part II:   Formulas and Functions
        Chapter 8.   Building Basic Formulas
        Section 8.1.   Creating a Basic Formula
        Section 8.2.   Formula Shortcuts
        Section 8.3.   Copying Formulas
        Chapter 9.   Math and Statistical Functions
        Section 9.1.   Rounding Numbers
        Section 9.2.   Groups of Numbers
        Section 9.3.   General Math Functions
        Section 9.4.   Trigonometry and Advanced Math
        Section 9.5.   Advanced Statistics
        Chapter 10.   Financial Functions
        Section 10.1.   The World of Finance
        Section 10.2.   Financial Functions
        Section 10.3.   Depreciation
        Section 10.4.   Other Financial Functions
        Chapter 11.   Manipulating Dates, Times, and Text
        Section 11.1.   Manipulating Text
        Section 11.2.   Manipulating Dates and Times
        Section 11.3.   Math with Dates and Times
        Section 11.4.   Date and Time Functions
        Chapter 12.   Lookup, Reference, and Information Functions
        Section 12.1.   The Basic Lookup
        Section 12.2.   Advanced Lookups
        Section 12.3.   Information Functions
        Section 12.4.   Tutorial: Quickly Generating Invoices from a Product Catalog
        Chapter 13.   Advanced Formula Writing and Troubleshooting
        Section 13.1.   Conditions in Formulas
        Section 13.2.   Descriptive Names for Cell References
        Section 13.3.   Variable Data Tables
        Section 13.4.   Controlling Recalculation
        Section 13.5.   Solving Formula Errors
      Part III:   Organizing Worksheets
        Chapter 14.   Tables: List Management Made Easy
        Section 14.1.   The Basics of tablesTables
        Section 14.2.   Sorting and Filtering a Table
        Section 14.3.   Dealing with Duplicate Rows
        Section 14.4.   Performing Table Calculations
        Chapter 15.   Grouping and Outlining Data
        Section 15.1.   Basic Data Grouping
        Section 15.2.   Grouping Timesavers
        Chapter 16.   Templates
        Section 16.1.   Understanding Templates
        Section 16.2.   Creating a New Workbook from a Template
        Section 16.3.   Creating Templates
      Part IV:   Charts and Graphics
        Chapter 17.   Creating Basic Charts
        Section 17.1.   Charting 101
        Section 17.2.   Basic Tasks with Charts
        Section 17.3.   Practical Charting
        Section 17.4.   Chart Types
        Chapter 18.   Formatting and Perfecting Charts
        Section 18.1.   Chart Styles and Layouts
        Section 18.2.   Adding Chart Elements
        Section 18.3.   Selecting Chart Elements
        Section 18.4.   Formatting Chart Elements
        Section 18.5.   Improving Your Charts
        Section 18.6.   Advanced Charting
        Chapter 19.   Inserting Graphics
        Section 19.1.   Adding Pictures to a Worksheet
        Section 19.2.   Excel's Clip Art Library
        Section 19.3.   Drawing Shapes
      Part V:   Advanced Data Analysis
        Chapter 20.   Scenarios and Goal Seeking
        Section 20.1.   Using Scenarios
        Section 20.2.   Using Goal Seek
        Section 20.3.   Solver
        Chapter 21.   Pivot Tables
        Section 21.1.   Summary Tables Revisited
        Section 21.2.   Building Pivot Tables
        Section 21.3.   Multi-Layered Pivot Tables
        Section 21.4.   Fine-Tuning Pivot Table Calculations
        Section 21.5.   Filtering a Pivot Table
        Section 21.6.   Pivot Charts
      Part VI:   Sharing Data with the Rest of the World
        Chapter 22.   Protecting Your Workbooks
        Section 22.1.   Understanding Excel's Safeguards
        Section 22.2.   Data Validation
        Section 22.3.   Locked and Hidden Cells
        Chapter 23.   Worksheet Collaboration
        Section 23.1.   Preparing Your Workbook
        Section 23.2.   Adding Comments
        Section 23.3.   Tracking Changes
        Section 23.4.   Sharing Your Workbook
        Chapter 24.   Querying Databases and XML Files
        Section 24.1.   Excel and Databases
        Section 24.2.   Understanding XML
        Section 24.3.   Excel and XML
        Chapter 25.   Exchanging Data with Other Programs
        Section 25.1.   Sharing Information in Windows
        Section 25.2.   Embedding and Linking Objects
        Section 25.3.   Transferring Data
        Chapter 26.   Connecting Worksheets to the Web
        Section 26.1.   Putting Worksheets on the Web
        Section 26.2.   Performing Web Queries
        Section 26.3.   Using Hyperlinks
      Part VII:   Programming Excel
        Chapter 27.   Automating Tasks with Macros
        Section 27.1.   Macros 101
        Section 27.2.   The Macro Recorder
        Section 27.3.   Macro Security
        Section 27.4.   Creating Practical Macros
        Chapter 28.   Programming Spreadsheets with VBA
        Section 28.1.   The Visual Basic Editor
        Section 28.2.   Understanding Macro Code
        Section 28.3.   Exploring the VBA Language
      Part VIII:   Appendix
        Appendix A.   Customizing the Quick Access Toolbar
        Section A.1.   The Quick Access Toolbar
      Colophon
      Index



Excel 2007[c] The Missing Manual
Excel 2007[c] The Missing Manual
ISBN: 596527594
EAN: N/A
Year: 2007
Pages: 173

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