Table of Contents

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