Custom Style for Slicers in Excel

Подписаться 270 тыс.

Просмотров 78 тыс.

50% 1

In this video you will learn how to create a custom style for a Slicer. By using the custom style in slicer you can make your slicer based dashboard or report more visually attractive and beautiful.
Download the excel file from below given link:
www.pk-anexcelexpert.com/cust...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...
Laptop: amzn.to/2PlFFFz

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

2 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 51

@doyimega 4 месяца назад

thank you so much

@PKAnExcelExpert 4 месяца назад

Most welcome

@titikshastoyclub581 Год назад

Nice info

@PKAnExcelExpert Год назад

Thanks a lot

@MIS_PRODUCTION_AAA 9 месяцев назад

Thank sir

@PKAnExcelExpert 9 месяцев назад

Most welcome🙏

@sandeepreddy7687 6 лет назад

Thanks PK for this informative session. Your every new lesson adds value to everyone.

@PKAnExcelExpert 6 лет назад

Thanks Sandeep for your valuable feedback.

@prees2509 Год назад

Yes , it was very helpful.. thank you

@PKAnExcelExpert Год назад

Glad it was helpful!

@AlvinRyellPrada 6 лет назад

Thank you for sharing your best practises. I will apply this on my new report:)

@PKAnExcelExpert 6 лет назад

Thanks Alvin for your valuable feedback.

@srsandeepsinghnegi 6 лет назад

Really I enjoyed and learned new things from your videos. You are doing good. Thank you.

@PKAnExcelExpert 6 лет назад

Thanks for your valuable feedback

@Angexcel 3 года назад

Excelente tip, saludo desde Colombia.

@info2satish 6 лет назад

Very useful... Unusual tips in Excel...as always!!

@PKAnExcelExpert 6 лет назад

Thanks Satish for your valuable feedback

@CafeONlineHBO 4 года назад

Thanks Bro!! , I needed a tip that you gave in the video for continue with my dashboard

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@AmeeraHazmar 6 лет назад

Excellent Bro.. you are an excel genius..keep up the good work

@PKAnExcelExpert 6 лет назад

Thanks for your valuable feedback

@macchau6859 5 лет назад

Gr8 vid...thumbs up..

@James.Brooke 2 года назад

Thanks PK

@PKAnExcelExpert 2 года назад

Most welcome

@dastageera9626 4 года назад

Thanks brother great infermion!!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@rajaudaiyar9349 6 лет назад

Thank you very useful

@PKAnExcelExpert 6 лет назад

Thanks for your valuable feedback

@mohamadsiddeek7912 6 лет назад

Thanks, really I appreciate I was anticipating this type of tutorial thanks again Hi, please give me solution by Excel VBA for this regard While adding numbers from top to bottom it will give total again entered some numbers again total will come, but the total has to be combined in one. The first total has to be disappered and avoid the blank row as well in this manner has to be continued whenever need to see total. I wish to apply for this regard by Excel VBA. Thanks in advance

@asadmahboob1123 3 года назад

Hi PK, Is there a way to show the data label on a chart only when one single button on a slicer is selected/clicked? If filter is cleared on the slicer, I don't want the data level to be displayed as it will get clumsy.

@casper3842 4 года назад

hi sir! how do you place the Slicer Scroll Bar from Right to Left? ty!

@SR-NDK 3 года назад

Thanks bro, i am using slicer in two sheets. Slicer should work independently in different sheets is it possible? Plz update me anyone

@mohammedhammadahmed2168 2 года назад

Very nice sir

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@RedTurnedBlue 4 года назад

I know this video is older, hoping you can still help me out. One of your slicers styles colored the entire background. For the life of me I can get it to color my slicer background. I’m building a dashboard on an all black sheet. I need the background of my slicers to also be black. I’ve tried the customization options for “whole slicer” to no avail...any help would be appreciated. Thanks PK.

@44.7b.kaharaditya6 3 года назад

Very interactive vedio

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@macchau6859 5 лет назад

I have a question .. when we click on a cell in a pivot table, it drill down n shows the relevent data in new sheet... but when multiple slicer r used.. pivot table fail to show relevant data in drill down... why.. and ..whats the solution..

@SantoshSingh-lx3um 4 года назад

Sirji..Tussi Tope ho, Excel sikhne wale ki Hope Ho😃

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@krishnaamin2435 5 лет назад

Hi sir, I need a formula for extracting a unique value. for eg. In a cell I have A/B/C/G/A/G/C out of this I should get only the Unique valurs in a cell like A/B/C/G. Is there any formula to get answer like this? Thanks in advance.