Download Microsoft Excel for macOS 10.13 or later and enjoy it on your Mac. This application requires a qualifying Microsoft 365 subscription. Microsoft 365 includes premium Word, Excel, and PowerPoint apps, 1 TB cloud storage in OneDrive, advanced security, and more, all in one convenient subscription.
Excel 2016 Mac Basic Learn by doing—not watching—with interactive simulations. Excel for insightful spreadsheets – anytime, anywhere and with anyone. A modern take on Excel with new built-in tools help you get more out of your data. Create your best work with Microsoft 365.
This Excel tutorial explains how to open the Visual Basic Editor in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
You can access the VBA environment in Excel 2011 for Mac by opening the Visual Basic editor.
First, be sure that the Developer tab is visible in the toolbar in Excel.
The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form Controls like buttons, checkboxes, etc.
To display the Developer tab, click on Preferences under the Excel menu at the top of the screen.
When the Excel Preferences window appears, click on the Ribbon icon in the Sharing and Privacy section.
In the Customize section, check Developer in the list of tabs to show. Then click on the OK button.
Select the Developer tab from the toolbar at the top of the screen. Then click on the Editor option in the Visual Basic group.
Now the Microsoft Visual Basic editor should appear and you can view your VBA code.
I'm using an older Mac version of Excel. Is there a free Basic Skills book for earlier versions?
No. We only publish this Apple Mac title for the current Excel 2016 for Mac version.
We do publish books (including the free Basic Skills book) for the older Windows versions (Excel 2007, 2010 and 2013) along with comprehensive video courses for the same titles.
Which version of Excel was used to record these videos?
Word And Excel For Mac
Unlike Windows versions there is no schedule for the release of Excel versions for the Mac.
We update the Excel for Windows versions in January and July each year (when the Excel for Windows semi-annual update is published). At the same time we update the Mac courses to the latest version available at that time.
You will learn more about update channels in this book (Lesson 1‑3: Check that your Excel version is up to date).
Basic Excel For Mac
The free Basic Skills Excel for Apple Mac tutorial will get you started with Excel fundamentals. Even though it is a basic skills course you’ll still master many skills that professional Excel users are unable to use. Available entirely free as an e-book.
Microsoft Excel Macro-enabled Worksheet
Click here and the e-book will open straight away. Read the first two pages and you’ll immediately realize why millions of learners have found this free course so useful.
Free Excel For Mac
Also available for Excel 2007, Excel 2010, Excel 2013 and Excel 2016 for Windows.
Visual Basic Excel For Mac
Teaching a class? Order printed copies of this book at our not-for-profit printing cost price.