Excel 2016 For Dummies Book + Online Videos Bundle

Inside:

• Bestselling Microsoft Excel 2016 For Dummies
• Online access code to 100 how–to videos covering Excel 2016

Master the leading spreadsheet and data analysis tool with this complete training package that covers everything you need to know about Microsoft Excel 2016

If the thought of looking at spreadsheets makes your head swell, you′ve come to the right place! This hands–on, complete training package gets you up and running with Excel 2016 fast. In no time, you′ll discover the best ways for creating and editing worksheets, formatting cells, entering formulas, inserting graphs, and more.

• For the love of spreadsheets if you′re starting with no experience in using spreadsheets, you′ll discover the secrets of the Ribbons interface before moving on to creating worksheets
• Hey, good lookin′ find out how to edit spreadsheets to make them look good, including how to make major editing changes without courting disaster
• Make it your minion discover the ins and outs of keeping track of data in a single worksheet or multiple worksheets within the same workbook
• Dig in to data set up data tables with one and two inputs, perform goal seeking, and create different cases with Scenario Manager
• Pivot on point get introduced to Excel 2016′s extensive pivot table and pivot chart capabilities that enable you to summarize and filter vast amounts of data

Features 100 step–by–step videos covering the most common Excel 2016 tasks. Activate your access code today!

Learn to:

• Create spreadsheets, perform data analysis, and work with pivot charts
• Know exactly when to enroll
• Make professional–looking charts, use graphics, and manage data lists
• Use apps for Office, share workbooks via OneDrive^®, and present worksheets online

Open the book and find:

• A copy of Microsoft Excel 2016 For Dummies, the book that′s helped millions of Excel users
• An access code to 100 videos sharing step–by–step training on core Excel 2016 functions
• Guidance on using Excel 2016 on a desktop, laptop, or tablet
• Tips for sharing spreadsheets via email, online meetings, and social media sites
• How to edit spreadsheets to make them look professional and presentation–ready
• Steps for inserting, editing, and formatting images
• The lowdown on importing external data

Introduction 1

Part I: Getting Started with Excel 2016 9

Chapter 1: The Excel 2016 User Experience 11

Chapter 2: Creating a Spreadsheet from Scratch 41

Part II: 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 III: Getting Organized and Staying That Way 203

Chapter 6: Maintaining the Worksheet 205

Chapter 7: Maintaining Multiple Worksheets 233

Part IV: Digging Data Analysis 255

Chapter 8: Doing What If Analysis 257

Chapter 9: Playing with Pivot Tables 271

Part V: 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 VI: The Part of Tens 379

Chapter 13: Top Ten Beginner Basics 381

Chapter 14: The Ten Commandments of Excel 2016 383

Chapter 15: Top Ten Ways to Manage Your Data 385

Chapter 16: Top Ten Ways to Analyze Your Data 391

Index 395

Greg Harvey (San Francisco, CA) is the president of Mind Over Media, Inc. Greg wrote his first computer book more than twenty years ago, and since that time he has amassed a long list of best-selling titles including Excel For Dummies (all editions), Excel All-In-One For Dummies (all editions), and many more. Greg has extensive training and teaching experience, and in addition to being the author of numerous books Greg is a certified secondary education teacher. He has a PhD in Philosophy and Religion in Asian and Comparative Studies and is currently pursuing an advanced degree in ASL while writing several books.