Mastering Excel 2016 with Assignments and Case Studies is the most comprehensive yet easy to use Excel book on the market. It comes with a full set of data files for exercises, case studies and solutions. This is the Excel 2016 bible that includes everything you need to know to become an Excel 2016 expert.

Go ahead and buy this book. If you don’t like it, you can always return it within 7 days to get full refund from Amazon.

It is written for Excel 2016 but also points out important differences from Excel 2013. So whether you use Excel 2016 or Excel 2013, this book is all you need.

It explains everything you need to learn, from basics to advanced features like PivotTable, Charts, Sparklines, Macros and Workbook management. But the most unique feature of this book is the use of exercises and case studies to illustrate how to use Excel 2016 formulas, functions and features.

With this book, your Excel skills will go from starter to expert in just 30 days. Whether you want to learn Excel for college or work, this is the book you want.

This book has been used by thousands of people taking our online Excel course that is licensed to multiple higher education providers.

You will learn the following topics in depth:

Working with Workbook and Worksheets

Excel Tables

Data Management

Excel Formulas & Functions – Date, Financial, Information, Mathematical & Statistical and Text

Inserting and Formatting Objects

Lookup and Reference Functions

Charts, 3D Map and Sparklines

PivotTable

What If Analysis, Data Analysis and Validation

Printing Excel Files

Macros

Managing Excel Files

The book also includes a comprehensive list of Excel Keyboard Shortcuts to help you work faster.

At the end of the book, there are links to download the data files and cases studies.