Excel 0 Shares

April 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Excel 2016 includes a powerful new set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Today, we are pleased to announce two updates to this powerful feature set.

Read more April 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in
Excel 0 Shares

Excel Online—what’s new in March 2016

We are pleased to announce several updates for Excel Online that help you with some of your most common spreadsheet tasks, including new ways to format data, use hyperlinks in your spreadsheet and explore data using PivotTables.

Read more Excel Online—what’s new in March 2016
Excel 0 Shares

Learn how to shape and transform data with unprecedented ease in Excel 2016

With the new Get & Transform capabilities, Excel 2016 provides a market-leading set of capabilities for discovering, connecting, reshaping and combining data.

Read more Learn how to shape and transform data with unprecedented ease in Excel 2016
Excel 0 Shares

New feature updates for Power Pivot in Excel 2016

We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and improvements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.

Read more New feature updates for Power Pivot in Excel 2016
Excel 0 Shares

Data Insights Summit—free online Excel and Power BI sessions

The Microsoft Data Insights Summit, the inaugural Power BI and Excel user conference, lets you participate virtually—your device is your free pass to the two-day event. —Read on for more details.

Read more Data Insights Summit—free online Excel and Power BI sessions
Excel 0 Shares

March 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Excel 2016 includes a powerful new set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Today, we are pleased to announce another update to the powerful feature set.

Read more March 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in
Excel 0 Shares

6 new Excel functions that simplify your formula editing experience

The Excel team is happy to announce six new functions that simplify some of your common calculations and help you avoid the tedious work of building your own custom functions to accomplish the same tasks.

Read more 6 new Excel functions that simplify your formula editing experience
Excel 0 Shares

3 ways to drive business decisions using the new Excel 2016 charts

New Excel 2016 charts speed up your analysis and expand the ways to deliver business insights.

Read more 3 ways to drive business decisions using the new Excel 2016 charts
Excel 0 Shares

Share your Excel insights with Power BI

Sharing key Excel insights just got easier. You can now pin Excel tables, charts and more to your online Power BI dashboards to fully embrace Excel within the Power BI experience.

Read more Share your Excel insights with Power BI
Excel 0 Shares

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.

Read more Learn new insights from leaders in the business analysts community
Excel 0 Shares

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.

Read more Learn how to unpivot static tables in Excel 2016
Excel 0 Shares

Excel goes to camp

ModelOff Global Training Camp is a world-class technical training development program for the next generation business leaders, where campers hone their skills in advanced Excel features, business and financial analysis, financial modeling, infrastructure, investment management, private equity and risk intelligence.

Read more Excel goes to camp