In Episode #1311, Bill shows us how to create a Pivot Table in Excel 2010, upload it and then [using the Excel Web Application] create a nice looking Dashboard on the web..."Pivot Table Data Crunching: Microsoft Excel 2010", by Bill Jelen
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Pivot Table Data Crunching, chapter 8 though, Excel Web App.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
We're going to save a couple of pivot tables up to the Excel web app.
But first I want to show you a really cool trick here.
I created this first pivot table, showing revenue by year and month and I tied it to these two slicers already inserted this slicers.
But then on the same sheet, I created a second pivot table and a pivot chart.
I need this pivot chart to respond to those some same slicers.
So, here's how we do that in pivot chart tools, go to the analyze tab.
You'll have the insert slicer, don't choose that.
Choose slicer connections, and say, hey I want this pivot chart to also be tied to market and region.
And now both the pivot table and the separate pivot chart, are tied to the same item.
All right! Now, I'm going to hide some extra sheets here.
Hide the sheet with the raw data and then save this out to the Skydrive.
So, I already did file, save and send.
Saved a web, sign into the Skydrive and created it out there and a folder called Public Read-only 08 Pt. Web app.
All right, so once we know that's been saved, we'll do file close.
We'll go out to the skydrive, now this is really cool, where they did this.
We're going to view this on the Skydrive not using edit in in the browser.
I just want to be able to see it in the browser and even here in the non edit mode if I would choose a couple of regions from the slicers, you'll see that the other slicer updates and then as I scroll down the pivot table updates and the pivot chart update.
So, all of this is happening in the browser, not in edit mode just in view mode.
Very cool that I can use those slicers even though, I'm only in read-only mode to update both the pivot table and the associated pivot chart.
This excel web app very, very cool feature.
You can't create new pivot tables here but you create the pivot table back in Excel 2010 on your desktop, and then upload it you can create some nice dashboards.
Really cool!
Hey! I want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel.
Pivot Table Data Crunching, chapter 8 though, Excel Web App.
Hey! Welcome back to the MrExcel netcast.
I'm Bill Jelen.
We're going to save a couple of pivot tables up to the Excel web app.
But first I want to show you a really cool trick here.
I created this first pivot table, showing revenue by year and month and I tied it to these two slicers already inserted this slicers.
But then on the same sheet, I created a second pivot table and a pivot chart.
I need this pivot chart to respond to those some same slicers.
So, here's how we do that in pivot chart tools, go to the analyze tab.
You'll have the insert slicer, don't choose that.
Choose slicer connections, and say, hey I want this pivot chart to also be tied to market and region.
And now both the pivot table and the separate pivot chart, are tied to the same item.
All right! Now, I'm going to hide some extra sheets here.
Hide the sheet with the raw data and then save this out to the Skydrive.
So, I already did file, save and send.
Saved a web, sign into the Skydrive and created it out there and a folder called Public Read-only 08 Pt. Web app.
All right, so once we know that's been saved, we'll do file close.
We'll go out to the skydrive, now this is really cool, where they did this.
We're going to view this on the Skydrive not using edit in in the browser.
I just want to be able to see it in the browser and even here in the non edit mode if I would choose a couple of regions from the slicers, you'll see that the other slicer updates and then as I scroll down the pivot table updates and the pivot chart update.
So, all of this is happening in the browser, not in edit mode just in view mode.
Very cool that I can use those slicers even though, I'm only in read-only mode to update both the pivot table and the associated pivot chart.
This excel web app very, very cool feature.
You can't create new pivot tables here but you create the pivot table back in Excel 2010 on your desktop, and then upload it you can create some nice dashboards.
Really cool!
Hey! I want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel.
