Microsoft Office Excel 2007 Step by Step


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
overview

The smart way to learn the latest version of Microsoft Office Excel 2007one step at a time! Build exactly the skills you need by working at your own pace through easy-to-follow lessons and hands-on practice files on CD.



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

   Copyright
   About the Author
   Acknowledgments
   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
   Glossary
   Choose the Right Book for You
      Published and Upcoming Titles
   Index