Excel 2007 Beyond The Manual

This book is aimed at spreadsheet users who already have some familiarity with previous versions of Microsoft Excel and who want an overview of the modifications and new features being introduced with Microsoft Office 2007. The book is also intended to be a practical guide to anyone wishing to update their Excel skills and progress to the more advanced features of this essential spreadsheet application.

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.

TABLE OF CONTENT:
Chapter 01 - What’s New in Excel 2007?
Chapter 02 - Customizing Excel
Chapter 03 - Excel Essentials
Chapter 04 - Styles and Formatting
Chapter 05 - Sorting and Filtering
Chapter 06 - Analyzing Data Using Subtotals, Consolidations, and Tables
Chapter 07 - Creating PivotTables and PivotCharts
Chapter 08 - Editing PivotTables and PivotCharts
Chapter 09 - What-If Analysis
Chapter 10 - Formulas and Functions
Chapter 11 - Charts
Chapter 12 - Adding Graphics to a Worksheet
Chapter 13 - Preventing and Correcting Errors
Chapter 14 - Protection and Security
Chapter 15 - Getting Data from External Sources
Chapter 16 - Sharing, Reviewing, and Distributing Data
Chapter 17 - SharePoint and Excel Services
Appendix A - Location of Popular Excel 2003 Commands in Excel 2007
Appendix B - Selecting Data in a PivotTable Report

Download here

password:knowfree.net