Excel 2010 Bible

Acknowledgments xxxvii
Introduction xxxviii
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data29
Chapter 3: Essential Worksheet Operations 49
Chapter 4: Working with Cells and Ranges 69
Chapter 5: Introducing Tables 99
Chapter 6: Worksheet Formatting 115
Chapter 7: Understanding Excel Files 141
Chapter 8: Using and Creating Templates 161
Chapter 9: Printing Your Work 171
Part II: Working with Formulas and Functions 193
Chapter 10: Introducing Formulas and Functions 195
Chapter 11: Creating Formulas That Manipulate Text 229
Chapter 12: Working with Dates and Times 249
Chapter 13: Creating Formulas That Count and Sum 281
Chapter 14: Creating Formulas That Look Up Values 309
Chapter 15: Creating Formulas for Financial Applications 329
Chapter 16: Introducing Array Formulas 355
Chapter 17: Performing Magic with Array Formulas 379
Part III: Creating Charts and Graphics 401
Chapter 18: Getting Started Making Charts 403
Chapter 19: Learning Advanced Charting 437
Chapter 20: Visualizing Data Using Conditional Formatting481
Chapter 21: Creating Sparkline Graphics 503
Chapter 22: Enhancing Your Work with Pictures and Drawings517
Part IV: Using Advanced Excel Features 539
Chapter 23: Customizing the Excel User Interface 541
Chapter 24: Using Custom Number Formats 551
Chapter 25: Using Data Validation 569
Chapter 26: Creating and Using Worksheet Outlines 581
Chapter 27: Linking and Consolidating Worksheets 589
Chapter 28: Excel and the Internet 605
Chapter 29: Sharing Data with Other Office Applications 615
Chapter 30: Using Excel in a Workgroup 627
Chapter 31: Protecting Your Work 637
Chapter 32: Making Your Worksheets Error-Free 649
Part V: Analyzing Data with Excel 675
Chapter Chapter 34: Introducing Pivot Tables 695
Chapter 33: Getting Data from External Database Files 677
Chapter 35: Analyzing Data with Pivot Tables 715
Chapter 36: Performing Spreadsheet What-If Analysis 745
Chapter 37: Analyzing Data Using Goal Seeking and Solver 761
Chapter 38: Analyzing Data with the Analysis ToolPak 781
Part VI: Programming Excel with VBA 793
Chapter 39: Introducing Visual Basic for Applications 795
Chapter 40: Creating Custom Worksheet Functions 823
Chapter 41: Creating UserForms 837
Chapter 42: Using UserForm Controls in a Worksheet 859
Chapter 43: Working with Excel Events 873
Chapter 44: VBA Examples 887
Chapter 45: Creating Custom Excel Add-Ins 903
Part VII: Appendixes 915
Appendix A: Worksheet Function Reference 917
Appendix B: What's on the CD-ROM 933