Table of Contents

book cover
Microsoft® Office Excel® 2007 Step by Step
By Curtis D. Frye
Publisher: Microsoft Press
Pub Date: January 03, 2007
Print ISBN-10: 0-7356-2304-X
Print ISBN-13: 978-0-7356-2304-0
Pages: 432

Table of Contents  | Index

   About the Author
   Features and Conventions
   Using the Book's CD
   Getting Help
   The Microsoft Business Certification Program
   Quick Reference
    Chapter 1.  What's New in Excel 2007?
      Becoming Familiar with the New User Interface
      Managing Larger Data Collections
      Using the New Microsoft Office File Format
      Formatting Cells and Worksheets
      Managing Data Tables More Effectively
      Creating Formulas More Easily by Using Formula AutoComplete
      Summarizing Data Using New Functions
      Creating Powerful Conditional Formats
      Creating More Attractive Charts
      Controlling Printouts More Carefully
      Key Points
    Chapter 2.  Setting Up a Workbook
      Creating Workbooks
      Modifying Workbooks
      Modifying Worksheets
      Customizing the Excel 2007 Program Window
      Key Points
    Chapter 3.  Working with Data and Data Tables
      Entering and Revising Data
      Moving Data Within a Workbook
      Finding and Replacing Data
      Correcting and Expanding Upon Worksheet Data
      Defining a Table
      Key Points
    Chapter 4.  Performing Calculations on Data
      Naming Groups of Data
      Creating Formulas to Calculate Values
      Summarizing Data That Meets Specific Conditions
      Finding and Correcting Errors in Calculations
      Key Points
    Chapter 5.  Changing Document Appearance
      Formatting Cells
      Defining Styles
      Applying Workbook Themes and Table Styles
      Making Numbers Easier to Read
      Changing the Appearance of Data Based on Its Value
      Adding Images to a Document
      Key Points
    Chapter 6.  Focusing on Specific Data Using Filters
      Limiting Data That Appears on Your Screen
      Manipulating List Data
      Defining Valid Sets of Values for Ranges of Cells
      Key Points
    Chapter 7.  Reordering and Summarizing Data
      Sorting Data Lists
      Organizing Data into Levels
      Looking Up Information in a Data List
      Key Points
    Chapter 8.  Combining Data from Multiple Sources
      Using Data Lists as Templates for Other Lists
      Linking to Data in Other Worksheets and Workbooks
      Consolidating Multiple Sets of Data into a Single Workbook
      Grouping Multiple Sets of Data
      Key Points
    Chapter 9.  Analyzing Alternative Data Sets
      Defining and Editing Alternative Data Sets
      Defining Multiple Alternative Data Sets
      Varying Your Data to Get a Desired Result Using Goal Seek
      Finding Optimal Solutions with Solver
      Analyzing Data with Descriptive Statistics
      Key Points
    Chapter 10.  Creating Dynamic Lists with PivotTables
      Analyzing Data Dynamically with PivotTables
      Filtering, Showing, and Hiding PivotTable Data
      Editing PivotTables
      Formatting PivotTables
      Creating PivotTables from External Data
      Key Points
    Chapter 11.  Creating Charts and Graphics
      Creating Charts
      Customizing the Appearance of Charts
      Finding Trends in Your Data
      Creating Dynamic Charts Using PivotCharts
      Creating Diagrams by Using SmartArt
      Key Points
    Chapter 12.  Printing
      Adding Headers and Footers to Printed Pages
      Preparing Worksheets for Printing
      Printing Data Lists
      Printing Parts of Data Lists
      Printing Charts
      Key Points
    Chapter 13.  Automating Repetitive Tasks with Macros
      Introducing Macros
      Creating and Modifying Macros
      Running Macros When a Button Is Clicked
      Running Macros When a Workbook Is Opened
      Key Points
    Chapter 14.  Working with Other Microsoft Office System Programs
      Including Microsoft Office System Documents in Excel 2007 Worksheets
      Storing Excel 2007 Documents as Parts of Other Microsoft Office System Documents
      Creating Hyperlinks
      Pasting Charts into Other Documents
      Key Points
    Chapter 15.  Collaborating with Colleagues
      Sharing Data Lists
      Managing Comments
      Tracking and Managing Colleagues' Changes
      Protecting Workbooks and Worksheets
      Authenticating Workbooks
      Saving Workbooks for the Web
      Key Points
   Choose the Right Book for You
      Published and Upcoming Titles

MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: