---

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

---

Chapter 1: Becoming Acquainted with Excel

Chapter 2: Moving Around the Worksheet

Chapter 3: Best Ways to Enter Data

Chapter 4: Formatting and Aligning Data

Chapter 5: Different Ways of Viewing and Printing your Workbook

Chapter 6: Understanding Backstage
Chapter 7: Creating and Using Formulas

Chapter 8: Excel´s Pre-existing Functions

Chapter 9: Auditing, Validating and Protecting your Data

Chapter 10: Using Hyperlinks, Combining Text, and Working with the Status Bar

Chapter 11: Transferring and Duplicating Data to Other Locations

Chapter 12: Working with Tables
Chapter 13: Working with Charts

Chapter 14: Importing Data

Chapter 15: Using PivotTables and PivotCharts

Chapter 16: Enhancing Workbooks with Multimedia

Chapter 17: Automating Tasks with Macros

---

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.

---