Office for Mac adds Touch Bar support

At the Apple event earlier today, we announced that Office for Mac is adding Touch Bar support. We have a long history of working with Apple to support new form factors and devices, and—as you can see from the news this week—we’re continually evolving Office to take advantage of the latest and greatest hardware innovations across the industry. Through the Touch Bar, Office intelligently puts the most common commands at your fingertips—all based on what you’re doing in the document. Here’s a quick summary of what we announced in Cupertino this morning.

Word

Now from the Touch Bar you can enter Word Focus Mode, a brand-new experience that hides all of the on-screen ribbons and commands so you can simply focus on your work. The Touch Bar is perfect for this moment, putting the most relevant Word features at your fingertips. One tap and you can quickly apply a new style to a heading or paragraph.

It’s been an exciting week—and a particularly rewarding two days for us here on the Office team. As you can imagine, there’s a lot of work that goes on behind the scenes to bring these ideas to life, and it’s a thrill to finally show you what we’ve been up to. From the announcements we made with the Windows and Surface teams on Wednesday—including Ink Editor, Ink Replay, digital ruler, Segment Eraser, support for 3D models and integrations with the Surface Studio and Surface Dial—to the Touch Bar integration we unveiled with Apple this morning, we’re working hard to take advantage of the very latest in hardware and software innovation from across the industry.

November 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

Today, we are pleased to announce 10 new data transformation and connectivity features that have been requested by customers.

These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can take advantage of these updates by downloading the latest Power Query for Excel add-in.

Updates include the following new or improved data connectivity and transformation features:

  • Web Connector—UX support for specifying HTTP Request Headers.
  • OData Connector—support for “Select Related Tables” option.
  • Oracle Connector—improved Navigator preview performance.
  • SAP HANA Connector—enhancements to parameter input UX.
  • Query Dependencies view from Query Editor.
  • Query Editor ribbon support for scalar values.
  • Add custom column based on function invocation.
  • Expand & Aggregate columns provide support for “Load More” values.
  • Convert table column to a list—new transformation.
  • Select as you type in drop-down menus.

Web Connector—UX support for specifying HTTP Request Headers

With this update, we have added support for specifying HTTP Request Headers within the Web connector dialog. Users can specify header name/value pairs from the Advanced mode in this dialog.

OData Connector—support for “Select Related Tables” option

In this update, we have added relationship detection support for OData V4 feeds. When connecting to OData V4 feeds, users will be able to use the Select Related Tables button in the Navigator dialog to help you easily select all the tables needed for your reports.

Oracle Connector—improved Navigator preview performance

We significantly improved the performance for previewing tables in the Navigator dialog when connecting to Oracle databases. In most cases, previews should take up to 30 percent less time to display than before.

SAP HANA Connector—enhancements to parameter input UX

We made enhancements to the parameter input controls within the Navigator dialog when connecting to SAP HANA. These enhancements include:

  • For single-selection parameters:
    • Support for typing values, in addition to selecting values from the drop-down list.
    • Member ID and Member Caption are now exposed within the drop-down list.
  • For multi-selection parameters:
    • Member ID and Member Caption are now exposed within the drop-down list.
    • Users can leverage the Search box to search across both Member ID and Member Caption fields.

Query Dependencies view from Query Editor

One of the most popular requests in the Data preparation area for the past several months has been having the ability to easily understand dependencies across all queries in a given workbook. In this month’s release, we added a Query Dependencies view in the Query Editor (under the View tab on the ribbon) that allows users to see all queries and dependencies on other queries or data sources at a glance—as well as an indicator of their Load status.

How do I get started?

Excel 2016 provides a powerful set of capabilities for fast, easy data gathering and shaping, which is available under the Get & Transform section on the Data ribbon. Updates outlined in this blog are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can also take advantage of these updates by downloading the latest Power Query for Excel add-in.