Helping business analysts take full advantage of Excel 2016 and the new Power BI

Excel 2016 and Power BI are a portfolio of tools that is unique in the industry. Together, they provide a broad set of capabilities that allow business analysts to more easily gather, shape, analyze and visually explore their data. —Read more for an overview of how these tools work together to solve your analytics needs.

Introducing the Office IT Pro Deployment Script project FI

Introducing the Office IT Pro Deployment Script project

Office 365 experts from around the world are contributing to a collection of PowerShell scripts that are designed to automate various procedures that would normally require manual intervention from an IT pro. If that sounds like you, check out our new community GitHub project for Office IT Pro Deployment Scripts.

Visualize statistics with Histogram Pareto and Box and Whisker charts FI

Visualize statistics with Histogram, Pareto and Box and Whisker charts

We introduced you to our new chart types across Office 2016 and dove deeper into a few of them. We showed the effectiveness of Waterfall charts in visualizing financial statements and how hierarchical charts show complicated data with multiple levels and categories. Now, we’ll take a closer look at the last set of chart types: statistical. —Read about Histogram, Pareto and Box and Whisker charts in Office 2016 for Windows.

4 updates in Power Query for Excel Aug  FI

4 updates in Power Query for Excel

This month’s Power Query update includes four new or improved features, including the option to specify Join Type in the Merge Queries dialog, the ability to extract first, last or range of characters from a Text column, the ability to customize the Quote Style in the Split Column by Delimiter dialog, and support for UPN credentials in the Exchange connector.

Preview real-time co-authoring on OneDrive  3

Preview real-time co-authoring on OneDrive

Earlier this year we announced real-time co-authoring support for Word 2016 as part of the Office 2016 Preview. For the last several months, this feature has been available to preview users co-authoring Word documents stored on SharePoint Online. Today, we are pleased to announce that real-time co-authoring is also available as a first-look for Word documents stored on OneDrive as part of the latest Office 2016 Preview release.

Office 365
cropped - white - Office Mobile apps for Windows 10 are here FI

Office Mobile apps for Windows 10 are here!

It’s a big day for Microsoft and we are excited to be part of it! Today, we’re pleased to announce the availability of the Office Mobile apps on Windows 10—bringing us one step closer to our vision of reinventing productivity. Customers can immediately download and install the apps from the new Windows Store in 190 countries.

Office 365
Office blogs Mac Top Questions FI

Your top 10 questions about Office 2016 for Mac answered

The response to last week’s release of Office 2016 for Mac has been amazing—thank you to all our customers! The post was one of the most read and shared Office Blog posts this year, receiving hundreds of great comments and questions. We thought it would be helpful to share answers to the top ones with you.