Essential Excel 2016: A Step-by-Step Guide

  • 7h 14m
  • David Slager
  • Apress
  • 2016

This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step instructions, and reader exercises, Essential Excel 2016 makes it easy for you to get to grips with this powerful software and what it can do.

What You’ll Learn

  • How to create amazing visualizations of your data
  • Easy and accurate methods for entering data
  • How to extract just the information you want from imported data, and manipulate it and format it the way you want
  • Export your results to other programs or share with others in the cloud
  • Organize, Summarize, Filter, and Consolidate your Data in almost any way imaginable
  • Audit, Validate and Protect your Data

Who This Book Is For

Anyone new to Excel, or looking to take better advantage of the platform and find out its latest features

About the Author

David Slager has been a computer programmer for over 40 years and has taught Excel for 18 years. He has been working with spreadsheets since their introduction on the PC and has taught people of all ages from 1st graders to senior citizens.

In this Book

  • Becoming Acquainted with Excel
  • Navigating and Working with Worksheets
  • Best Ways to Enter and Edit Data
  • Formatting and Aligning Data
  • Different Ways of Viewing and Printing Your Workbook
  • Understanding Backstage
  • Creating and Using Formulas
  • Excel's Pre-existing Functions
  • Auditing, Validating, and Protecting Your Data
  • Using Hyperlinks, Combining Text, and Working with the Status Bar
  • Transferring and Duplicating Data to Other Locations
  • Working with Tables
  • Working with Charts
  • Importing Data
  • Using PivotTables and PivotCharts
  • Enhancing Workbooks with Multimedia
  • Automating Task with Macros


Rating 4.4 of 1162 users Rating 4.4 of 1162 users (1162)