Book Review – Excel 2016 All-In-One For Dummies

Hi, welcome to this week’s blog post. This post is going to be a little different from my normal blog posts. I’m doing a review on a book that I have on my desk at all times. The book in question is Excel 2016 all-in-one for dummies.  I have the 2013 edition of this book, and when the Excel 2016 edition was published, I was quick to order a copy.

The product description for this book describes it as 8 books in 1. The reason for this description is that the book is broken down into various subject matters including Excel basics and through to more advanced subjects such as VBA and Macros.

The format of the book allows the reader to build their knowledge as required, but also focus on topics that they might need more immediate help with.

This book mainly deals with desktop examples but also takes into account users of touchscreen Windows devices. While the book uses screen shots from Windows devices, the recent release of Excel 2016 for both Windows and Mac, has brought the user interface of both versions closer together than ever before. Personally, being a user of both Mac and Windows laptops I feel that users of both Mac and Windows devices will benefit equally.

The first section of this book is described as Excel basics.  This part of the book is really for the person who has never used Excel before.  It Introduces the reader to the Excel user interface, the ribbon, how to input data and how to navigate the user interface. This part of the book also explains how to customise the user interface, which even if you’re not a beginner will be useful.

The second section of this book deals with design basics for Worksheets. Covering topics such as formatting, editing, proofing and printing Worksheets.

The third section of the book will be of interest to a lot of Excel users as it deals with formulas and functions. Starting with the basics of building formulas and then expanding into more specific formula types such as logical, date, math, and text, etc.  This section also deals with the often overlooked subject of handling errors in formulas.

The fourth section of the book deals with collaboration. This subject is becoming more relevant in the connected world that we live in. There is a growth of geographically distributed teams and the need to share and collaborate efficiently. This is a skill that is only going to become increasingly important.

Section five of the book focuses on charts and graphics. The term “a picture is worth a thousand words” has perhaps never been more accurate than when dealing with large groups of data. The ability to select, use and format charts and graphics can really make your Excel workbooks standout.

The remaining sections of this book, six through to eight, deal with more advanced subject matters including Data Management, Data Analysis, Macros and VBA. This book gives a very good introduction to these subject matters and for a lot of users this might be enough to justify purchasing it. However, if you are already versed in these subject matters and looking to extend your knowledge then perhaps this isn’t the book for you.

In summary, this book serves as an excellent introduction and source of reference to many Excel topics. I personally refer to this book in my everyday work life and use it as one of my sources of reference when writing blog posts for Excel Itch. I would recommend this book as an invaluable resource for beginner to intermediate users of Excel.

If you’re interested in purchasing a copy of this book, then please click the link below to be taken to your local Amazon store. For purposes of clarity, if you choose to buy a copy of this book by clicking the link below, I will receive a small commission.

Excel 2016 All-in-One For Dummies


I hope you found this blog post useful. Please feel free to make comments, ask questions or provide feedback in the comments box below.

If you liked this post, please share it with your friends on Facebook.

Sign-up for our newsletter to keep up to date.