Microsoft just released a new update to Excel 2016 for Mac with two BIG new features: PivotCharts and a new VB Editor.
This is really great news for Mac users that want make use of these very popular Excel features.
The updates are currently included on a pre-release build of Excel 2016 for Mac. This version (16.6 or later) is available to everyone with an Office 365 subscription.
The video below explains how to join the free Office Insiders Program and get the pre-release builds. You will just need to download and install the latest Insiders Fast build. It's really easy!
Here is a link to the Release Notes for the Insiders Fast builds where you can read more about the version history and updates.
PivotCharts for Excel for Mac
Pivot Charts allow us to link charts to pivot tables to quickly create interactive reports and dashboards with slicers.
Checkout my article & video on the new Pivot Charts for Mac.
New VB Editor for Excel for Mac
The new VB Editor makes it possible to write and debug VBA macros in the Mac version to automate just about any Excel task.
Checkout my article & video on the new VB Editor for Mac.
The new build of Excel for Mac also includes some other notable features:
- IFS and SWITCH functions
- Slicers for Tables
- Modern chart types including Box & Whisker, funnel, histogram, Pareto, sunburst, treemap, and waterfall.
Help Microsoft with Feedback
As part of the Pre-release Program, Microsoft would love to get your feedback on how to make pivot charts better.
If you find any bugs or have any suggestions you can provide feedback by:
- Clicking the smiley face icon in the top-right corner of Excel.
- Click the “Tell Us What Can Be Better” option.
- Complete the form and hit Send.
The Excel development team will receive the feedback and use it to make Excel even better.
If you are excited about this update, please leave a comment below and let us know. Thank you! 🙂