Pivot Table Data Crunching 8 - Excel Web App

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Jul 15, 2010.
Interacting with a pivot table in the Excel Web Application.
maxresdefault.jpg


Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Pivot Table Data Crunching chapter 8 - The Excel Web App!
Well 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, or I inserted the 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 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.
Alright, 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 saved to Web, sign into the SkyDrive, and created it out there in a folder called Public Read-Only, 08-PTWebApp.
Alright, so once we know that's been saved, we'll do File, Close, we're going to view this on the SkyDrive, not using Edit 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 that will (unclear)...
Well hey, I want to thank you for stopping by, we'll see you next time for another netcast from Mrxcel!
 

Forum statistics

Threads
1,213,562
Messages
6,114,322
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top