In this book, Collie and Singh cover Microsoft Power BI, Power Pivot, and Power Query. #4 Power Pivot and Power BI, by Rob Collie and Avichal Singh The book covers a lot of topics, and you will learn some of the Excel 2016 highlights, including: It will teach you how to organize data or information, create diagrams, and tables. This book is great for anyone, from a newbie to a veteran. #3 Excel: Quick Start Guide from Beginner to Expert, by William Fischer Using Excel 2016 on a desktop, laptop, or tablet.The Cloud: Save spreadsheets in the Cloud to access them from anywhere.Key learning in this MS Excel book includes: This Excel book also covers more advanced topics like hyperlinks to worksheets, adding worksheet data to a web page, and saving worksheets as web pages. This book serves as a real hands-on guide to learn how to create and edit worksheets, build formulas, format cells, design charts, construct graphs, data tables, and more. #2 Excel 2016 for Dummies, by Greg Harvey Creating Excel spreadsheets built for function and purpose.This book is 1,152 pages long! – so it’s a learn-at-your-own-pace and keep-for-reference guide. The Excel 2016 Bible is an extremely comprehensive book that will guide you through creating templates, formulas, pivot tables, data analysis, and more. List of Best Excel books #1 Excel 2016 Bible, by John Walkenbach This class builds on the basic Excel skills taught in our crash course.įor additional free Excel resources, please see our Excel Toolkit.

Once you’ve mastered that, we recommend our Advanced Excel Formulas Course to take your skills to the next level.

This course will walk you through a spreadsheet, step-by-step, so you can perform world-class financial analysis.

We always recommend additional reading to supplement the Excel training we provide at CFI.Īs a first step to learning Excel, we recommend taking our Free Excel Crash Course.

In this guide, we’ve compiled the best books and a quick synopsis of the main points they cover. For anyone looking to master the art of financial analysis in MS Excel, these are the most important Excel books to read.

Best training for excel 2016