The complete guide to Excel 2016, from Mr. Spreadsheet himself

Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.

Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible.

• Create functional spreadsheets that work
• Master formulas, formatting, pivot tables, and more
• Get acquainted with Excel 2016's new features and tools
• Customize downloadable templates and worksheets

Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.

Table of Contents

Part I: Getting Started with Excel

Chapter 1: Introducing Excel

Chapter 2: Entering and Editing Worksheet Data

Chapter 3: Essential Worksheet Operations

Chapter 4: Working with Cells and Ranges

Chapter 5: Introducing Tables

Chapter 6: Worksheet Formatting

Chapter 7: Understanding Excel Files

Chapter 8: Using and Creating Templates

Chapter 9: Printing Your Work

Part II: Working with Formulas and Functions

Chapter 10: Introducing Formulas and Functions

Chapter 11: Creating Formulas That Manipulate Text

Chapter 12: Working with Dates and Times

Chapter 13: Creating Formulas That Count and Sum

Chapter 14: Creating Formulas That Look Up Values

Chapter 15: Creating Formulas for Financial Applications

Chapter 16: Miscellaneous Calculations

Chapter 17: Introducing Array Formulas

Chapter 18: Performing Magic with Array Formulas

Part III: Creating Charts and Graphics

Chapter 19: Getting Started Making Charts

Chapter 20: Learning Advanced Charting

Chapter 21: Visualizing Data Using Conditional F ormatting

Chapter 22: Creating Sparkline Graphics

Chapter 23: Enhancing Your Work with Pictures and Drawings

Part IV: Using Advanced Excel Features

Chapter 24: Customizing the Excel User Interface

Chapter 25: Using Custom Number Formats

Chapter 26: Using Data Validation

Chapter 27: Creating and Using Worksheet Outlines

Chapter 28: Linking and Consolidating Worksheets

Chapter 29: Excel and the Internet

Chapter 30: Protecting Your Work

Chapter 31: Making Your Worksheets Error Free

Part V: Analyzing Data with Excel

Chapter 32: Importing and Cleaning Data

Chapter 33: Introducing Pivot Tables

Chapter 34: Analyzing Data with Pivot Tables

Chapter 35: Performing Spreadsheet What-If Analysis

Chapter 36: Analyzing Data Using Goal Seeking and Solver

Chapter 37: Analyzing Data with the Analysis ToolPak

Chapter 38: Working with Get & Transform

Part VI: Programming Excel with VBA

Chapter 39: Introducing Visual Basic for Applications

Chapter 40: Creating Custom Worksheet Functions

Chapter 41: Creating UserForms

Chapter 42: Using UserForm Controls in a Worksheet

Chapter 43: Working with Excel Events

Chapter 44: VBA Examples

Chapter 45: Creating Custom Excel Add-Ins

Part VII: Appendixes

Appendix A: Worksheet Function Reference

Appendix B: Excel Shortcut Keys

About the Author

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.