Premium versions of Word, Excel, PowerPoint, Outlook, Publisher, and Access* OneNote: Access to additional OneNote features ( features vary ) For use on multiple PCs/Macs, tablets, and phones (including Windows, iOS, and Android). The VBA window in Mac is much less detailed than in Windows and I find it confusing. Make sure that in the left-hand pane you click on the appropriate drop down. VBAProject(WorkbookName) -> Microsoft Excel Objects -> Sheet2 and insert the Worksheet_Change function there.
Lesson 27: Free Resources for Learning Office for Mac
/en/excel-tips/how-to-add-line-breaks-in-excel/content/
Free resources for learning Office for Mac
Our Microsoft Office tutorials are some of the most popular courses we offer. These tutorials, however, are designed for those using Office on computers with Microsoft Windows, so perhaps it's no surprise that we frequently hear from learners who want to know why we don't offer tutorials on Officefor Mac. While Office for Mac shares a lot of functionality with the Windows version, its interface and design are different enough that we would need to create entirely new courses.
With our small staff, it would be a real challenge to produce the same kind of detailed tutorials for the Mac-friendly Office we provide for the Windows version. We may consider adding some type of Office for Mac tutorial in the future, but for now we'd like to share a number of excellent—and mostly free!—resources that can help you learn how to use Office for Mac.
Office 2016 for Mac is very similar to the Windows version. So if you have Office 2016 for Mac, check out our Office 2016 tutorial.
Free Office for Mac tutorials
If you're using Office for Mac, the Office for Mac team has provided great series of tutorials and how-to guides to help you get started and even learn advanced skills:
- If you're just getting started, check out the Office 2016 for Mac Quick Start Guides, which provide an overview of each Office for Mac product.
- If you're looking for even more, the Office for Mac Blog and YouTube channel provide the latest news and step-by-step videos to guide you through.
If you're using an earlier version of Office for Mac, check out the video below from the Office for Mac team on the Word 2011 Interface.
Of course, you can also find help on the Microsoft Office for Mac Support page from the Office community and support team. If you need additional support, you might consider purchasing a subscription to Lynda.com to take advantage of its thorough Office for Mac Tutorial. It's not free, but it's still a great resource if you need to learn the software quickly.
What if I use an older version of Office for Mac?
If you use Office 2008 for Mac, you should be aware that Microsoft discontinued support for this version in 2013. While this doesn't mean the programs will stop working, it does mean it will be more difficult to get help from Microsoft if something goes wrong.
If you're thinking of upgrading to the latest version of Office for Mac, you may want to consider purchasing a subscription to Office 365 instead of buying the stand-alone Office for Mac 2011 suite. A subscription includes a copy of Office for Mac on up to five computers, and you'll be able to upgrade to the latest version of Office for Mac when it becomes available. You can check out our What is Office 365? lesson to learn more.
/en/excel-tips/understanding-regional-differences-in-excel/content/
Today, we are announcing the general availability of Office 2019 for Windows and Mac. Office 2019 is the next on-premises version of Word, Excel, PowerPoint, Outlook, Project, Visio, Access, and Publisher.
Office 365 ProPlus, the cloud-connected version of Office, delivers the most productive and most secure Office experience—with the lowest total cost of ownership for deployment and management. However, for customers who aren’t ready for the cloud, Office 2019 provides new features and updates to the on-premises apps for both users and IT professionals. Like Windows Long Term Servicing Channel (LTSC) releases, Office 2019 provides a set of valuable enhancements for customers who can’t be cloud-connected or receive regular updates.
The new enhancements in Office 2019 are a subset of a long list of features that have been added to Office 365 ProPlus over the last three years. Office 2019 is a one-time release and won’t receive future feature updates. However, we’ll continue to add new features to Office 365 ProPlus monthly, including innovations in collaboration, artificial intelligence (AI), security, and more.
Office 2019 delivers features across apps to help users create amazing content in less time. In PowerPoint 2019, you can create cinematic presentations with new features like Morph and Zoom. And improved inking features across the apps in Windows—like the roaming pencil case, pressure sensitivity, and tilt effects—allow you to naturally create documents.
Excel 2019 adds powerful new data analysis features, including new formulas and charts and enhancements to PowerPivot.
Word 2019 and Outlook 2019 help you focus on what matters most. Learning Tools, like Read Aloud and Text Spacing, make it easier to engage with your content. Focus Mode blocks out distractions and puts your content front and center. And Focused Inbox moves less important emails out of the way—so you can get straight to taking care of business. For a longer list of the new features in Office 2019, see our FAQs.
Office 2019 also includes new IT value for enhanced security and streamlined administration. We introduced Click-to-Run (C2R), a modern deployment technology, in Office 2013, and it’s now used to deploy and update Office across hundreds of millions of devices worldwide. With Office 2019, we’re moving the on-premises versions of Office to C2R to reduce costs and improve security. The advantages of C2R include predictable monthly security updates, up-to-date apps on installation, reduced network consumption through Windows 10 download optimization technology, and an easy upgrade path to Office 365 ProPlus. C2R offers the same enterprise-focused management capabilities as Microsoft Installer (MSI) based products and will also support an in-place upgrade when you move to Office 2019 from older MSI-based products. To learn more, refer to the Office 2019 Click-to-Run FAQ.
The 2019 release of Office products also includes updates to our servers, and in the coming weeks, we will release Exchange Server 2019, Skype for Business Server 2019, SharePoint Server 2019, and Project Server 2019.
Office 2019 is a valuable update for customers who aren’t yet ready for the cloud. And each time we release a new on-premises version of Office, customers ask us if this will be our last. We’re pleased to confirm that we’re committed to another on-premises release in the future. While the cloud offers real benefits in productivity, security, and total cost of ownership, we recognize that each customer is at a different point in their adoption of cloud services. We see the on-premises version of Office as an important part of our commitment to give customers the flexibility they need to move to the cloud at their own pace.
Availability
- Commercial volume-licensed (trusted) customers can access Office 2019 starting today.
- Office 2019 is now available for consumer and commercial customers. For consumer customers in China, India, and Japan, Office 2019 suites will be available in the next few months.
- Certain features are only available in the Mac or Windows versions of Office 2019. For details, see the FAQ.