Part I: Getting Started with Excel . . . . . . . . . . . . . . . . . . . . . . . . . 1
Chapter 1: Introducing Excel ..................................................................................................................3
Chapter 2: What’s New in Excel 2007? ..................................................................................................25
Chapter 3: Entering and Editing Worksheet Data ..................................................................................35
Chapter 4: Essential Worksheet Operations ..........................................................................................53
Chapter 5: Working with Cells and Ranges............................................................................................71
Chapter 6: Introducing Tables ..............................................................................................................95
Chapter 7: Worksheet Formatting........................................................................................................109
Chapter 8: Understanding Excel’s Files ................................................................................................131
Chapter 9: Using and Creating Templates ............................................................................................145
Chapter 10: Printing Your Work ..........................................................................................................155
Part II: Working with Formulas and Functions . . . . . . . . . . . . . 173
Chapter 11: Introducing Formulas and Functions ..............................................................................175
Chapter 12: Creating Formulas That Manipulate Text..........................................................................205
Chapter 13: Working with Dates and Times ........................................................................................223
Chapter 14: Creating Formulas That Count and Sum ..........................................................................249
Chapter 15: Creating Formulas That Look Up Values ..........................................................................273
Chapter 16: Creating Formulas for Financial Applications ..................................................................291
Chapter 17: Introducing Array Formulas ............................................................................................313
Chapter 18: Performing Magic with Array Formulas............................................................................333
Part III: Creating Charts and Graphics . . . . . . . . . . . . . . . . . . . 349
Chapter 19: Getting Started Making Charts ........................................................................................351
Chapter 20: Learning Advanced Charting............................................................................................381
Chapter 21: Visualizing Data Using Conditional Formatting................................................................421
Chapter 22: Enhancing Your Work with Pictures and Drawings ..........................................................441
Part IV: Using Advanced Excel Features . . . . . . . . . . . . . . . . . . 459
Chapter 23: Customizing the Quick Access Toolbar ............................................................................461
Chapter 24: Using Custom Number Formats ......................................................................................465
Chapter 25: Using Data Validation ......................................................................................................481
Chapter 26: Creating and Using Worksheet Outlines ..........................................................................491
Chapter 27: Linking and Consolidating Worksheets ............................................................................499
Chapter 28: Excel and the Internet ......................................................................................................513
Chapter 29: Sharing Data with Other Applications ..............................................................................521
Chapter 30: Using Excel in a Workgroup ............................................................................................531
Chapter 31: Protecting Your Work ......................................................................................................539
Chapter 32: Making Your Worksheets Error-Free ................................................................................551
Part V: Analyzing Data with Excel. . . . . . . . . . . . . . . . . . . . . . . 573
Chapter 33: Using Microsoft Query with External Database Files ........................................................575
Chapter 34: Introducing Pivot Tables ..................................................................................................591
Chapter 35: Analyzing Data with Pivot Tables ....................................................................................609
Chapter 36: Performing Spreadsheet What-If Analysis ........................................................................635
Chapter 37: Analyzing Data Using Goal Seek and Solver ....................................................................649
Chapter 38: Analyzing Data with the Analysis ToolPak ........................................................................667
Part VI: Programming Excel with VBA. . . . . . . . . . . . . . . . . . . . 679
Chapter 39: Introducing Visual Basic for Applications ........................................................................681
Chapter 40: Creating Custom Worksheet Functions ............................................................................703
Chapter 41: Creating UserForms ........................................................................................................715
Chapter 42: Using UserForm Controls in a Worksheet ........................................................................733
Chapter 43: Working with Excel Events ..............................................................................................745
Chapter 44: VBA Examples..................................................................................................................757
Chapter 45: Creating Custom Excel Add-Ins ......................................................................................771
Part VII: Appendixes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 783
Appendix A: Worksheet Function Reference........................................................................................785
Appendix B: What’s on the CD-ROM..................................................................................................799
Appendix C: Additional Excel Resources ............................................................................................809
Appendix D: Excel Shortcut Keys ........................................................................................................815
Index .................................................................................................................................................823
Wiley Publishing, Inc. End-User License Agreement............................................................................869




补充内容 (2012-7-10 13:26):
中文版的在另一个帖子里：http://www.pinggu.org/bbs/thread-837081-1-1.html