🔽 Download the example file here: [ Ссылка ]
If you find PivotTables a bit daunting, then Tables are a great alternative
because they can also be filtered with Slicers to create an interactive report. And with the right functions you can aggregate the data while ignoring the rows that are filtered by the Slicer.
🎓RELATED LESSONS:
Formatting Slicers: [ Ссылка ]
Slicers for PivotTables: [ Ссылка ]
Forcing Slicers to Single Select: [ Ссылка ]
LEARN MORE
===========
🏫 LEARN MORE in my Excel courses: [ Ссылка ]
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: [ Ссылка ]
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📢 Please leave me a COMMENT. I read them all!
🎯 FOLLOW me on LinkedIn: [ Ссылка ]
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: [ Ссылка ]
⏲ TIMESTAMPS
==============
0:00 Slicers for Excel Tables
0:15 Formatting data in a Table
0:50 Inserting & working with Slicers
3:31 Linking Slicers to Formulas
6:13 Limitations
#pivottables #dataanalysis #exceltips
![](https://i.ytimg.com/vi/j5hQ3WAx6sI/maxresdefault.jpg)