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, 2019, 2016 and Mac versions more…

Learn Excel 2019 Essential Skills with The Smart Method

Book or e-Book 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

Download an e-book

You can read our PDF e-books on any modern device including PC, Mac, iPad, iPhone and Android.

This e-book is beautifully crafted with a clickable table of contents.  You can also search the entire text by keyword.  

Buy a printed book

The retailers listed below always have our books in stock , all of the time, for immediate dispatch.

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 365,  Excel 2016,  Excel 2016 for Apple Mac and Excel 2019 for Apple Mac as both printed books and e-books.

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

4 Responses

  1. Will you ever have videos regarding these? I saw your comments on why the earlier versions were not effective now on video?

    1. Just like Windows 10 and many other modern software products, Excel is now a rapidly evolving product. While you can still buy the “pay once use forever” version of Office (Office 2019), our research suggests that most users now purchase a low-cost subscription to Office 365. Just like Windows 10 there is a major new semi-annual release of Office 365 in January and July every year (though Excel 2019 users will be forever limited to the features that were available in late 2018). The July 2019 Excel 365 update will be a big one with major changes to look-and-feel as well as some stunning new features (creating a major rift between Excel 365 and Excel 2019). For this reason we produce both Excel 2019 and Excel 365 books. The Excel 365 book has a new edition published every six months (to match latest semi-annual Excel 365 version) in January and July each year (we are the only publisher that does this). Of course, video lessons that are always out of date (and show screens and features that are different to those on the student’s computer screen) would hinder rather than assist the learning process and it would be impractical for us to re-make over 40 hours of video lessons every six months (our older video courses took at least six months just to record and edit). Having said this our old courses for Excel 2007, 2010 and 2013 remain useful for these (now retired) versions. As you have mentioned, there is an article that discussed this subject more fully here.

  2. Hi!
    My name is Alba Breen
    I bought The Smart Method 2019 for Mac, and I’ve been a little frustrated with the Lesson 2 – 7 Number 4 ( Select the same non-contiguous range with the Keyboard). It is not working:( . Also every time I click Fn, F8, and Fn, F8, Shift key, the iTunes app comes to the screen.
    I have a Mac 2019 computer.

    Hope have some help.

    1. Hi Alba,

      The F8 key launches iTunes by default. Holding down the Fn key before you press F8 should prevent this and allow the F8 key to work as the ‘standard’ function key that is expected by Excel. Make sure you are holding down Fn before pressing F8, rather than just pressing the keys in sequence.

      If you’re definitely holding down the keys correctly, it’s possible that this his being caused by an ‘fn lock’ of some sort. Some keyboards have an ‘Fn lock’ feature that will reverse the behaviour of the fn key. If a feature like this is enabled you should be able to just press the F8 key alone without holding down Fn.

      I hope this helps and you’re able to complete the lesson.

Leave a Reply

Your email address will not be published.

Which tutorial do you need?