Performance Dashboard in excel : Part-2

  Рет қаралды 188,021

PK: An Excel Expert

PK: An Excel Expert

Күн бұрын

Пікірлер: 76
@sonisoni56
@sonisoni56 5 жыл бұрын
it is very hard to get such complete tutotials on youtube, it helps to learn quickly, thank you PK!
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for your valuable feedback
@gva4498
@gva4498 6 жыл бұрын
Most experts in the use of excel make these videos in order to teach others and that's great. So that your videos are attractive like those of your other colleagues and are more effective, you just need to include a link to download the files with which you do your practices, so that when a user of "youtube" sees them, download them and practice watching your videos.
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Hi, Thanks for watching and sharing your valuable feedback. I am already providing the Excel file download link in video's discretion box. If a video has multiple parts then I provide the download link in last part of video. Thanks.
@RahulKumar-ly6ly
@RahulKumar-ly6ly 3 жыл бұрын
Thanks sir very helpful video
@PKAnExcelExpert
@PKAnExcelExpert 3 жыл бұрын
Thanks for your valuable feedback
@KC-xp1yk
@KC-xp1yk 2 жыл бұрын
Great content, nice short and to the point tutorials. Thank you PK!
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Thanks for your valuable feedback
@naveenkumarchintu
@naveenkumarchintu Жыл бұрын
Thanks for the content . very helpful .. but background music is not needed and very irritating
@PKAnExcelExpert
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@muralikrishnakcv7893
@muralikrishnakcv7893 3 жыл бұрын
Hi i like all your vedieos its getting inspired me create & think of new direction. Can i get one vedeio how to create plan vs actual with dynamic condition like Actual is more than equal to plan should show green color bar if actual is less than plan bar should show red colour pleae creat a vedio sir thanks in advance.
@gva4498
@gva4498 6 жыл бұрын
Just do it and you will see the difference in followers and how your videos will be more valued. Greetings and good work
@KNLP23
@KNLP23 4 жыл бұрын
PK sar, jolly good teaching!
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@vandanaprakash7634
@vandanaprakash7634 2 жыл бұрын
Hi, Thanks for the great tutorial. I wanted to check for testing I added dummy data for a new month and later deleted the entire row from the raw data, however it is still showing up in the pivot and the slicer. How to remove that?
@christopher768100
@christopher768100 5 жыл бұрын
If a new emloyee data gets added to the raw data sheet and refresh the pivot, will the slicers automatically add his name to it.
@freddiesuliva3048
@freddiesuliva3048 4 жыл бұрын
Can u share the dummy raw data for my practice?
@vishvaaa8600
@vishvaaa8600 6 жыл бұрын
I am learning lot from your content. Only one request /feedback from my side. Please change the background music or remove it. Because it's so pleasant that's inducing sleep while studying.
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Hi Vishvaa, Thanks for watching and sharing your valuable feedback. I will definitely take care of this in upcoming videos.
@jasminalbances3586
@jasminalbances3586 3 жыл бұрын
I used to watch your video everyday. Can possibly be a tutor? ☺️
@aprilmiranda3025
@aprilmiranda3025 4 жыл бұрын
You are amazing! Thank you!!! 😊
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@JDFromAnotherPlanet
@JDFromAnotherPlanet 4 жыл бұрын
@@PKAnExcelExpert Can you please guide me how you have create it??
@avismunchcrunch4830
@avismunchcrunch4830 6 жыл бұрын
Awesome dashboard.. thanks for all ur efforts..
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@AshishMishra-yd3rx
@AshishMishra-yd3rx 4 жыл бұрын
क्या में इस डैशबोर्ड को वर्जन 16.00 microsoft 2003 me bana sakte hai pls suggest
@sangsaputro9921
@sangsaputro9921 6 жыл бұрын
Mr. PK, i want ask part of slicer (Month)...could you sort by calendar ?
@xft7936
@xft7936 6 жыл бұрын
Great hand in excel, valuable inputs man..keep it up
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@tahirali5819
@tahirali5819 4 жыл бұрын
Great work!
@TaufikHidayat-bh3nv
@TaufikHidayat-bh3nv 6 жыл бұрын
Hi, Great Tutorial, Are you getting the source data from EDGE? If yess, from whats folder it is? Store visit?
@sivakrishnamoorthy9455
@sivakrishnamoorthy9455 4 жыл бұрын
Can I do this dash board in google Sheets .?
@johanvanzyl8548
@johanvanzyl8548 5 жыл бұрын
Hi thanks for all the helpfull videos Can you show me how to make a dash board where is can capture all my mobile fleet (vehicles) and the kilometers so that when i reach a detail kilometre I need to be notified for the service of the car
@jetendrachaturvedi5873
@jetendrachaturvedi5873 5 жыл бұрын
Hi PK, is there a way to speak with you. we need a recruitment dashboard for our company.
@maruthikumarbv6671
@maruthikumarbv6671 6 жыл бұрын
Sir which MS OFFICE VERSION you are using
@AhmadMustafaMohmedMetwalley
@AhmadMustafaMohmedMetwalley 4 жыл бұрын
Dear Sir I had viewed your KZbin channel. It is great I have big data sheet for my patients I need help to get dynamic user form for it. Can you help me. Thanks. Ahmad
@shanmugasundaram6298
@shanmugasundaram6298 6 жыл бұрын
nice, the way he communicated.
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks
@sathishkumar-hv1cv
@sathishkumar-hv1cv 5 жыл бұрын
hi..can you guide me how to upload file from floder to http link page..from destop
@akashtribhuvan8124
@akashtribhuvan8124 6 жыл бұрын
Awesome👍👍👍
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback
@akashtribhuvan8124
@akashtribhuvan8124 6 жыл бұрын
@@PKAnExcelExpert Sir I really liked the way you have explained and i have subscribed to your channel. Keep sharing your knowledge. Thanks a lot.
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks
@dushyantkumar9713
@dushyantkumar9713 4 жыл бұрын
Sir SQL ke liye koi chanal hai kya
@tasneemrangwala9036
@tasneemrangwala9036 5 жыл бұрын
Hi .. i am done until Vlookup of all the 3 field like call handeled sales and aht but i am unable to link it inside the 3 cards .. i tried alot but still not able to .. can u help
@whitefox8291
@whitefox8291 3 жыл бұрын
im having the same issue, did you figure it out ?
@jagiraliansari9405
@jagiraliansari9405 4 жыл бұрын
How to add group drawing tool in excel 2010.
@naveenpattar9720
@naveenpattar9720 4 жыл бұрын
My slicer r not working and m not getting where m gng wrng
@ammadurrahman5321
@ammadurrahman5321 6 жыл бұрын
Nice.....thanks...
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for watching
@SyedMuzammilMahasanShahi
@SyedMuzammilMahasanShahi 5 жыл бұрын
Thanks
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Thanks for watching
@DarkWhisperer13
@DarkWhisperer13 4 жыл бұрын
Where can I download the files? Please
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Download link has been given in videos discretion box. Or you can download from my website www.pk-anexcelexpert.com
@jahanzaibaniq3363
@jahanzaibaniq3363 4 жыл бұрын
Can i have this sheet sir?
@ashishsharma871
@ashishsharma871 5 жыл бұрын
Hi i don't find slicer option in my excel please help am using 2007
@PKAnExcelExpert
@PKAnExcelExpert 5 жыл бұрын
Slicer is not available in Excel 2007. Please upgrade your Excel as 2010 or above
@ashishsharma871
@ashishsharma871 5 жыл бұрын
@@PKAnExcelExpert thanks a lot can you make a video for a dashboard like this in 2007 version need help or can share the link its really helpfull.i am un urgent need
@InnerSparkNetwork
@InnerSparkNetwork 3 жыл бұрын
can you send this sheet....
@NG-bn6fm
@NG-bn6fm 6 жыл бұрын
I have some queries. How can I connect with you
@jagan1nathan
@jagan1nathan 5 жыл бұрын
Let me know what questions you have, I can help you out.
@raadghous5467
@raadghous5467 4 жыл бұрын
If I will give you data can you please help me?
@sagarikadubara8252
@sagarikadubara8252 4 жыл бұрын
can you share the raw data
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Please download this excel file from link given vedio's description box or visit our website Www.pk-anexcelexpert.com
@user-pj6gf4jv4o
@user-pj6gf4jv4o 6 жыл бұрын
dashboard pura honeke bad data Kase add kare
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Add your data in raw data worksheet then go to Data tab and click on Refresh All button. Entire dashboard will be updated
@andyzhao2205
@andyzhao2205 6 жыл бұрын
Hi is it possible that we can have the raw data in ur video? thanks
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Hi Andy, I have given the download link in the last part (Part-4) video's discretion box. Please download this excel file from there. Thanks for watching.
@ShahabKhan-mf9ct
@ShahabKhan-mf9ct 4 жыл бұрын
Ye file plzzzz share krde muje
@muscatintl3871
@muscatintl3871 6 жыл бұрын
Great job... May i get your email please?
@PKAnExcelExpert
@PKAnExcelExpert 6 жыл бұрын
Thanks for your valuable feedback. Please connect with me on Facebook, Twitter and telegram. Details have been given in videos discretion box.
@seemarathi3296
@seemarathi3296 Жыл бұрын
Hind me
Performance Dashboard in excel : Part-3
14:17
PK: An Excel Expert
Рет қаралды 113 М.
Info-graphics: 3D Glass Chart in Excel
10:15
PK: An Excel Expert
Рет қаралды 234 М.
МЕБЕЛЬ ВЫДАСТ СОТРУДНИКАМ ПОЛИЦИИ ТАБЕЛЬНУЮ МЕБЕЛЬ
00:20
Girl, dig gently, or it will leak out soon.#funny #cute #comedy
00:17
Funny daughter's daily life
Рет қаралды 40 МЛН
escape in roblox in real life
00:13
Kan Andrey
Рет қаралды 74 МЛН
Sales Dashboard in Excel: Part-1
14:13
PK: An Excel Expert
Рет қаралды 92 М.
Male and Female Info-graphics in Excel
12:53
PK: An Excel Expert
Рет қаралды 164 М.
How to create a Simple Dashboard Report in Microsoft Excel
18:56
Ajay Anand
Рет қаралды 338 М.
📊 How to Build Excel Interactive Dashboards
19:21
Kevin Stratvert
Рет қаралды 2,5 МЛН
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 253 М.
How to Create an Interactive Excel Dashboard in Just 12 Minutes
12:01
iDATA Analytics Hub
Рет қаралды 696 М.
A Stunning Chart to display 5 KPI Metrics together
13:45
PK: An Excel Expert
Рет қаралды 199 М.