Office on Android Gets New Cloud Storages, Excel 2016 Get & Transform November 2016 Updates

November 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in, Cloud storage for Office on Android.

Share online:

The Cloud Storage Partner Program (CSPP) for the Office apps on Android devices, ensures that users can easily add cloud storage providers in Word, Excel and PowerPoint.

Available cloud storage options in Office for Android now include "Dropbox, Box, Egnyte and Tencent." While, Citrix ShareFile, Edmodo and Learnium will be added soon, Microsoft said, adding, "the list will continue to expand over time."

You can add a cloud storage via the Add a place menu in the latest Word, Excel and PowerPoint on Android. Once done, you can start editing and sharing documents stored with that provider as well you can launch Word, Excel or PowerPoint directly from the cloud storage provider's app to edit your files, with changes automatically saved back to the cloud.

The CSPP was previously available for Office on iOS and Office Online.

New cloud storage options for Office on Android

New cloud storage options for Office on Android

Excel 2016 includes a powerful new data transformation and connectivity set of features as part of an Office 365 subscription November 2016 update release.

Based on the Power Query technology, Excel 2016 provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon.

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

  • Web Connector—UX 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.
  • Oracle Connector—improved Navigator preview performance.
  • SAP HANA Connector—enhancements to parameter input UX.
  • Query Dependencies view from Query Editor (under the View tab on the ribbon) 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.
  • Query Editor ribbon support for scalar values—includes new Contextual Ribbon tabs that expose common transformations for Text, Date/Time and Number values.
  • Add custom column based on function invocation—enabling invoking a custom function over a table. Users can now simply leverage the new Invoke Custom Function operation from the Add Column tab on the ribbon.
  • Expand & Aggregate columns provide support for "Load More" values-to the Expand & Aggregate columns list in Query Editor so that users can tell Excel to look at more rows to detect additional nested fields/columns.
  • Convert table column to a list—new transformation—Simply select the column in the Query Editor Preview and use the newly added Convert to List button in the Transform tab on the ribbon.
  • Select as you type in drop-down menus, allows users to type one or more characters and these will get matched with the prefix of drop-down menu items.
Excell 2016 November Update: Select as you type in drop-down menus

Excell 2016 November Update: Select as you type in drop-down menus

Over the past year, the OneNote Team has steadily pushed out new features and improvements, including over 36 new features for education. An overview of those new features, with links to relevant announcements and coverage by the OneNote community, is shared on the Microsoft in Education blog.

Among the features: You can add special Ink Effects to your pages, such as the popular Rainbow Ink (Office 365 accounts only); clip YouTube and Vimeo videos directly, allowing for instant in-page playback; easily clip PDF documents; in the OneNote Staff Notebook, create a section group that's accessible only for Staff Leaders, just like the Teacher-only Space in Class Notebooks.

OneNote New Features and Improvements

OneNote New Features and Improvements

Finally, tune in to the latest Office 365 Developer Podcast with Richard and Andrew.

According to Proofpoint, business email continues to be the primary security threat vector employees face—specifically, malicious email attachments and both common (e.g., spam and viruses) and sophisticated (e.g., spear phishing and ransomware) threats. See the two inforgaphics below:

Birth and Rebirth of Data Breach.Source: verizon 2016 report

Birth and Rebirth of Data Breach.Source: verizon 2016 report

Suspicious emails and attachments go through multiple security checkpoints before making it to a user's inbox.

Suspicious emails and attachments go through multiple security checkpoints before making it to a user's inbox

About The Author

Deepak Gupta is a IT & Web Consultant. He is the founder and CEO of diTii.com & DIT Technologies, where he's engaged in providing Technology Consultancy, Design and Development of Desktop, Web and Mobile applications using various tools and softwares. Sign-up for the Email for daily updates. Google+ Profile.