Get & Transform in Excel 2016 and the Power Query Add-in Updates Released

September 2016 updates adds new data transformation and connectivity features. New build of Office Mobile for Windows 10 Insider Program version 17.7466.

Share online:

The Excel 2016 Get & Transform section on the Data ribbon which lets you access features based on Power Query technology today gets two new data transformation and connectivity features.

As part of an Office 365 subscription, these updates are an "Enhanced Web connector and an Enhanced CSV/Text connector."

The web connector update now allow users to specify a Command Timeout value from the connector UX dialog. In the Web connector, "users can switch between Basic and Advanced modes."

And, with enhanced CSV/Text connector users are now allowed to easily import data from Fixed-width delimited CSV and Text files. With this update, "users can now specify a list of positions to split by in the Preview dialog of the new CSV/Text import experience," wrties office team.

These features are now available to Office 365 subscribers, and can be downloaded manually as well from File -> Account -> Update Options -> Enable Updates -> Update now.

Excel 2010 or Excel 2013 users, can also take advantage of these updates by downloading the latest Power Query for Excel add-in here.

Enhanced Web connector specify Command Timeout via UX

A new Office for Windows 10 Mobile to the Insider Program version 17.7466 released with new features. To access these features, you need an Office 365 subscription.

The update is available for manual download through any Office Mobile app by going to File -> Feedback, tweeting to @OfficeInsider, or heading over to the Office Insider Community.

  • Chart Elements in Office Mobile apps Now you can add or remove chart elements like titles, data labels, or legends. This feature requires an O365 subscription.
  • Edit your charts in Word Mobile Change chart type, layout, color, or chart style all in Word Mobile.
  • Share an individual page with OneNote No need to share the whole notebook anymore. Send a viewing link to a single page of your choice and let others see it in a browser – no sign-in or app required. Currently available to limited number of Insiders.
  • Table shading available in OneNote Give your tables a makeover by adding colorful shadings to cells, rows, or columns and make your tables easier to read.

Share an individual page with OneNote

Recap of Project updates announced at Ignite 2016. Below you will find the videos that provide a great overview of the latest happenings in the Microsoft Project and Portfolio Management space.

Learn about the future of Microsoft PPM offer a view of modern intelligent Project and Portfolio Management, made possible through cloud based Microsoft PPM solution working seamlessly with various other Microsoft technologies such as Power BI, Internet of Things, bots and machine learning.

Also, a series of updates to the Project Online cloud service as well as the Project desktop client was announced, writes Microsoft.

Manage projects and portfolios in the cloud session featured several first-time demos such as support for sharing with external users, enhanced support for team tasks and multi-assignment, Project Desktop enhancements and our new Time Reporter apps.

Create powerful reports in Microsoft PPM is a deep dive into all the reporting capabilities of the Microsoft PPM solution. Alongside exciting improvements in Excel, Power BI and Cortana integration, this session also featured a first-time demo for PowerApps with Microsoft PPM solution to create engaging mobile experiences.

Satisfy custom needs with Microsoft PPM session features demos of building add-ins for Project Desktop and solutions for Project Online, as well as seamless integration with Microsoft Flow. Also, launched a new Project developer portal and Power BI content pack on GitHub.

Deploy and manage Microsoft PPM session provides wisdom about real-world considerations while deploying our PPM solution.

Establish a successful Project and Portfolio Management practice provide real stories from customers and partners about how Microsoft PPM solution addresses their business problems.