Essential Excel 2016
A Step-by-Step Guide

Authors: David Slager



Written by an Excel expert with many years of experience teaching people of all ages how to use Excel

Includes extensive workbooks and reader exercises with every chapter

Typical Excel users only use 10% of the functionality available in this software. Readers of this book will come away making much better use of the powerful tool at their fingertips

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

Table of contents (17 chapters)

Front Matter
Pages i-xxi

Becoming Acquainted with Excel
Pages 1-26

Navigating and Working with Worksheets
Pages 27-48

Best Ways to Enter and Edit Data
Pages 49-88

Formatting and Aligning Data
Pages 89-143

Different Ways of Viewing and Printing Your Workbook
Pages 145-172

Understanding Backstage
Pages 173-218

Creating and Using Formulas
Pages 219-264

Excel’s Pre-existing Functions
Pages 265-302

Auditing, Validating, and Protecting Your Data
Pages 303-341

Using Hyperlinks, Combining Text, and Working with the Status Bar
Pages 343-371

Transferring and Duplicating Data to Other Locations
Pages 373-409

Working with Tables
Pages 411-444

Working with Charts
Pages 445-501

Importing Data
Pages 503-539

Using PivotTables and PivotCharts
Pages 541-589

Enhancing Workbooks with Multimedia
Pages 591-641

Automating Task with Macros
Pages 643-664

Back Matter
Pages 665-673

下载地址：