Let's start by downloading some data from the Internet. The goal in this section is to connect to an external data source, and import that data into Excel for further analysis.

We start this tutorial with a blank workbook. For guidance on enabling Power Pivot, click here. For more information on Excel 2013, click here. Also, tutorials use Excel 2013 with Power Pivot enabled. We suggest you go through each tutorial in order. This tutorial series uses data describing Olympic Medals, hosting countries, and various Olympic sporting events. The sections in this tutorial are the following:Ĭreate a relationship between imported dataĪt the end of this tutorial is a quiz you can take to test your learning.

In this tutorial, you start with a blank Excel workbook. Incorporate Internet Data, and Set Power View Report DefaultsĬreate Amazing Power View Reports - Part 1Ĭreate Amazing Power View Reports - Part 2 Import Data into Excel 2013, and Create a Data ModelĮxtend Data Model relationships using Excel, Power Pivot, and DAX The tutorials in this series are the following: In these tutorials you learn how to import and explore data in Excel, build and refine a data model using Power Pivot, and create interactive reports with Power View that you can publish, protect, and share. However, the same data modeling and Power Pivot features introduced in Excel 2013 also apply to Excel 2016. Note: This article describes data models in Excel 2013.

Mac excel 2013 data tools relationships