课程: Excel: Dashboards for Beginners

今天就学习课程吧！

今天就开通帐号，24,100 门业界名师课程任您挑！

Add interactivity with slicers and timelines

Add interactivity with slicers and timelines - Microsoft Excel教程

课程: Excel: Dashboards for Beginners

开始一个月试用 购买团队方案

Add interactivity with slicers and timelines

“

- [Instructor] Now we're ready to create some interactivity by adding slicers. To add our first slicer we're going to go over here and put our mouse into this pivot table. Then we're going to go up to Pivot Table Analyze here and click Insert Slicer. The slicer I'd like to insert is the sales region slicer. So I'll click the check next to it and hit OK. Once this slicer is added, I want to test if it works. So what I'm going to do is just click on one of these. Let me click on Northeast. Well, I see it updated this table but you'll note it didn't really update this pivot table. Let's see that again. I'll click Southwest, nothing's happening. So let's go ahead and fix that. Right now this slicer is only hooked up to this pivot table but we want to hook it up to all the pivot tables. So I'll click the slicer here and then we can go up to the Slicer tab, that's the one all the way on the right, and I'll click Report…

内容