* This book is a single reference that’s indispensable for
Excel beginners, intermediate users, power users, and would-be
power users everywhere
* Fully updated for the new release, this latest edition provides
comprehensive, soup-to-nuts coverage, delivering over 900 pages of
Excel tips, tricks, and techniques readers won’t find
anywhere else
* John Walkenbach, aka ‚Mr. Spreadsheet, ‚ is one of the
liworld’s leading authorities on Excel
* Thoroughly updated to cover the revamped Excel interface, new
file formats, enhanced interactivity with other Office
applications, and upgraded collaboration features
* Includes a valuable CD-ROM with templates and worksheets from
the book
Note: CD-ROM/DVD and other supplementary materials are
not included as part of e Book file.
Inhaltsverzeichnis
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 Tool Pak 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 User Forms 715
Chapter 42: Using User Form 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
Über den Autor
John Walkenbach, a.k.a ‚Mr. Spreadsheet, ‚ is a principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books, including Excel 2003 Formulas and Excel 2003 Power Programming with VBA, as well as articles and reviews for publications including PC World, Info World, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss.
Ebooks vom selben Autor / Herausgeber
16.612 Ebooks in dieser Kategorie
