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

March 10, 2017 0

Excel 2016 includes a powerful set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce two new data transformation and connectivity features that have been requested by our customers. —Read on for details.

The post March 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in appeared first on Office Blogs.

Read More

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

February 8, 2017 0

Excel 2016 includes a powerful set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce six new data transformation and connectivity features that have been requested by our customers. —Read on for details.

The post January 2017 updates for Get & Transform in Excel 2016 and the Power Query add-in appeared first on Office Blogs.

Read More

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

December 1, 2016 0

Excel 2016 includes a powerful new set of data import and shaping capabilities available under the Get & Transform section on the Data ribbon. Today, we are pleased to announce ten new data transformation and connectivity features that have been requested by our customers. —Read on for details.

The post November 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in appeared first on Office Blogs.

Read More

Merging intelligence with productivity—a demo tour of recent Office app updates

November 29, 2016 0

On today’s Microsoft Mechanics, we look at the latest in intelligent Office app experiences spanning PowerPoint, Excel, Word, Outlook and the browser. Ben Walters presents how Office can bring in intelligence via the Microsoft Graph, Azure Machine Learning and Delve to save you time.

The post Merging intelligence with productivity—a demo tour of recent Office app updates appeared first on Office Blogs.

Read More

New to Office 365 in November—new collaboration capabilities and more

November 29, 2016 0

This month, we’re announcing several updates to the Office apps to help you easily and effectively collaborate with others. This includes real-time co-authoring in PowerPoint, the ability to upload attachments to the cloud directly from Outlook and other collaboration capabilities. —Read on to learn more.

The post New to Office 365 in November—new collaboration capabilities and more appeared first on Office Blogs.

Read More

Copy/Paste Top n Visible Rows in Excel

November 27, 2016 0

I recently had a question regarding copying data after a filter had been
applied.  What if we wanted the top n items from a list to be copied to
another place.  The problem to address here is that a filtered list can
have cells which are hundreds or thousands of rows apart. Read More

1 2 3
Please wait...

Subscribe to ExcelMOOC posts

Want to be notified when our Excel article is published? Enter your email address and name below to know all new Excel features and cool tips