Microsoft just released a new update to Excel 2016 for Mac with two BIG new features: PivotCharts and a new VB Editor.

Updates to Excel 2016 for Mac - PivotCharts and VBA 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!

Watch on YouTube and give it a thumbs up.YouTube Thumbs Up LikeYouTube Subscribe Logo Excel Campus

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.

Pivot Charts for Excel for Mac Video Thumb 480

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.

New VB Editor for Excel 2016 for Mac Video Thumb 480

Checkout my article & video on the new VB Editor for Mac.

Additional Updates

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.

For me, the VB Editor and PivotCharts are the real highlights, but it's awesome to see that Microsoft is making improvements to the Mac version of Excel!

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:

  1. Clicking the smiley face icon in the top-right corner of Excel.
  2. Click the “Tell Us What Can Be Better” option.
  3. 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! 🙂

Add comment

Your email address will not be published. Required fields are marked *

Search
Generic filters
Exact matches only
Filter by Custom Post Type

JOIN US & LEARN EXCEL

Learn 10 great Excel techniques that will wow your boss and make your co-workers say, "how did you do that??"
Plus weekly updates to help you learn Excel.

Download the eBook

About Me

Jon Acampora Profile

Hello and welcome! My name is Jon Acampora and I'm here to help you learn Excel.

This blog is updated frequently with Excel and VBA tutorials & tools to help improve your Excel skills and save time with your everyday tasks. Subscribe above to stay updated. More about me...

MVP_Horizontal_BlueOnly