Recently, we told you about the exciting new features and improvements in Excel 2016 that expand the business analytics capabilities available to you and your company. Today we will tell you about the changes we have made to help you get access to the features that fit your unique needs, including more Office plans that offer advanced analytics functionality.
This month’s Power Query update includes four new or improved features, including the option to specify Join Type in the Merge Queries dialog, the ability to extract first, last or range of characters from a Text column, the ability to customize the Quote Style in the Split Column by Delimiter dialog, and support for UPN credentials in the Exchange connector.
The response to last week’s release of Office 2016 for Mac has been amazing—thank you to all our customers! The post was one of the most read and shared Office Blog posts this year, receiving hundreds of great comments and questions. We thought it would be helpful to share answers to the top ones with you.
This month’s Power Query for Excel update is now available to you and is packed with lots of new features including improvements to the ODBC Connector and the Navigator dialog, the ability to download queries faster, expanded support for Salesforce Custom environments, and improvements to date and time parsing and the Unpivot column features.