Learn Excel 2016 Expert Skills for Apple Mac with The Smart Method
Book and e-Book Tutorial
The book and e-book have identical content. Select any of the items below to preview the contents of this book.
Download an e-book
You can read our Kindle e-books on any modern device including PC, Mac, iPad, iPhone and Android …more
Buy a printed book
After the Essential Skills course you’ll be really, really good with Excel. If you want to join the tiny elite of power-users who can do absolutely everything with Excel you can take the Expert Skills course and become a true Excel guru.
By the end of this course your Excel skills will be greater and broader than almost all other Excel users in the workplace.
Also available for Excel 2019 for Mac.
Also available for Windows Excel versions: Excel 365, Excel 2019 and Excel 2016 as both printed books and e-books.
Teaching a class? Order 5+ printed books at wholesale price.
I purchased and am using Excel 2016 for Mac OS-X, Expert version. I am using a purchased version or MS Office 2016 for Mac(not 365) and it is updated as of a couple of days ago. My operating system is OSX 10.14.2 (Mojave). In lesson 6, where links between Word and Excel are discussed, I am getting different behavior than described in the workbook. In Lesson 6-3, when I link from the sample Word document to the table I constructed in Excel, the worksheet transfers perfectly from Excel to Word without the extra rows and columns. I used the Insert, Text, Object command. The book says that is not the case and shows extra lines and columns. In the next lesson I used the Insert-Text-Link to File command and, after getting a security warning and having to put in my computer password, I get just the data from the Excel Worksheet without any formatting. Double clicking on it does nothing. Has MS updated the Mac version such that the lesson 6-3 and 6-4 are no longer valid?
Although Microsoft officially only release updates to the 365 version of Excel, changes like this do occasionally find their way into the non-subscription version. The 2019 version of the Mac book does reflect this new change, so any new customers should find that their version of Excel matches what is shown in the book. If we issue a new edition of the 2016 for Mac book we will also incorporate this change, so thank you for letting us know.