Excel 2007: Beyond the Manual

Front Cover
Apress, May 29, 2007 - Computers - 448 pages

Many experienced users may initially find Excel 2007 rather disorientating. But Excel 2007: Beyond the Manual will introduce those who are already familiar with Excel basics to more advanced features, like consolidation, what-if analysis, PivotTables, sorting and filtering, and some commonly used functions.

You'll learn how to maximize your efficiency at producing professional-looking spreadsheets and charts and become competent at analyzing data using a variety of tools. The book includes practical examples to illustrate advanced features. It also covers new features of Excel 2007 along with ways to access old features. You'll even gain timesaving tips and shortcuts.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Customizing Excel
25
Excel Essentials
39
Styles and
59
Sorting and Filtering
89
M
105
Creating PivotTables
131
Editing PivotTables
153
WhatIf Analysis
171
Preventing and
277
Protection and
299
Getting Data from
325
Sharing Reviewing
341
Figure 1617 Use the Document Inspector to check your data
358
SharePoint and Excel
363
3 Under Web Pages select Web Part Page Enter a
372
A
379

Formulas and
187
O
231
a Worksheet
251
Selecting Data in a
385
Copyright

Other editions - View all

Common terms and phrases

About the author (2007)

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.

Bibliographic information