Skip to main content

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

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

You may also like these articles

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…

Image for: Surface Pro X and Surface Arc Mouse inside on desk with Excel and search on screen.

Connect to your own data with more new data types in Excel

The evolution of Excel Excel is the ultimate decision-making tool. We’re amazed every day by the ways in which you, our customers, use Excel to make better decisions, leveraging the flexibility of the 2D grid and formulas to capture, analyze and collaborate on data. Up to this point, Excel has only had a couple base…

Image for: A woman sitting on a couch using her PC laptop.

Introducing Money in Excel, an easier way to manage your finances

Today, with the launch of Money in Excel, we are embarking on a journey to simplify your day-to-day money decisions to help you stay on track of your longer-term financial goals.