Excel 2007: Beyond the Manual

Description

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.

CONTENTS:

CHAPTER 1 - What's new in Excel 7 (WTF)

CHAPTER 2 - Customizing Excel

CHAPTER 3 - Excel Essentials

CHAPTER 4 - Sorting and Filtering

CHAPTER 5 - Analyzing Data

CHAPTER 6 - What-If Analysis

CHAPTER 7 - Functions

CHAPTER 8 - Charts

CHAPTER 9 - Graphics

CHAPTER 10 - Auditing and Security

CHAPTER 11 - Getting Data from External Sources

CHAPTER 12 - Sharepoint