Skip to main content

Excel 2007 Bible

Excel 2007 Bible

John Walkenbach

ISBN: 978-1-118-05067-5

Jun 2011

912 pages

$25.99

Description

  • 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.

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

Students will:
  • Learn their way around cells, rows, columns, worksheets, workbooks, and ranges
  • Discover how to create charts and diagrams, organize lists, and simplify complex tasks using Excel
  • Develop formulas that manipulate text, look up values, and perform financial applications
  • Analyze data using external database files and pivot tables
  • Use XML to facilitate data reporting, analysis, importing, and exporting
  • Explore conditional formatting, link and consolidate worksheets, and use Excel in a workgroup
  • Understand how Excel uses HTML in Internet applications
  • Program Excel using VBA, develop UserForms, and create custom add-ins