Essential Excel 2016 A Step-by-Step Guide

✍ Scribed by David Slager

• Publisher: Apress
• Year: 2016
• Tongue: English
• Leaves: 684
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

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