Get up to speed quickly with Microsoft Excel 2016. See how easy it is to create, edit, sort, analyze, summarize, and format data. A broad range of other topics are covered, such as data import and export, sharing, visualization, validation, security, customization, and more.
Loaded with screen shots, step-by-step instructions, and hands-on exercises, Essential Excel 2016 makes it easy for you to get started or ramp up your skills with this powerful software.
In this book, you learn easy and accurate methods for entering data plus how to
Organize, format, filter, and consolidate your data in almost any way imaginable
Use built-in functions and customize your own
Create amazing visualizations of your data
Extract just the information you want from imported data, and manipulate and format the data in the way you want
Export your results to other programs or share withothers in the cloud
Audit, validate, and protect your data
This book delivers the essential how-to and reference information for users new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to date on the latest changes and features in Excel 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 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