Excel 2007: Beyond the Manual / Edition 1

Excel 2007: Beyond the Manual / Edition 1

by Helen Dixon
     
 

ISBN-10: 1590597982

ISBN-13: 9781590597989

Pub. Date: 03/20/2007

Publisher: Apress

Excel 2007: Beyond the Manual is written for the experienced Excel user who wants to learn version 2007 quickly and efficiently. Features new to Excel 2007 are emphasized, as are complex features that, though available in earlier versions of Excel, were not readily accessible. The book uses practical examples to illustrate advanced features. The narrative is

Overview

Excel 2007: Beyond the Manual is written for the experienced Excel user who wants to learn version 2007 quickly and efficiently. Features new to Excel 2007 are emphasized, as are complex features that, though available in earlier versions of Excel, were not readily accessible. The book uses practical examples to illustrate advanced features. The narrative is fast-paced, concise, and respectful of the reader’s familiarity with earlier versions of the program.

Product Details

ISBN-13:
9781590597989
Publisher:
Apress
Publication date:
03/20/2007
Series:
Beyond the Manual Series
Edition description:
2007
Pages:
448
Product dimensions:
7.50(w) x 9.25(h) x 1.00(d)

Table of Contents

1 What’s New in Excel 2007? . . . . . . . . . . . . . . . . . . . . . 1
2 Customizing Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
3 Excel Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39
4 Styles and Formatting . . . . . . . . . . . . . . . . . . . . . . . . 59
5 Sorting and Filtering . . . . . . . . . . . . . . . . . . . . . . . . . 89
6 Analyzing Data Using Subtotals, Consolidations, and Tables . . . . 105
7 Creating PivotTables and PivotCharts . . . . . . . . . . . . . 131
8 Editing PivotTables and PivotCharts . . . . . . . . . . . . . . 153
9 What-If Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171
10 Formulas and Functions . . . . . . . . . . . . . . . . . . . . . . 187
11 Charts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231
12 Adding Graphics to a Worksheet . . . . . . . . . . . . . . . . 251
13 Preventing and Correcting Errors . . . . . . . . . . . . . . . . 277
14 Protection and Security . . . . . . . . . . . . . . . . . . . . . . . 299
15 Getting Data from External Sources . . . . . . . . . . . . . . 325
16 Sharing, Reviewing, and Distributing Data . . . . . . . . . . 341
17 SharePoint and Excel Services . . . . . . . . . . . . . . . . . . 363
APPENDIX A Location of Popular Excel 2003 Commands in Excel 2007 . . . . 379
APPENDIX B Selecting Data in a PivotTable Report . . . . . . . . . . . . . 385
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >