Acknowledgments ix

Introduction xxxvii

Is This Book for You? xxxvii

Software Versions xxxvii

Conventions Used in This Book xxxviii

Excel commands xxxviii

Filenames, named ranges, and your input xxxviii

Key names xxxviii

Functions xxxviii

Mouse conventions xxxix

How This Book Is Organized xl

How to Use This Book  xl

What’s on the Website xli

Part I: Getting Started with Excel 1

Chapter 1: Introducing Excel ۳

Chapter 2: Entering and Editing Worksheet Data 29

Chapter 3: Essential Worksheet Operations ۴۹

Chapter 4: Working with Cells and Ranges 69

Chapter 5: Introducing Tables ۱۰۱

Chapter 6: Worksheet Formatting ۱۱۹

Chapter 7: Understanding Excel Files ۱۴۵

Chapter 8: Using and Creating Templates 161

Chapter 9: Printing Your Work ۱۷۱

Part II: Working with Formulas and Functions 193

Chapter 10: Introducing Formulas and Functions ۱۹۵

Chapter 11: Creating Formulas That Manipulate Text ۲۳۱

Chapter 12: Working with Dates and Times ۲۵۱

Chapter 13: Creating Formulas That Count and Sum ۲۸۵

Chapter 14: Creating Formulas That Look Up Values 313

Chapter 15: Creating Formulas for Financial Applications 333

Chapter 16: Miscellaneous Calculations 359

Chapter 17: Introducing Array Formulas ۳۷۳

Chapter 18: Performing Magic with Array Formulas 397

Part III: Creating Charts and Graphics 419

Chapter 19: Getting Started Making Charts ۴۲۱

Chapter 20: Learning Advanced Charting ۴۵۷

Chapter 21: Visualizing Data Using Conditional Formatting 503

Chapter 22: Creating Sparkline Graphics ۵۲۵

Chapter 23: Enhancing Your Work with Pictures and Drawings 539

Part IV: Using Advanced Excel Features 561

Chapter 24: Customizing the Excel User Interface ۵۶۳

Chapter 25: Using Custom Number Formats ۵۷۳

Chapter 26: Using Data Validation 591

Chapter 27: Creating and Using Worksheet Outlines ۶۰۳

Chapter 28: Linking and Consolidating Worksheets ۶۱۳

Chapter 29: Excel and the Internet 631

Chapter 30: Protecting Your Work ۶۴۳

Chapter 31: Making Your Worksheets Error Free ۶۵۵

Part V: Analyzing Data with Excel 683

Chapter 32: Importing and Cleaning Data 685

Chapter 33: Introducing Pivot Tables ۷۱۵

Chapter 34: Analyzing Data with Pivot Tables ۷۳۹

Chapter 35: Performing Spreadsheet What-If Analysis 777

Chapter 36: Analyzing Data Using Goal Seeking and Solver 793

Chapter 37: Analyzing Data with the Analysis ToolPak ۸۱۳

Part VI: Programming Excel with VBA 825

Chapter 38: Introducing Visual Basic for Applications ۸۲۷

Chapter 39: Creating Custom Worksheet Functions 855

Chapter 40: Creating UserForms ۸۶۹

Chapter 41: Using UserForm Controls in a Worksheet ۸۸۹

Chapter 42: Working with Excel Events ۹۰۳

Chapter 44: Creating Custom Excel Add-Ins ۹۳۱

Part VII: Appendixes 941

Appendix A: Worksheet Function Reference ۹۴۳

Appendix B: Excel Shortcut Keys ۹۶۱

Index 967