Recent Posts

Events
Insights  FI

Learn new insights from leaders in the business analysts community

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.

Excel
Learn how to unpivot static tables in Excel 2016  FI

Learn how to unpivot static tables in Excel 2016

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.

Excel
Excel 2016 and Power Query  Nov update 1

30 feature updates to “Get & Transform” in Excel 2016 and Power Query add-in

This week we’re pleased to announce a new set of features for “Get & Transform” in Excel 2016 and the Power Query add-in for Excel 2013/2010. This update is packed with lots of new features that have been requested by many customers. We expect that you will find this update extremely useful.

Excel
8 tips and tricks you should know for Excel 2016 for Mac 2 - 1

8 tips and tricks you should know for Excel 2016 for Mac

Since the release of Excel 2016 for Mac, customers have given great feedback about its ease of use and the benefits of the new features. We want to highlight the Excel 2016 for Mac features that customers rave about and share some tips and tricks that could save you a ton of time using the most powerful spreadsheet and data analysis tool on the Mac platform.

Excel
New Featured Image

Time grouping enhancements in Excel 2016

Excel 2016 introduces new and efficient capabilities. PivotTables, both native and data model based, now support automatic time grouping, and PivotCharts include drill-down buttons. Today we will walk through all the new and cool options for building PivotTables with a Date/Time column and show how to surface time-based insights in your data.