Excel 2016 For Dummies (Paperback)

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