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****ing, 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 ExcelChapter 03 - Excel EssentialsChapter 04 - Styles and FormattingChapter 05 - Sorting and ****ingChapter 06 - Analyzing Data Using Subtotals, Consolidations, and TablesChapter 07 - Creating PivotTables and PivotChartsChapter 08 - Editing PivotTables and PivotChartsChapter 09 - What-If AnalysisChapter 10 - Formulas and FunctionsChapter 11 - ChartsChapter 12 - Adding Graphics to a WorksheetChapter 13 - Preventing and Correcting ErrorsChapter 14 - Protection and SecurityChapter 15 - Getting Data from External SourcesChapter 16 - Sharing, Reviewing, and Distributing DataChapter 17 - SharePoint and Excel ServicesAppendix A - Location of Popular Excel 2003 Commands in Excel 2007Appendix B - Selecting Data in a PivotTable Report
Download
Code:
Code:
No comments:
Post a Comment