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

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

Data in the real world is messy, never available in the shape that users need in order to analyze it and gain insights. Business analysts spend a significant percentage of their time cleansing, transforming and preparing data before it can be analyzed or visualized in any meaningful way.

Some of the most common issues include:

  • Finding and accessing the data you need can be difficult.
  • Connecting to different data sources often requires different tools and query languages.
  • Data usually needs to be cleaned up and reshaped before performing meaningful analysis.
  • If the data gets updated, you have to repeat the process all over again.
  • Each data set may look different, making it hard to combine the data.

What if Excel could address these issues and allow you to complete all the data preparation tasks that used to take you days to just minutes? With the new Get & Transform capabilities, Excel 2016 provides a market-leading set of capabilities for discovering, connecting, reshaping and combining data. All of this can be seamlessly done via an interactive, easy-to-use, point-and-click user experience that allows any analyst to master their data.

Learn how to shape and transform data 1

Once you have done the work to prepare data from multiple sources, doing it again is as simple as a single button click. Excel keeps track of the transform steps you took, so when you click the Refresh button, up-to-date data is pulled in from the multiple sources and every transform step is replayed automatically.

Want to learn more?

Save the date to tune in for a free live stream of the Microsoft Data Insights Summit—Wednesday, March 22—as we walk through examples and tricks to fully take advantage of the Get & Transform capabilities in Excel 2016. Be prepared to learn everything you need to know about these new and revolutionary data preparation capabilities that will help you take your data analysis to the next level.

Learn how to shape and transform data 2

—Miguel Llopis, senior program manager specializing in data connectivity experiences in Excel and Power BI

  1. I plan on watching day 1, but day 2 is iffy at best for me due to my schedule. Will we be able to watch these later or is it strictly a live feed?

  2. It’s good to see this quite a strong set of capabilities in-built in the standard version of Excel!

  3. Since those of us running Office 2016 on a Mac unfortunately have to suffer with a “light” version of all the applications–can you provide a header on all your blogs showing WHICH version(s) of the product contains these fantastic new features? It’s bad enough being charged the penalty of the same price as a Windows user, but then to also find out that these neat, and in most cases necessary new features are only available on the Windows version. Without an explanatory header, it’s kind deceptive advertising. Thanks.

    • the advertising for O365Home and Personal for Windows is misleading too. Its advertised as full office 2016 apps when actually you don’t get fully installed Excel 2016 with the O365 subscription because you don’t get PowerPivot

  4. I’ve just read about this event, and would (like Ed) appreciate an update with a link to the recording please.

Comments are closed.