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.
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.
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.
This month’s Power Query for Excel update is now available to you and is packed with lots of new features including improvements to the ODBC Connector and the Navigator dialog, the ability to download queries faster, expanded support for Salesforce Custom environments, and improvements to date and time parsing and the Unpivot column features.
Today we are taking a big step forward for Mac users—Office 2016 for Mac is now available in 139 countries and 16 languages. Based on feedback from the great Mac Office community, we’ve made major updates to each of the apps, and we couldn’t be more pleased to deliver it first to our Office 365 customers.
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.
On this week’s show, we invite Michael Tejedor back to give us an update on Power BI. Michael shares news about new and upcoming content packs – allowing you to connect and gain insights into data from popular cloud services – and he demonstrates the new push APIs to allow Power BI to display real-time data from IoT devices.