Mike Smart is the founder and CEO of The Smart Method. In Mike's long career as an IT consultant, Mike specified, designed and delivered IT solutions for large corporations all over the world. Learn Excel 2016 Expert Skills for Mac OS X with The Smart Method: Courseware Tutorial teaching Advanced Techniques Mar 08, 2016. By Mike Smart. This Excel 2016 for Mac book is for users who want to upgrade their basic Excel 2016 for Mac skills to true expert level. It will teach you to master all of the Excel 2016 for Mac advanced features. If you are an absolute beginner you need our Excel 2016 for Mac OS X Essential Skills book. Mike Smart’s revolutionary teaching method provides an entirely new, easier and better way to learn Excel 2016 for Mac. Here are just six of the many ways in which this e-book is unique.

When you use modern SaaS software (such as the subscription version of Excel 2016 and Windows 10), you must be prepared for things to constantly change from day-to-day as automatic updates are applied. Often a few new buttons will pop up here and there, new features will unexpectedly arrive, and features that used to be there will disappear (or move to another location). Office 2016 is available in both an SaaS and a perpetual licensed version. The SaaS version (Office 365) constantly changes in the same way as Windows 10. It is clearly not useful or efficient for learners to attempt to learn to use frequently updated SaaS software (such as Excel 365) using video tutorials. A video tutorial would not match what the user is seeing on their screen and the instructions would often be impossible to follow. This is one of the few disadvantages of the SaaS revolution.

In 2018 the carefully crafted written word has become more relevant and useful as a software teaching medium provided that it is constantly updated (as is the case with Smart Method paper and e-books). We produced for the earlier (pre SaaS) versions of Excel. Each course was based upon a Smart Method book and some have a run time of well over 20 hours. The Smart Method’s professionally produced video courses each took around six months to script, record and edit but that was fine as they had a lifetime of many years. For these (pre-SaaS versions) you can still if you wish to. I’m personally amazed that even the Excel 2007 video course is still finding buyers today – eleven years after I recorded it. Sales management software for mac. This is possible because anybody using Excel 2007, 2010 and 2013 today is using the very same version that was originally released (with only a few bug fix updates).

This means that the videos perfectly match what the user sees on their screen. After nearly three years of monthly updates, the Excel 2016 perpetual license version is now very different to Excel 2016 for Office 365 subscribers. Users are often confused because these products are both often referred to with the single name: Excel 2016. You can see some of the differences listed in. Our (in paper and e-book form) manage to support both versions. Differences are usually addressed within the text or in sidebars. Adding media in powerpoint 2011 for mac.

In some cases, we have had to provide alternative lessons, (one for each version) or brand new lessons to cover new Excel 365 only features. In late 2018 a perpetual licensed version of Excel 2019 will be released. At this time Excel 2016 for Office 365 subscribers will cease to exist.

Office 365 subscribers won’t even notice that a new perpetual version has been released as their Office version has received so many feature updates that they are already “nearly” using Office 2019. When Excel 2019 is released, there will be three Excel versions in common use that (I hope) will be generally referred to as Excel 2016, Excel 2019 and Excel 365. This will avoid confusion when discussing an Excel 365 new feature that does not exist in Excel 2019. Software that updates very frequently is bad for business productivity.

For this reason, business users of both Windows 10 and Microsoft Office 365 are protected from constant “version shock” and are only updated with new features every six months (using the semi-annual update channel). Office (and Windows 10) versions targeted at home users cannot use the semi-annual update channel and must use the monthly update channel. This means that they may receive feature updates every month (and bug-fix/security updates several times each month).

Software that uses the SaaS model creates new challenges for training and support. Here is The Smart Method’s strategy for supporting our Excel training materials: Excel 2016 users: After the release of Excel 2019 all Excel 2016 books and e-books will continue to be available as both paper and e-books. We’ll continue to fully support this version until at least Oct 2020 when Microsoft end mainstream support for this version. Excel 365 users: With the release of Office 2019, all Excel 2016 for Office 365 Subscribers users will automatically become Excel 365 subscribers. We’ll produce separate learning materials specifically for Excel 365 that will be updated with each semi-annual update. Excel 2019 perpetual license users: This version has not yet been released but is expected shortly. We will produce separate learning materials specifically for users of this Excel version.