Acknowledgments ix
Introduction xli
Part I: Getting Started with Excel 1
Chapter 1: Introducing Excel 3
Chapter 2: Entering and Editing Worksheet Data 9
Chapter 3: Essential Worksheet Operations 51
Chapter 4: Working with Cells and Ranges 73
Chapter 5: Introducing Tables 109
Chapter 6: Worksheet Formatting 129
Chapter 7: Understanding Excel Files 157
Chapter 8: Using and Creating Templates 171
Chapter 9: Printing Your Work 181
Part II: Working with Formulas and Functions 205
Chapter 10: Introducing Formulas and Functions 207
Chapter 11: Creating Formulas That Manipulate Text 243
Chapter 12: Working with Dates and Times 263
Chapter 13: Creating Formulas That Count and Sum 297
Chapter 14: Creating Formulas That Look Up Values 327
Chapter 15: Creating Formulas for Financial Applications 349
Chapter 16: Miscellaneous Calculations 381
Chapter 17: Introducing Array Formulas 395
Chapter 18: Performing Magic with Array Formulas 421
Part III: Creating Charts and Graphics 445
Chapter 19: Getting Started Making Charts 447
Chapter 20: Learning Advanced Charting 491
Chapter 21: Visualizing Data Using Conditional Formatting 539
Chapter 22: Creating Sparkline Graphics 563
Chapter 23: Enhancing Your Work with Pictures and Drawings 579
Part IV: Using Advanced Excel Features 601
Chapter 24: Customizing the Excel User Interface 603
Chapter 25: Using Custom Number Formats 613
Chapter 26: Using Data Validation 633
Chapter 27: Creating and Using Worksheet Outlines 647
Chapter 28: Linking and Consolidating Worksheets 657
Chapter 29: Excel and the Internet 677
Chapter 30: Protecting Your Work 689
Chapter 31: Making Your Worksheets Error Free 701
Part V: Analyzing Data with Excel 731
OBNB doesn't sell books, but you may be able to find a copy at one of these websites:
Excel 2016 bible by John Walkenbach. ISBN 9781119067504. Published by John Wiley & Sons in 2015. Publication and catalogue information, links to buy online and reader comments.
