Excel’s July 2016 update add new Get & Transform and PowerQuery add-in features

2 min. read

Published onJuly 25, 2016

published onJuly 25, 2016

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

It’s that time of the month again forMicrosoft’s Excel 2016software. TheJuly updateincluded a list of features for its Power Query technology. To be specific, the Get & Transform has been tweaked with many new connectors and controls that enhance the ability to gather and organize data easier.

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

Last month, Excel 2016 saw major improvements built into thePivotTables. Users were able to take advantage of the faster OLAP servers thanks to caching improvements, increasing query efficiency and reducing the number of queries. The July update seems to continue building on that, empowering the ability of Power Query through the Get & Transform section on the Data ribbon.

All Office 365 subscribers can take full advantage of the update with their purchase. Likewise, users that have the older 2010 or 2013 Excel versions can download thePower Query add-in for Excel. The team’s blog went into even more detail for each of the new features today so make sure to check out the latest Office 365 blog post.

Radu Tyrsina

Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time).

For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web.

Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they’re looking for.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Radu Tyrsina

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Excel’s July 2016 update add new Get & Transform and PowerQuery add-in features#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Excel’s July 2016 update add new Get & Transform and PowerQuery add-in features