In the Office 2016 Public Preview, we have provided a set of new charts to give you innovative ways to explore data and tell rich stories across Excel, Word and PowerPoint. Say hello to Waterfall, Histogram, Pareto, Box & Whisker, Treemap and Sunburst—six powerful chart that help you quickly visualize common financial, statistical and hierarchical data in more intuitive ways. Made with Mac in mind, Office 2016 for Mac gives you access to your favorite Office applications - anywhere, anytime and with anyone. Includes new versions of Word, Excel, PowerPoint, Outlook, and OneNote. See what's new in Office 2016. Your school may offer Office 2016 for Mac for free. Search for your school below to claim this academic deal.
If you’re using Excel 2016, you get the luxury of using Excel’s new statistical charts. Statistical charts help calculate and visualize common statistical analyses without the need to engage in brain-busting calculations. This new chart type lets you essentially point and click your way into a histogram chart, leaving all the mathematical heavy lifting to Excel.
To create a histogram chart with the new statistical chart type, follow these steps:
- Start with a dataset that contains values for a unique group you want to bucket and count.For instance, the raw data table shown here contains unique sales reps and the number of units each has sold.
- Select your data, click the Statistical Charts icon found on the Insert tab and then select the Histogram chart from the drop-down menu that appears.
Note that you can also have Excel create a histogram with a cumulative percentage. This would output a histogram with a supplemental line showing the distribution of values.
Excel outputs a histogram chart based on the values in your source dataset. As you can see here, Excel attempts to derive the best configuration of bins based on your data.
Excel auto-generates a histogram based on its own derived bins.
You can always change the configuration of the bins if you’re not happy with what Excel has come up with. Simply right-click the x-axis and select Format Axis from the menu that appears. In the Axis Options section (see the following figure), you see a few settings that allow you to override Excel’s automatic bins:
- Bin width: Select this option to specify how big the range of each bin should be. For instance, if you were to set the bin width to 12, each bin would represent a range of 12 numbers. Excel would then plot as many 12-number bins as it needs to account for all the values in your source data.
- Number of bins: Select this option to specify the number of bins to show in the chart. All data will then be distributed across the bins so that each bin has approximately the same population.
- Overflow bin: Use this setting to define a threshold for creating bins. Any value above the number to set here will be placed into a kind of “all other” bin.
- Underflow bin: Use this setting to define a threshold for creating bins. Any value below the number to set here will be placed into a kind of “all other” bin.Configure the x-axis to override Excel’s default bins.
The next figure illustrates how the histogram would change when the following settings are applied:
- Number of bins: 10
- Overflow bin: 100
- Underflow bin: 10
Office for Mac that comes with an Office 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates. The following information is primarily intended for IT professionals that are deploying Office for Mac to the users in their organizations.
Note
- Starting with Version 16.21, Microsoft Teams will be installed by default for new installations if you're using the Office suite install package. For more information, see Microsoft Teams installations on a Mac.
- For security reason, Microsoft has deprecated the use of SHA-1. Learn more
- Starting with the 16.17 release in September 2018, this information also applies to Office 2019 for Mac, which is a version of Office for Mac that’s available as a one-time purchase from a retail store or through a volume licensing agreement.
- The update history information for version 16.16 and earlier also applies to Office 2016 for Mac, which is also a version of Office for Mac that’s available as a one-time purchase. Older versions up to and including 16.16 can be activated with an Office 2016 for Mac volume license. You can’t activate version 16.17 or later with an Office 2016 for Mac volume license. For information about Office 2016 for Mac releases from September onward, see Release notes for Office 2016 for Mac
- For information about the features, security updates, and non-security updates that are included in a given release of Office for Mac, see Release notes for Office for Mac.
- If you want early access to new releases, join the Office Insider program.
Most current packages for Office for Mac
The following table lists the most current packages for the Office suite and for the individual applications. The Office suite includes all the individual applications, such as Word, PowerPoint, and Excel. All packages are 64-bit only. The build date is listed in parentheses, in a YYMMDD format, after the version number. The install package is used if you don't have the application already installed, while the update package is used to update an existing installation.
To view release notes, see Release notes.
December 10, 2019
Version 16.32 (19120802)
Application | Download links | SHA-256 hash for install package |
---|---|---|
Office suite (with Teams) | Install package | 19035B8AFF8D385A1BB4EFE2C69D43D8D6D61BDBB27402666373DD30465C8096 |
Office suite (without Teams) | Install package | E7EE6030512017C6D2468DC5FEDC46F5E866F14BC9E8A452741B150F3DEF235B |
Word | Install package Update package | E3755FFE5AC3146F36810F666D1594059BD48C349026866972BCFF42580EA6FE |
Excel | Install package Update package | 05F79F9CB5364C8BACFC7162B0921351DE675AA0958CA16528D84AEBDE6A5231 |
PowerPoint | Install package Update package | 404A7017CF9B2E92A0D50CA32B33304ED84D83CF20EAF7F882520F4239AF1323 |
Outlook | Install package Update package | 094CADF90E8D6CF5D97A0E1D62E3E8D2C9491F467AFB4786A0D02E9183E8066E |
OneNote | Update package | Not applicable |
Most current packages for other Mac programs from Microsoft
The following table provides information about the most current packages, including a download link, for other Mac programs from Microsoft that may be of interest to IT professionals. The build date is listed in parentheses, in a YYMMDD format, after the version number.
Note: Microsoft AutoUpdate (MAU) release information has moved to the MAU Release History page.
Program | Version | Package | More information | SHA-1/ SHA-256 hash |
---|---|---|---|---|
Skype for Business | 16.27.37 | Download | The latest version was released on June 23, 2019. Latest updates | ac33fbfa83e304e1ac3ba7365e8bf307b117ec954fd48902991356ee86f2e836 |
Remote Desktop | 10.3.1 | Download | This install package is 64-bit. What's new | a846cecda7391b4e67c37b4b30a0c49ebd3c80f4782a989c0b4f866cd6d09339 |
Intune Company Portal | 1.17 (52.1908008.000) [190823] | Download | What's new in Microsoft Intune | fec704b5194360a48365d0193a46135358c5f129fc2b1fb02acb902cd1f96de0 |
Microsoft SharePoint On-Premises Safari Browser Plugin for Office 2016 for Mac | 15.32.0 (170309) | Download | This install package is 64-bit. | f7f29202881a319fb249d15ab6125b5a1a94b303c649cbe3fafb37ecd4728ed8 |
Release history for Office for Mac
The following table provides release history information and download links for Office for Mac. The table is ordered by release date, with the most recent release date listed first. The build date is listed in parentheses, in a YYMMDD format, after the version number. All releases after August 22, 2016 are 64-bit only. All releases prior to August 22, 2016 are 32-bit only.
Note
Download links are only provided for the most recent releases.
Release date | Version | Install package | Update packages |
---|---|---|---|
December 10, 2019 | 16.32 (19120802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
November 12, 2019 | 16.31 (19111002) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
October 15, 2019 | 16.30 (19101301) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
September 18, 2019 | 16.29.1 (19091700) | Word, Excel, PowerPoint | |
September 10, 2019 | 16.29 (19090802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
August 13, 2019 | 16.28 (19081202) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
July 16, 2019 | 16.27 (19071500) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
June 11, 2019 | 16.26 (19060901) | ||
May 14, 2019 | 16.25 (19051201) | ||
April 16, 2019 | 16.24 (19041401) | ||
March 27, 2019 | 16.23.1 (19032603) | ||
March 12, 2019 | 16.23.0 (19030902) | ||
February 20, 2019 | 16.22 (19022000) | ||
January 24, 2019 | 16.21 (19011700) | ||
January 16, 2019 | 16.21 (19011500) | ||
December 11, 2018 | 16.20 (18120801) | ||
November 13, 2018 | 16.19 (18110915) | ||
October 16, 2018 | 16.18 (18101400) | ||
September 11, 2018 | 16.17 (18090901) | ||
August 14, 2018 | 16.16 (18081201) | ||
July 10, 2018 | 16.15 (18070902) | ||
June 13, 2018 | 16.14.1 (18061302) | ||
June 12, 2018 | 16.14.0 (18061000) | ||
May 24, 2018 | 16.13.1 (18052304) | ||
May 23, 2018 | 16.13.1 (18052203) | ||
May 15, 2018 | 16.13.0 (18051301) | ||
April 11, 2018 | 16.12.0 (18041000) | ||
March 19, 2018 | 16.11.1 (18031900) | ||
March 13, 2018 | 16.11.0 (18031100) | ||
February 13, 2018 | 16.10.0 (18021001) | ||
January 26, 2018 | 16.9.1 (18012504) | ||
January 18, 2018 | 16.9.0 (18011602) | ||
December 12, 2017 | 15.41.0 (17120500) | ||
November 14, 2017 | 15.40.0 (17110800) | ||
October 10, 2017 | 15.39.0 (17101000) | ||
September 12, 2017 | 15.38.0 (17090200) | ||
August 15, 2017 | 15.37.0 (17081500) | ||
July 21, 2017 | 15.36.1 (17072101) | ||
July 11, 2017 | 15.36.0 (17070200) | ||
June 16, 2017 | 15.35.0 (17061600) | ||
June 13, 2017 | 15.35.0 (17061000) | ||
May 16, 2017 | 15.34.0 (17051500) | ||
April 11, 2017 | 15.33.0 (17040900) | ||
March 14, 2017 | 15.32.0 (17030901) | ||
February 16, 2017 | 15.31.0 (17021600) | ||
January 11, 2017 | 15.30.0 (17010700) | ||
December 15, 2016 | 15.29.1 (16121500) | ||
December 13, 2016 | 15.29.0 (16120900) | ||
November 17, 2016 | 15.28.0 (16111700) | ||
November 15, 2016 | 15.28.0 (16111501) | ||
November 15, 2016 | 15.28.0 (161113) | ||
October 11, 2016 | 15.27.0 (161010) | ||
September 16, 2016 | 15.26.1 (160916) | ||
September 13, 2016 | 15.26.0 (160910) | ||
August 26, 2016 | 15.25.1 (160826) | ||
August 22, 2016 | 15.25.0 (160817) | ||
August 22, 2016 | 15.25.0 (160818) | ||
July 12, 2016 | 15.24.0 (160709) | ||
June 25, 2016 | 15.23.2 (160624) | ||
June 18, 2016 | 15.23.1 (160617) | ||
June 14, 2016 | 15.23.0 (160611) | ||
May 13, 2016 | 15.22.1 (160512) | ||
May 10, 2016 | 15.22.0 (160506) | ||
April 12, 2016 | 15.21.1 (160411) | ||
March 16, 2016 | 15.20.0 (160315) | ||
February 16, 2016 | 15.19.1 (160212) | ||
January 12, 2016 | 15.18.0 (160109) |