Excel tutorials

The only Excel books you will ever need

  • The only constantly updated Excel 365 titles more…
  • Thoroughly covers Power Pivot and Power Query more…
  • Covers business intelligence and OLAP features more…
  • Simple, easy, understandable, 2-page lessons more…
  • Available as both printed books and e-Books more…
  • Used by schools, colleges and universities  more…
  • Available for 365, 2021, 2019, 2016 and Mac versions more…

Learn Excel 2016 Basic Skills with The Smart Method

Free e-book with video lesson walkthroughs

Front Cover - Learn Excel 2016 Basic Skills with The Smart Method

Frequently Asked Questions

Excel 2016 is regularly updated via semi-annual updates. These often add features to Excel. We regularly update our videos to match the current Excel 2016 version. If you downloaded your e-book some time ago it is possible that your book is referencing an older release of Excel. You can download a fresh copy at any time from the free link above.

Yes. We publish a FREE Excel Basic skills e-book for all Excel versions in common use (including Apple Mac versions). You can download our other free Basic Skills e-books here:  Excel 2007Excel 2010Excel 2013 and Excel 2016 for Apple Mac.  

The January 2018 semi-annual update (version 1709). This version was also released to Semi-Annual (Targeted) channel on Sept 12, 2017 and to the Monthly Channel on Sept 18, 2017. You can learn more about update channels in the free Basic Skills book (Lesson 1‑2: Check that your Excel version is up to date).

The free Basic Skills Excel tutorial will get you started with Excel fundamentals. Even though it is a basic skills course you’ll still master many skills that professional Excel users are unable to use. Available entirely free as an e-book.

The Basic Skills course contains the first 43 lessons in the Essential Skills course and will take most users 5 hours or less to complete.

If you need Excel skills to get a job you may prefer to begin with our Essential Skills course (it includes all of the Basic Skills material and will take you to a higher level of proficiency, giving you all of the skills that an employer would expect).

Free Basic Skills books are also available for Excel 2007Excel 2010Excel 2013 and Excel 2016 for Apple Mac.  

Teaching a class? Order printed copies of this book at our not-for-profit printing cost price.

40 Free Video Walk-Throughs for use with the free e-book

Our FREE Excel 2016 basic skills book has 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.

You should download the free Basic Skills e-book (and print it if you wish) before viewing any of these walk-through videos.

Work through the lessons in the free Basic Skills e-book.  You should always try to complete each lesson using your book and only consult the video if you have difficulties completing the lesson, to identify where you are going wrong.  Each video shows one of our Excel consultants completing a lesson from your book.  

12 Responses

  1. I have been very impressed by the teaching I received by listening to Mike Smart for Excel 2010 both basic and essential. When I upgraded to Excel 2016 and began listening to the teaching of the Basics of Excel 2016, it went through the steps like it was going down a checklist, and usually just showed what it was doing instead of explaining. In the 2010 videos, Mike explained things so it was easy to understand…

    1. Hi Randy.

      Regarding your comments, I’ve written an article that explains why it isn’t possible to offer a useful video tutorial for Excel 2016 (in the way that I did for Excel 2007, 2010 and 2013). You can read it here:

      Why you can’t effectively learn Excel 2016/365 using a Video Tutorial.

      I’ve also added a link to this article to the page above in case any other reader has the same question.

      After reading the article you’ll understand why it isn’t possible to record an Excel 2016 Video Tutorial as a commercial product. Instead we’ve produced the Excel 2016 video walk-through videos and given them away for free in the hope that they will be useful to learners using the book/e-book (but only when they have difficulty completing a lesson). Originally they were silent but we had a request to add “text-to-voice” to help visually impaired users. You can mute your speaker if you find this irritating.

  2. When I click Download Sample Files, I get a message that says “Smart screen can’t be reached right now. Check your internet connection. Windows Defender smart screen is unreachable and can’t help you decide if this app is OK to run. It then gives me the option ti run or cancel. When i select RUN, nothing happens. This stops me in my tracks for the tutorial. This is for the Basic Skills 2016 book that does not have an ISBN#.

    1. Hi Stanley,

      Windows Defender is the built-in “anti virus” component of Windows. The message you’re getting seems to suggest that there is something wrong with Windows Defender on your computer so it is protecting you by refusing to run any downloaded programs.

      It’s probably possible to fix Windows Defender (it will probably fix itself when it updates), but in the meantime you should be able to get the sample files by downloading the alternative ZIP file option, which you can find here: https://thesmartmethod.com/sample-files-zip-version/

      ZIP files are not programs so they shouldn’t be blocked by Windows Defender. To extract the files from the ZIP file, right-click on it and click Extract All from the shortcut menu.

  3. Good afternoon
    When using “the navigation arrows or search box below to navigate to any of the thirty-eight free Excel 2010 Basic Skills video lessons in this course” the navigation buttons will not move you on from (2010 Essential Skills Lesson 01-05 Save a workbook 2m 32s) – the page reference changes but the video tutorials do not, so I am unable to access the remaining 32 free Excel 2010 Basic Skills video lessons.
    I thank you in anticipation, for looking into this

    KR Andrew Shaw

    1. Hi Andrew,
      I have tested the gallery using the latest versions of the Chrome, Edge and Firefox browsers and it seemed to be working correctly. If it isn’t working with your browser, I would suggest making sure that it has been fully updated and trying a different major web browser if it still isn’t working correctly.

      It’s also possible that you have a browser plugin (such as NoScript) that is preventing the gallery from working. If this is the case you may need to disable the plugin or configure it to allow the gallery’s scripts to run.

      Finally, there’s always the possibility that the problem was caused by a temporary outage on one of our servers. If this was the case it should have been resolved already and everything should now be working.

  4. I have windows 10 & am using Word 2013. Will Excel 2016 work with 2013? I understand that 2016 is the latest version of Excel. Am I wrong in assuming that using the latest version makes the most sense? I am interested in knowing the basics so that I can use Excel for personal use. But not for formula calculations.
    Rudy

    1. Hi Rudy,
      Ideally you should use the course that matches the version of Excel that you are using. If you are using Excel 2013, you should use one of our Excel 2013 courses.

      If you’re unsure about whether the course will work for you, you should start with the free Basic Skills course. You don’t need to pay or register to use this, you can download it and get started straight away. Basic Skills is available for all Excel versions in common use.

    1. Hi Mildred,
      All videos should have sound if you’re using them on this website (thesmartmethod.com). If you’re having audio problems you can find some advice on this page.

    1. Hi Amelmekky,

      We offer free video walkthroughs for Excel 2016. You can find them on this page. The videos are designed to be watched online and cannot be downloaded.

      The video walkthroughs aren’t intended to be used as a standalone video course, and are meant to be a supplement to the printed books or e-books.

Leave a Reply

Your email address will not be published. Required fields are marked *

Which tutorial do you need?