Rights Contact Login For More Details
More About This Title Excel 2007 Bible
English
- 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 eBook file.
English
English
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
