Table of Contents
Introduction 1
Part 1: Getting Started with Excel 2016 9
CHAPTER 1: The Excel 2016 User Experience 11
CHAPTER 2: Creating a Spreadsheet from Scratch 41
Part 2: Editing without Tears 93
CHAPTER 3: Making It All Look Pretty 95
CHAPTER 4: Going Through Changes 145
CHAPTER 5: Printing the Masterpiece 177
Part 3: Getting Organized and Staying That Way 203
CHAPTER 6: Maintaining the Worksheet 205
CHAPTER 7: Maintaining Multiple Worksheets 233
Part 4: Digging Data Analysis 255
CHAPTER 8: Doing What-If Analysis 257
CHAPTER 9: Playing with Pivot Tables 271
Part 5: Life beyond the Spreadsheet 293
CHAPTER 10: Charming Charts and Gorgeous Graphics 295
CHAPTER 11: Getting on the Data List 331
CHAPTER 12: Linking, Automating, and Sharing Spreadsheets 355
Part 6: The Part of Tens 379
CHAPTER 13: Top Ten Beginner Basics 381
CHAPTER 14: The Ten Commandments of Excel 2016 385
CHAPTER 15: Top Ten Ways to Manage Your Data 387
CHAPTER 16: Top Ten Ways to Analyze Your Data 393
Index 397