Tài liệu Excel 2007: Beyond the Manual

About the Author . xix
About the Technical Reviewer . xxi
Acknowledgments xxiii
Introduction xxv
CHAPTER 1 What’s New in Excel 2007? . 1
CHAPTER 2 Customizing Excel . 25
CHAPTER 3 Excel Essentials . 39
CHAPTER 4 Styles and Formatting 59
CHAPTER 5 Sorting and Filtering . 89
CHAPTER 6 Analyzing Data Using Subtotals, Consolidations, and Tables . 105
CHAPTER 7 Creating PivotTables and PivotCharts . 131
CHAPTER 8 Editing PivotTables and PivotCharts 153
CHAPTER 9 What-If Analysis 171
CHAPTER 10 Formulas and Functions 187
CHAPTER 11 Charts 231
CHAPTER 12 Adding Graphics to a Worksheet 251
CHAPTER 13 Preventing and Correcting Errors 277
CHAPTER 14 Protection and Security . 299
CHAPTER 15 Getting Data from External Sources 325
CHAPTER 16 Sharing, Reviewing, and Distributing Data 341
CHAPTER 17 SharePoint and Excel Services 363
APPENDIX A Location of Popular Excel 2003 Commands in Excel 2007 . 379
APPENDIX B Selecting Data in a PivotTable Report . 385
Index . 387