![]() Power Pivot in Microsoft Excel 2013 is an add-in you can use to perform powerful data analysis in Excel. I used the Manage option in PowerPivot to create a Data Model with relationships between the various tables: Here I have four tables called "Sales Team", "Products", Customers", and "Transactions": ![]() The versions that support this option are: As noted below, unless you have a version of Excel that supports PowerPivot, you will not be able to access and utilize this option. If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here and follow along. So let's take a look and see how to use Quick Explore in Excel. However, it will only work in certain versions. Quick Explore is a great tool from Excel that allows you to easily drill down into the details of your PivotTable by creating a modified PivotTable just for those details.
0 Comments
Leave a Reply. |