Excel 2007 Beyond The Manual
Author(s) : Helen Dixon
Publisher : Apress
Year : Mar 2007
ISBN 10 : 1590597982
ISBN 13 : 9781590597989
******** : English
Pages : 417
File type : PDF
Size : 10.3 MB
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 *******:
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 - ******** of Popular Excel 2003 Commands in Excel 2007
Appendix B - Selecting Data in a PivotTable Report
للتحميل:
هنــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــا
كلمة السر:
ganelon