Book description
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
- Cover
- Frontmatter
- 1. Becoming Acquainted with Excel
- 2. Navigating and Working with Worksheets
- 3. Best Ways to Enter and Edit Data
- 4. Formatting and Aligning Data
- 5. Different Ways of Viewing and Printing Your Workbook
- 6. Understanding Backstage
- 7. Creating and Using Formulas
- 8. Excel’s Pre-existing Functions
- 9. Auditing, Validating, and Protecting Your Data
- 10. Using Hyperlinks, Combining Text, and Working with the Status Bar
- 11. Transferring and Duplicating Data to Other Locations
- 12. Working with Tables
- 13. Working with Charts
- 14. Importing Data
- 15. Using PivotTables and PivotCharts
- 16. Enhancing Workbooks with Multimedia
- 17. Automating Task with Macros
- Backmatter
Product information
- Title: Essential Excel 2016: A Step-by-Step Guide
- Author(s):
- Release date: November 2016
- Publisher(s): Apress
- ISBN: 9781484221617
You might also like
book
Excel 2016 In Depth
This is the Rough Cut version of the printed book. Does your life play out in …
book
Excel 2016 For Dummies
Let your Excel skills sore to new heights with this bestselling guide Updated to reflect the …
book
Microsoft Excel 2016 Step by Step
Now in full color! The quick way to learn Microsoft Excel 2016! This is learning made …
book
MOS 2016 Study Guide for Microsoft Excel
Advance your everyday proficiency with Excel 2016. And earn the credential that proves it! Demonstrate your …