ISBN-10:
1590597982
ISBN-13:
9781590597989
Pub. Date:
03/21/2007
Publisher:
Apress
Excel 2007: Beyond the Manual / Edition 1

Excel 2007: Beyond the Manual / Edition 1

by Helen Dixon

Paperback

Current price is , Original price is $39.99. You
Select a Purchase Option (1st ed.)
  • purchase options
    $29.99 $39.99 Save 25% Current price is $29.99, Original price is $39.99. You Save 25%.
  • purchase options

Overview

Excel 2007: Beyond the Manual / Edition 1

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/21/2007
Series: Beyond the Manual Series
Edition description: 1st ed.
Pages: 448
Product dimensions: 7.52(w) x 9.25(h) x 0.04(d)

About the Author

Helen Dixon works for Queen's University in Belfast, U.K., training staff and students in IT and providing a consultancy service for staff. Her qualifications include a bachelor's degree (with honors) in business studies and a master's in computing and information systems. She is studying for a Ph.D. in electronic commerce.

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

Most Helpful Customer Reviews

See All Customer Reviews