|
 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.Youll 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. Youll even gain timesaving tips and shortcuts.
CHAPTER 1 What’s New inExcel 2007?
CHAPTER 2 Customizing Excel
CHAPTER 3 Excel Essentials
CHAPTER 4 Styles and Formatting
CHAPTER 5 Sorting and Filtering
CHAPTER 6 Analyzing Data Using Subtotals, Consolidations, and Tables
CHAPTER 7 Creating PivotTables and PivotCharts
CHAPTER 8 Editing PivotTables and PivotCharts
CHAPTER 9 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 free ebook on Office: Mircosoft Excel 2007: Beyond the Manual
|
More computer ebooks