Essential Excel 2016

A Step-by-Step Guide

  • David Slager

Table of contents

  1. Front Matter
    Pages i-xxi
  2. David Slager
    Pages 1-26
  3. David Slager
    Pages 27-48
  4. David Slager
    Pages 49-88
  5. David Slager
    Pages 89-143
  6. David Slager
    Pages 173-218
  7. David Slager
    Pages 219-264
  8. David Slager
    Pages 265-302
  9. David Slager
    Pages 411-444
  10. David Slager
    Pages 445-501
  11. David Slager
    Pages 503-539
  12. David Slager
    Pages 541-589
  13. David Slager
    Pages 591-641
  14. David Slager
    Pages 643-664
  15. Back Matter
    Pages 665-673

About this book


Get up to speed quickly with Microsoft Excel 2016. See how easy it is to create, edit, sort, analyze, summarize, and format data. A broad range of other topics are covered, such as data import and export, sharing, visualization, validation, security, customization, and more.

Loaded with screen shots, step-by-step instructions, and hands-on exercises, Essential Excel 2016 makes it easy for you to get started or ramp up your skills with this powerful software.

In this book, you learn easy and accurate methods for entering data plus how to

  • Organize, format, filter, and consolidate your data in almost any way imaginable
  • Use built-in functions and customize your own
  • Create amazing visualizations of your data
  • Extract just the information you want from imported data, and manipulate and format the data in the way you want
  • Export your results to other programs or share with others in the cloud
  • Audit, validate, and protect your data

This book delivers the essential how-to and reference information for users new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to date on the latest changes and features in Excel 2016.


Excel Office 2016 Microsoft user guide beginner beginning spreadsheet data data entry

Authors and affiliations

  • David Slager
    • 1
  1. 1.Fort WayneUSA

Bibliographic information