Skip main navigation

Importing Data from a Formatted Excel Report

Watch our lecturer Dany Hoter import data from a formatted Excel report.

In the previous activities, you looked at some common data sources you could use to import into your Excel data model.

Now you’ve been put in a much more limited scenario. Importing data directly from an Excel report is not the most efficient way to get data but if it’s your only option, it’s good to know that it’s possible.

This process will be different for each report you use depending on how it’s set up. Approach it as an iterative process, making changes and checking if you have the desired outcome. If so, move on to the next change and if not, just delete that step in the applied steps tab and try again.

Watch the video as many times as you need to understand the steps Dany followed. When you are ready, test your knowledge in the quiz and labs in the next steps.

Further Reading

To learn more on how to use Query to retrieve, shape and transform your data, check out the following resources:

Join the discussion

Can you think of other methods to get the data out of the report?
Use the Discussion section below and let us know your thoughts. Try to respond to at least one other post and once you’re happy with your contribution, click the Mark as complete button to move on to the next step.
This article is from the free online

Advanced Data Analysis and Visualization Using Microsoft Excel

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education