Learn the basics of Excel for Mac through HD video tutorials from. (51 reviews). Learn more about how a GoSkills Excel certification can boost your career.

Word for Mac Having started life on the Mac, Word already has very much the same features as on Windows (and much the same as Word 2011) – in fact Word for Mac 2016 keeps a feature lost in Word 2013. When you control-click on a misspelled word to correct it, you can choose AutoCorrect to have the same mistake fixed automatically in future, which saves an enormous amount of time.

(The same option is in the Excel spell check dialog, but again it was removed in Excel 2013.) When it was first released, that meant the changes in Word 2016 were mostly to the interface. The ribbon is now all but identical to the Windows version – instead of spraying tabs for SmartArt, Tables, Charts and Document Elements across your screen, Word for Mac now arranges those tools more logically into Insert, Design, Layout, Mailings and References (where they are in Word on Windows). You get the same drop-down galleries and context-sensitive extra tabs for editing and formatting objects, including some task panes for detailed settings like Format Text Effects (although there are still plenty of floating dialogs too). The new Smart Lookup feature is a neater version of a similar option in Word 2011. But again, since release, the monthly updates have been adding in more of the features previously only in the Windows version – in particular, Word now has the Selection Pane object browser from Windows. The Focus mode that hides everything except your document was originally missing in Word 2016 for the Mac; but it’s back, and now hides all the toolbars.

You can quickly insert a screenshot into a document. And Word now lets you use the same Add-ins as Word on Windows – everything from an emoji keyboard to plagiarism checkers. If you collaborate on documents and work with comments, you’ll be delighted to see that Word now supports threaded replies, making conversations much clearer.

If you do not have 'Send As' or 'Send On Behalf of' permissions for the account, email from the account will not be sent. Shared mailbox on outlook for mac.

In short, having started as a minor refresh back when this suite was first released last summer, Word for Mac is growing into a closer cousin of Word for Windows. Excel for Mac Like Word, Excel 2016 has an improved ribbon using the same tabs as Excel 2013, but the similarities are now deeper than just the interface. More importantly, Excel for Mac 2016 includes more of the functions and formulas that are in Excel for Windows (including the Analysis Toolpak for complex engineering and statistical analysis), and the improved Formula Builder is still easier to use than in Excel 2013. On Windows, it’s a pop-up dialog with a second dialog that helps you fill in the terms of a formula, but is usually on top of the cells you’re working with. On the Mac, it’s a task pane docked neatly out of the way with enough room to list the functions and explain them. Double click on a function and you get the fields to fill in – but you can still see your spreadsheet. The logical grouping here makes it easier for pros to find what they want compared to Apple’s rival app Numbers, as well.

Macros are still supported in Excel 2016, but unless you save your spreadsheet as a macro-enabled file the menu entries are all greyed out so you can’t make a new macro. There’s also a new equation editor (which will be familiar to Windows Excel users), which allows you to pick from common equations or build your own by dragging and dropping terms and functions. There are more functions in Excel to improve compatibility with spreadsheets on Windows – not all are supported but new functions are getting added in the monthly updates. Only power users are likely to do anything advanced enough to notice missing functions, but it’s good to see these getting added in, albeit gradually. The new pivot table slicers help you sift through large amounts of information – they’re visual controls you can add to a spreadsheet to make it easier to manipulate your view of the data. The quick analysis tool isn’t in Excel for Mac, but the Recommended Charts and Recommended Pivot Tables tools make it faster to do quick visualisations. And you still have all the conditional formatting, spark lines and other visual tools to help interpret your data.

Excel for Mac doesn’t have Power Query, but the future of those tools is to move into the cloud Power BI service – they’re already in the Power BI designer app for Windows but in the long-term they’ll move to the cloud interface, where Mac users will get access to them. You can also install the same Add-ins that work in Excel on Windows and iPad, giving you access to a far wider range of extra tools than Excel has had on the Mac before.