John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.

• Acknowledgments ix Introduction xxxviiIs This Book for You? xxxviiSoftware Versions xxxviiConventions Used in This Book xxxviiiExcel commands xxxviiiFilenames, named ranges, and your input xxxviiiKey names xxxviiiFunctions xxxviiiMouse conventions xxxixHow This Book Is Organized xlHow to Use This Book  xlWhat’s on the Website xliPart I: Getting Started with Excel 1Chapter 1: Introducing Excel 3Chapter 2: Entering and Editing Worksheet Data 29Chapter 3: Essential Worksheet Operations 49Chapter 4: Working with Cells and Ranges 69Chapter 5: Introducing Tables 101Chapter 6: Worksheet Formatting 119Chapter 7: Understanding Excel Files 145Chapter 8: Using and Creating Templates 161Chapter 9: Printing Your Work 171Part II: Working with Formulas and Functions 193Chapter 10: Introducing Formulas and Functions 195Chapter 11: Creating Formulas That Manipulate Text 231Chapter 12: Working with Dates and Times 251Chapter 13: Creating Formulas That Count and Sum 285Chapter 14: Creating Formulas That Look Up Values 313Chapter 15: Creating Formulas for Financial Applications 333Chapter 16: Miscellaneous Calculations 359Chapter 17: Introducing Array Formulas 373Chapter 18: Performing Magic with Array Formulas 397Part III: Creating Charts and Graphics 419Chapter 19: Getting Started Making Charts 421Chapter 20: Learning Advanced Charting 457Chapter 21: Visualizing Data Using Conditional Formatting 503Chapter 22: Creating Sparkline Graphics 525Chapter 23: Enhancing Your Work with Pictures and Drawings 539Part IV: Using Advanced Excel Features 561Chapter 24: Customizing the Excel User Interface 563Chapter 25: Using Custom Number Formats 573Chapter 26: Using Data Validation 591Chapter 27: Creating and Using Worksheet Outlines 603Chapter 28: Linking and Consolidating Worksheets 613Chapter 29: Excel and the Internet 631Chapter 30: Protecting Your Work 643Chapter 31: Making Your Worksheets Error Free 655Part V: Analyzing Data with Excel 683Chapter 32: Importing and Cleaning Data 685Chapter 33: Introducing Pivot Tables 715Chapter 34: Analyzing Data with Pivot Tables 739Chapter 35: Performing Spreadsheet What-If Analysis 777Chapter 36: Analyzing Data Using Goal Seeking and Solver 793Chapter 37: Analyzing Data with the Analysis ToolPak 813Part VI: Programming Excel with VBA 825Chapter 38: Introducing Visual Basic for Applications 827Chapter 39: Creating Custom Worksheet Functions 855Chapter 40: Creating UserForms 869Chapter 41: Using UserForm Controls in a Worksheet 889Chapter 42: Working with Excel Events 903Chapter 44: Creating Custom Excel Add-Ins 931Part VII: Appendixes 941Appendix A: Worksheet Function Reference 943Appendix B: Excel Shortcut Keys 961Index 967

Select Guide Rating

John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.

• Acknowledgments ix Introduction xxxviiIs This Book for You? xxxviiSoftware Versions xxxviiConventions Used in This Book xxxviiiExcel commands xxxviiiFilenames, named ranges, and your input xxxviiiKey names xxxviiiFunctions xxxviiiMouse conventions xxxixHow This Book Is Organized xlHow to Use This Book  xlWhat’s on the Website xliPart I: Getting Started with Excel 1Chapter 1: Introducing Excel 3Chapter 2: Entering and Editing Worksheet Data 29Chapter 3: Essential Worksheet Operations 49Chapter 4: Working with Cells and Ranges 69Chapter 5: Introducing Tables 101Chapter 6: Worksheet Formatting 119Chapter 7: Understanding Excel Files 145Chapter 8: Using and Creating Templates 161Chapter 9: Printing Your Work 171Part II: Working with Formulas and Functions 193Chapter 10: Introducing Formulas and Functions 195Chapter 11: Creating Formulas That Manipulate Text 231Chapter 12: Working with Dates and Times 251Chapter 13: Creating Formulas That Count and Sum 285Chapter 14: Creating Formulas That Look Up Values 313Chapter 15: Creating Formulas for Financial Applications 333Chapter 16: Miscellaneous Calculations 359Chapter 17: Introducing Array Formulas 373Chapter 18: Performing Magic with Array Formulas 397Part III: Creating Charts and Graphics 419Chapter 19: Getting Started Making Charts 421Chapter 20: Learning Advanced Charting 457Chapter 21: Visualizing Data Using Conditional Formatting 503Chapter 22: Creating Sparkline Graphics 525Chapter 23: Enhancing Your Work with Pictures and Drawings 539Part IV: Using Advanced Excel Features 561Chapter 24: Customizing the Excel User Interface 563Chapter 25: Using Custom Number Formats 573Chapter 26: Using Data Validation 591Chapter 27: Creating and Using Worksheet Outlines 603Chapter 28: Linking and Consolidating Worksheets 613Chapter 29: Excel and the Internet 631Chapter 30: Protecting Your Work 643Chapter 31: Making Your Worksheets Error Free 655Part V: Analyzing Data with Excel 683Chapter 32: Importing and Cleaning Data 685Chapter 33: Introducing Pivot Tables 715Chapter 34: Analyzing Data with Pivot Tables 739Chapter 35: Performing Spreadsheet What-If Analysis 777Chapter 36: Analyzing Data Using Goal Seeking and Solver 793Chapter 37: Analyzing Data with the Analysis ToolPak 813Part VI: Programming Excel with VBA 825Chapter 38: Introducing Visual Basic for Applications 827Chapter 39: Creating Custom Worksheet Functions 855Chapter 40: Creating UserForms 869Chapter 41: Using UserForm Controls in a Worksheet 889Chapter 42: Working with Excel Events 903Chapter 44: Creating Custom Excel Add-Ins 931Part VII: Appendixes 941Appendix A: Worksheet Function Reference 943Appendix B: Excel Shortcut Keys 961Index 967

Select Guide Rating

John Walkenbach (aka "Mr. Spreadsheet") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.

• Acknowledgments ix Introduction xxxviiIs This Book for You? xxxviiSoftware Versions xxxviiConventions Used in This Book xxxviiiExcel commands xxxviiiFilenames, named ranges, and your input xxxviiiKey names xxxviiiFunctions xxxviiiMouse conventions xxxixHow This Book Is Organized xlHow to Use This Book  xlWhat’s on the Website xliPart I: Getting Started with Excel 1Chapter 1: Introducing Excel 3Chapter 2: Entering and Editing Worksheet Data 29Chapter 3: Essential Worksheet Operations 49Chapter 4: Working with Cells and Ranges 69Chapter 5: Introducing Tables 101Chapter 6: Worksheet Formatting 119Chapter 7: Understanding Excel Files 145Chapter 8: Using and Creating Templates 161Chapter 9: Printing Your Work 171Part II: Working with Formulas and Functions 193Chapter 10: Introducing Formulas and Functions 195Chapter 11: Creating Formulas That Manipulate Text 231Chapter 12: Working with Dates and Times 251Chapter 13: Creating Formulas That Count and Sum 285Chapter 14: Creating Formulas That Look Up Values 313Chapter 15: Creating Formulas for Financial Applications 333Chapter 16: Miscellaneous Calculations 359Chapter 17: Introducing Array Formulas 373Chapter 18: Performing Magic with Array Formulas 397Part III: Creating Charts and Graphics 419Chapter 19: Getting Started Making Charts 421Chapter 20: Learning Advanced Charting 457Chapter 21: Visualizing Data Using Conditional Formatting 503Chapter 22: Creating Sparkline Graphics 525Chapter 23: Enhancing Your Work with Pictures and Drawings 539Part IV: Using Advanced Excel Features 561Chapter 24: Customizing the Excel User Interface 563Chapter 25: Using Custom Number Formats 573Chapter 26: Using Data Validation 591Chapter 27: Creating and Using Worksheet Outlines 603Chapter 28: Linking and Consolidating Worksheets 613Chapter 29: Excel and the Internet 631Chapter 30: Protecting Your Work 643Chapter 31: Making Your Worksheets Error Free 655Part V: Analyzing Data with Excel 683Chapter 32: Importing and Cleaning Data 685Chapter 33: Introducing Pivot Tables 715Chapter 34: Analyzing Data with Pivot Tables 739Chapter 35: Performing Spreadsheet What-If Analysis 777Chapter 36: Analyzing Data Using Goal Seeking and Solver 793Chapter 37: Analyzing Data with the Analysis ToolPak 813Part VI: Programming Excel with VBA 825Chapter 38: Introducing Visual Basic for Applications 827Chapter 39: Creating Custom Worksheet Functions 855Chapter 40: Creating UserForms 869Chapter 41: Using UserForm Controls in a Worksheet 889Chapter 42: Working with Excel Events 903Chapter 44: Creating Custom Excel Add-Ins 931Part VII: Appendixes 941Appendix A: Worksheet Function Reference 943Appendix B: Excel Shortcut Keys 961Index 967

Select Guide Rating