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.

Office 365
Microsoft Office apps are ready for the iPad Pro 1

Microsoft Office apps are ready for the iPad Pro

Microsoft Office apps are ready for the iPad Pro. As we announced in September, we have optimized Word, Excel, PowerPoint, Outlook and OneNote apps for the iPad Pro. Starting today, these Office apps are now available and take full advantage of new multitasking features, so you can be productive on your iPad Pro right away.

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.