February has been another busy month for releases across our Office clients on Windows, Mac, iOS and Android. There are a number of exciting new capabilities in Outlook, Word, Excel and PowerPoint. In addition, we released the first cumulative feature update since the initial September release of the Office 2016 apps—otherwise known as the “Deferred Channel” build—for our commercial customers.
The Excel and Power BI teams are hosting a new conference designed specifically for you, the business analyst. The Microsoft Data Insights Summit will feature talks from leaders in the Excel community and successful analysts who will share their thoughts on trends in the industry, Excel and Power BI best practices and what it takes to succeed as an analyst in the modern workplace.
With the new Get & Transform capabilities in Excel 2016, you can now import, transform and combine data from different sources—thanks to the integrated Power Query technology in Excel. Today we are going to focus on one of the most useful capabilities that Get & Transform offers—the ability to use Unpivot to transform ANY table in your workbook to make it ready for powerful analysis using PivotTables and PivotCharts.