Тёмный

Slicers in Excel Pivot Table 

Presentation Process
Подписаться 517 тыс.
Просмотров 104 тыс.
50% 1

How to Use Slicers in Excel Pivot Table and filter a table conveniently (with Examples).
Combo Excel, PowerPoint and Word Courses: shop.presentat...
What is covered in this Excel tutorial:
==============
1. Example of when Slicer is used
2. Using slicers to see different types of reports
3. Viewing report with multiple sets of data
4. Adding multiple slicers
5. Adding linked Slicers to Multiple Pivot Tables
6. Using Report connections
7. Slicer Design to make them more attractive
8. How to change Slicer cell width and height
9 How to change the name of a Slicer
10. Applying preset formats to Slicers
Link to Free Excel Mini-Course: www.presentati...
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.

Опубликовано:

 

1 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 44   
@bluedemon3243
@bluedemon3243 4 месяца назад
THIS WAS A THING IN EXCEL!?!?! Why don't teachers teach us this?
@blueskyguy1
@blueskyguy1 4 месяца назад
Wonderful Ram 🎉 Can you produce a training package for Visio? Please 🙏
@ARV999
@ARV999 2 года назад
Amazing! thank you for share. beautiful way to explain!
@r.o.c.4545
@r.o.c.4545 Год назад
Awesome demonstration! 👏🏾👏🏾👏🏾
@charleswuxi
@charleswuxi 4 года назад
Great Video, Clear and smooth pace with details, Thumb up
@GreigNiven
@GreigNiven 2 года назад
Great video and a fantastic example of how to do tutorials effectively as others here have also raised. Many thanks!
@PavanKumar-zj5sz
@PavanKumar-zj5sz Год назад
Hi Sir, Awesome explanation.....such a simple teaching help us to learn very quickly. Thank U so much
@PresentationProcess
@PresentationProcess Год назад
You are most welcome
@Ryman-
@Ryman- Год назад
Double ad during timed exam
@ncrmlsvideos8867
@ncrmlsvideos8867 4 года назад
This was a wonderful tutorial, thank you for taking your time to explain this to us so effectively.
@vrjk2001
@vrjk2001 3 года назад
Can I ask a question please? II understand that a slicer can be connected with more Pivot Tables by using REPORT CONNECTIONS tab. Is it possible to do REPORT CONNECTIONS for a slicer with a Table and a Pivot Table together ?
@jessie8165
@jessie8165 3 года назад
Great info. What is the maximum characters allowed in a slicer cell? That said, suppose i have a cell in my pivot with say 100 characters, will it fit in a slider cell?
@rebm3028
@rebm3028 3 года назад
Hello, With the slicers of a pivot table, I can't keep the format (example wraps) As soon as I click on another segment, there is no more wrapping and the box is unchecked ...
@plavali_znaem
@plavali_znaem 2 года назад
I don't have both of the pivot tables appearing ... - only one. How do I connect to another one / make it appearing on Report Connections?
@rohitnaval5589
@rohitnaval5589 4 года назад
You are master instructor! I wish I had you on my team!
@raed.latheef
@raed.latheef 4 года назад
ވެޜީ ކޫލް
@athemkashung8266
@athemkashung8266 10 месяцев назад
Wonderful tutorial. A new subscriber 🙏
@saraswatkrchakrabrty797
@saraswatkrchakrabrty797 3 года назад
Thanks for the video,I have one question, can we manually change the order of the options which are available under slicer?
@miransh
@miransh 3 года назад
Thank you Sir, you solved and made it so easy, you've got beautiful voice.
@PresentationProcess
@PresentationProcess 3 года назад
Glad it helped
@craigcanter9223
@craigcanter9223 3 года назад
Wicked cool. Tutorial was excellent
@PresentationProcess
@PresentationProcess 3 года назад
Glad you liked it!
@darshanchavare6148
@darshanchavare6148 Год назад
Very well explained! It's really helpful!
@PresentationProcess
@PresentationProcess Год назад
Glad to hear that!
@piusmbeti2238
@piusmbeti2238 Год назад
So damn clear, Thank you so much for this life saver video.
@prashan3253
@prashan3253 4 года назад
I only wish my teacher in school was as good as you
@615bala
@615bala 3 года назад
wonderful explanation like an interesting story
@exequielgozun1736
@exequielgozun1736 Год назад
Thank you, this made my report easier to adjust!
@stephanievega4458
@stephanievega4458 3 года назад
Great content! Easy to follow . Thanksb! now back to work
@taramattiemohamed551
@taramattiemohamed551 3 года назад
This was really helpful. Thanks for sharing.
@wildherbs7693
@wildherbs7693 3 года назад
How to delete the added Tab Slicer?
@vnvipindasyt
@vnvipindasyt 4 года назад
The way u explain is really good.. medium paced and with good detailing.. I loved it.
@fernandarize
@fernandarize Год назад
Yes, it is beautiful!
@hemendrakumarvarshney8825
@hemendrakumarvarshney8825 2 года назад
Very nicely explained
@rod4095
@rod4095 8 месяцев назад
Nice presentation
@tifiniza
@tifiniza 4 года назад
Very clear and helpful thanks
@mohdimranyusof2889
@mohdimranyusof2889 3 года назад
Impressive, tq
@andriikulishov3371
@andriikulishov3371 3 года назад
brilliant! thanks!
@bahabora5547
@bahabora5547 4 года назад
thanks, helped a lot
@vandanakm3149
@vandanakm3149 Год назад
Superb
@mohammedfarook5376
@mohammedfarook5376 3 года назад
sir super
@NaijaBoiTellEm
@NaijaBoiTellEm 4 года назад
Thanks. Subbed.
@agrvivekbagale2133
@agrvivekbagale2133 4 года назад
Excellent video
@barbararios9845
@barbararios9845 4 года назад
I Loved the tutorial very helpful: Thank you
Далее
Как открыть багажник?
00:36
Просмотров 16 тыс.
How to use Power Pivot in Excel | Full Tutorial
30:38
Excel Pivot Table Design Tricks
6:29
Просмотров 64 тыс.
MS Excel - Pivot Table Slice
9:38
Просмотров 410 тыс.
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Просмотров 704 тыс.
Master Pivot Tables in 10 Minutes (Using Real Examples)
11:33
Pros Use This Technique to Avoid PivotTables
6:38
Просмотров 118 тыс.