Learn Excel 2016 Essential Skills with The Smart Method​

Book, e-Book and Video Tutorial

The book and e-book have identical content. Select any of the items below to preview the contents of this book.

ISBN: 978-1909253087

If you need Excel skills to get a job you should begin with this course (it also includes all of the Basic Skills material).

Even if you’ve never used Excel before you’ll have no difficulty completing this course,  most learners can complete it in two days or less. 

This course will give you all the skills an employer would expect. By the end of the Essential Skills course your Excel skills will be better than most office workers.

Also available for Excel 2007, Excel 2010, Excel 2013 and Excel 2016 for Apple Mac as both printed books and e-books.

Teaching a class? Order 5+ printed books at wholesale price.

138 Free Video Walkthroughs for book owners

Our Excel 2016 books/e-books have a free video walk-through for every lesson

It is important to realize that the videos are not useful as a learning resource on their own.  This is because it isn’t possible to learn Excel 2016 from a video tutorial for the reasons explained in this article:  Why you can’t effectively learn Excel 2016/365 using a Video Tutorial.

Smart Method books are the only books that have a free video walk-through for every lesson that can be viewed online. If you have difficulty completing a lesson in the book (or e-book) you can watch the corresponding video walk-through to identify where you are going wrong. Each video shows one of our Excel consultants completing a lesson from your book.  You should always try to complete each lesson using your book and only consult the video if you have difficulties completing the lesson. 

4 thoughts on “Learn Excel 2016 Essential Skills with The Smart Method”

  1. Timothy Cleary

    The opening exercises 1 – 3 do not match the Excel Spreadsheets – The exercise for Inventory-1 only works if you convert the data to a data table!

    1. All of the sample files have been thoroughly tested and should always match what is shown in the books.

      This page refers to the 2016 Essential Skills course, but your question refers to Lesson 1-3 of our 2016 Expert Skills course, so the most likely explanation is that you have downloaded the wrong sample file set. You can find the sample files for 2016 Expert Skills on the 2016 Expert Skills page.

      Lesson 1-3 does not require the data to be placed inside a Table in order to work. Using the Data > Sort & Filter > Filter option will work as shown in the lesson. If this isn’t working for you, the most likely explanation is that you are not using Excel 2016. This course was designed entirely for Excel 2016 so if you are using an older version there are likely to be differences. We also offer courses for Excel 2013, Excel 2010 and Excel 2007, but if you have an older version than Excel 2007 you should upgrade to a more recent version before using our courses.

  2. Hello, I have bought two books: Excel 2016 Essential Skills and Excel 2016 Expert Skills, but I can’t find the excercise file, where I could donwload the exercise file?

Leave a Comment

Your email address will not be published.