Excel 2016 Get & Transform, Power Query Add-in Improvements; Panorama in Windoes Camera

August 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in. Panorama mode now available to use with Windows Camera app for Windows 10 PCs and phones.

Share online:

Today, eight new data transformation and connectivity features based on Power Query technology are available as part of an Office 365 subscription.

In addition, those who have Excel 2010 or Excel 2013, can also get these updates with the latest Power Query for Excel add-in. While, Office 365 subscriber, will get them automatically as they are rolled out.

If you are new, "Excel 2016 includes a powerful new set of features based on 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."

Here is what is new or improved data connectivity and transformation features that comes to Excel 2016 (from the team post):

  • "Enhanced SAP HANA connector—allow multi-select of values for variables and parameters.
  • Enhanced OData connector—option to import Open Type columns from OData feeds.
  • Enhanced Access DB connector—new Select Related Tables button to "" in the Navigator dialog.
  • Option to generate Step Names in English within the Query Editor.
  • Description for Query Steps within the Query Editor.
  • Extract Week, Day or Month name from a Date/Time column from the Query Editor.
  • Merge Dates and Times into a Date/Time column from the Query Editor.
  • Extract Start/End of Hour from a Date/Time or Time column from the Query Editor," the team reported.

Those who are new to Excel 2016, here is how to manually get the updates:

  1. Open any Office 2016 application, such as Word 2016 or Excel 2016, and create a new document.
  2. Choose File in the top left corner, and then choose Account from the list on the left (or Office Account if you opened Outlook 2016).
  3. Under Product Information, choose Update Options.
  4. Choose Enable Updates if the option is available and then choose Update Options again. If Enable Updates isn't available, automatic updates are enabled and you can go to the next step.
  5. Click Enable Updates
    Choose Update Now to manually check for and install Office updates.
  6. Manually checking for Office updates in Word 2016
    Close the "You're up to date!" window after Office is done checking for and installing updates.

Excel 2016 and Office 365 enabling updates

Office 365 and Excel 2016 office updates

Aside, Panorama mode is now available to use with the Camera app for Windows 10 PCs, tablets, and phones.

The redesigned Camera app is faster and simpler than ever.

Panorama is great for capturing sweeping landscapes or extra-wide family reunion photos.

To take a panorama, switch into the panorama mode by tapping the panorama button in the Camera app. Tap it again to start capturing, and then, starting from the left side of your subject, rotate the device slowly from left to right across the scene.

On any PC, tablet or phone:

  • Automatically back up your pictures so you can get to them on all your devices via OneDrive.
  • Jump into the picture by using the self-timer.
  • Compose the perfect shot using the framing grid.
  • Set the camera to capture either a rapid burst of shots or a video when you press and hold the on-screen shutter button.
  • For pro controls, drag the shutter button toward the center and adjust the dials for brightness and more.

On select phones and tablets:

  • Transform your static photos into living images that move, then play them back in the Photos app on any Windows 10 device. *(4,5,6)
  • Shoot smoother videos, even if your hands shake, using digital video stabilization. *(2, 3, 4)
  • Instantly launch the camera even when the phone is locked, by holding down the phone's hardware camera button. *1
  • Rich capture automatically snaps HDR (High Dynamic Range)*(2,3) and Dynamic Flash images, so you can shoot first and adjust lighting and other settings later. *(4,5,6)
  • Motion blur is automatically reduced, for sharper, more detailed photos. *6
  • Record stunningly smooth slow-motion videos at 120fps at 720p resolution. *(5,6)
  • With 4K video recording, save high-quality photos from your videos. *(5,6)
  • Digital negative files (DNG or raw files) preserve every detail, so advanced photographers can fine-tune their images with advanced editing software. *(4,5,6)

Get the new Windows Camera app at Windows Store.

Panorama mode in Windows Camera app for Windows 10