Integrating Power Query technology in Excel 2016

Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We’re excited to let you know that your get-data experience in Excel is about to change forever. —Read on to learn about how Excel 2016 has integrated Power Query technology into the Data ribbon.

Office 365
Office updates for the iPad FI

Office updates for the iPad Pro, iOS 9 and WatchOS 2

Today Apple announced the iPad Pro, iOS 9 and WatchOS 2. We’ve developed a number of new features for Word, Excel, PowerPoint, OneNote, Outlook and Translator to take advantage of these enhancements. This post provides an overview of some of the most useful new features, including multitasking, inking, intelligent search, wireless keyboard support and updates to Outlook and Translator on the Apple Watch.

Customer stories
Tastea Logo

Office 365 gives Tastea the freedom to focus

Tastea—an innovative beverage retailer based in Orange County, California—wanted to prepare for expansion while maintaining high levels of quality and service. The company decided that a key to creating a repeatable customer experience across stores was to standardize operations while opening up clearer lines of communication. The company now relies on Office 365 for everything from inventory management to customer service.


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.