Excel 2016 Bible

John Walkenbach, principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows.

• Acknowledgments ixIntroduction xliPart I: Getting Started with Excel 1Chapter 1: Introducing Excel 3Chapter 2: Entering and Editing Worksheet Data 9Chapter 3: Essential Worksheet Operations 51Chapter 4: Working with Cells and Ranges 73Chapter 5: Introducing Tables 109Chapter 6: Worksheet Formatting 129Chapter 7: Understanding Excel Files 157Chapter 8: Using and Creating Templates 171Chapter 9: Printing Your Work 181Part II: Working with Formulas and Functions 205Chapter 10: Introducing Formulas and Functions 207Chapter 11: Creating Formulas That Manipulate Text 243Chapter 12: Working with Dates and Times 263Chapter 13: Creating Formulas That Count and Sum 297Chapter 14: Creating Formulas That Look Up Values 327Chapter 15: Creating Formulas for Financial Applications 349Chapter 16: Miscellaneous Calculations 381Chapter 17: Introducing Array Formulas 395Chapter 18: Performing Magic with Array Formulas 421Part III: Creating Charts and Graphics 445Chapter 19: Getting Started Making Charts 447Chapter 20: Learning Advanced Charting 491Chapter 21: Visualizing Data Using Conditional Formatting 539Chapter 22: Creating Sparkline Graphics 563Chapter 23: Enhancing Your Work with Pictures and Drawings 579Part IV: Using Advanced Excel Features 601Chapter 24: Customizing the Excel User Interface 603Chapter 25: Using Custom Number Formats 613Chapter 26: Using Data Validation 633Chapter 27: Creating and Using Worksheet Outlines 647Chapter 28: Linking and Consolidating Worksheets 657Chapter 29: Excel and the Internet 677Chapter 30: Protecting Your Work 689Chapter 31: Making Your Worksheets Error Free 701Part V: Analyzing Data with Excel 731Chapter 32: Importing and Cleaning Data 733Chapter 33: Introducing Pivot Tables 763Chapter 34: Analyzing Data with Pivot Tables 785Chapter 35: Performing Spreadsheet What-If Analysis 823Chapter 36: Analyzing Data Using Goal Seeking and Solver 841Chapter 37: Analyzing Data with the Analysis ToolPak 863Chapter 38: Working with Get & Transform 877Part VI: Programming Excel with VBA 907Chapter 39: Introducing Visual Basic for Applications 909Chapter 40: Creating Custom Worksheet Functions 939Chapter 41: Creating UserForms 955Chapter 42: Using UserForm Controls in a Worksheet 977Chapter 43: Working with Excel Events 993Chapter 44: VBA Examples 1005Chapter 45: Creating Custom Excel Add-Ins 1021Part VII: Appendixes 1031Appendix A: Worksheet Function Reference 1033Appendix B: Excel Shortcut Keys 1053Index 1061