From the course: Excel: Creating a Basic Dashboard
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Use PivotTable data in a formula - Microsoft Excel Tutorial
From the course: Excel: Creating a Basic Dashboard
Use PivotTable data in a formula
- [Instructor] One of the benefits of summarizing data using a pivot table is that you can refer to a pivot table cell such as a subtotal or grand total in your dashboard. That way you get all the benefits of a pivot table with the compact data display of a dashboard. In this movie, I will show you how to link to a pivot table cell and also a cool trick that lets you display the data that you want from a pivot table by changing the value in one cell. My sample file is 0203 link to pivot and you can find it in the Chapter 2 folder of the exercise files collection. This workbook contains four worksheets and I'm already on dashboard where I've started creating a dashboard to summarize category revenue. On the pivot table worksheet I have a pivot table. And then on the data sheet, I have the data from which I created the pivot table. And you can see that I have three different categories, bath products, gift basket, and olive…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.