Essential Excel 2016: A Step-by-Step Guide

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

Table of Contents

Chapter 1: Becoming Acquainted with Excel
Chapter 2: Navigating and Working with Worksheets
Chapter 3: Best Ways to Enter and Edit 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 Task with Macros