Table of Content

Chapter 1: Understanding the Microsoft Excel Interface

Chapter 2: Working with Workbooks and Templates

Chapter 3: Working with Sheets

Chapter 4: Getting Data onto a Sheet

Chapter 5: Selecting and Moving Data on a Sheet 

Chapter 6: Formatting Sheets and Cells 

Chapter 7: Advanced Formatting 

Chapter 8: Using Formulas

Chapter 9: Using Functions

Chapter 10: Sorting Data 

Chapter 11: Filtering and Consolidating Data

Chapter 12: Distributing and Printing a Workbook  

Chapter 13: Inserting Subtotals and Grouping Data

Chapter 14 :Creating Charts and Sparklines  

Chapter 15: Summarizing Data with PivotTables

Chapter 16: Inserting SmartArt, WordArt, and Pictures 

Chapter 17: Introducing the Excel Web App
 

Salient Features

• The perfect book for beginners who want to learn about Excel 2016
• Includes more than 100 hands-on tasks to get students up and running with Microsoft Excel 2016
• Each task is designed to teach the easiest, fastest or most direct way to accomplish common Excel tasks
• Full-color images to clearly demonstrate the tasks at hand
• Updates will be delivered to via a FREE Web Edition of this book, which can be accessed with any Internet connection"