it is very hard to get such complete tutotials on youtube, it helps to learn quickly, thank you PK!
@PKAnExcelExpert5 жыл бұрын
Thanks for your valuable feedback
@gva44986 жыл бұрын
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.
@PKAnExcelExpert6 жыл бұрын
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-ly6ly3 жыл бұрын
Thanks sir very helpful video
@PKAnExcelExpert3 жыл бұрын
Thanks for your valuable feedback
@KC-xp1yk2 жыл бұрын
Great content, nice short and to the point tutorials. Thank you PK!
@PKAnExcelExpert2 жыл бұрын
Thanks for your valuable feedback
@naveenkumarchintu Жыл бұрын
Thanks for the content . very helpful .. but background music is not needed and very irritating
@PKAnExcelExpert Жыл бұрын
Thanks for your valuable feedback🙏
@muralikrishnakcv78933 жыл бұрын
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.
@gva44986 жыл бұрын
Just do it and you will see the difference in followers and how your videos will be more valued. Greetings and good work
@KNLP234 жыл бұрын
PK sar, jolly good teaching!
@PKAnExcelExpert4 жыл бұрын
Thanks for your valuable feedback
@vandanaprakash76342 жыл бұрын
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?
@christopher7681005 жыл бұрын
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.
@freddiesuliva30484 жыл бұрын
Can u share the dummy raw data for my practice?
@vishvaaa86006 жыл бұрын
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.
@PKAnExcelExpert6 жыл бұрын
Hi Vishvaa, Thanks for watching and sharing your valuable feedback. I will definitely take care of this in upcoming videos.
@jasminalbances35863 жыл бұрын
I used to watch your video everyday. Can possibly be a tutor? ☺️
@aprilmiranda30254 жыл бұрын
You are amazing! Thank you!!! 😊
@PKAnExcelExpert4 жыл бұрын
Thanks for your valuable feedback
@JDFromAnotherPlanet4 жыл бұрын
@@PKAnExcelExpert Can you please guide me how you have create it??
@avismunchcrunch48306 жыл бұрын
Awesome dashboard.. thanks for all ur efforts..
@PKAnExcelExpert6 жыл бұрын
Thanks for your valuable feedback
@AshishMishra-yd3rx4 жыл бұрын
क्या में इस डैशबोर्ड को वर्जन 16.00 microsoft 2003 me bana sakte hai pls suggest
@sangsaputro99216 жыл бұрын
Mr. PK, i want ask part of slicer (Month)...could you sort by calendar ?
@xft79366 жыл бұрын
Great hand in excel, valuable inputs man..keep it up
@PKAnExcelExpert6 жыл бұрын
Thanks for watching and sharing your valuable feedback
@tahirali58194 жыл бұрын
Great work!
@TaufikHidayat-bh3nv6 жыл бұрын
Hi, Great Tutorial, Are you getting the source data from EDGE? If yess, from whats folder it is? Store visit?
@sivakrishnamoorthy94554 жыл бұрын
Can I do this dash board in google Sheets .?
@johanvanzyl85485 жыл бұрын
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
@jetendrachaturvedi58735 жыл бұрын
Hi PK, is there a way to speak with you. we need a recruitment dashboard for our company.
@maruthikumarbv66716 жыл бұрын
Sir which MS OFFICE VERSION you are using
@AhmadMustafaMohmedMetwalley4 жыл бұрын
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
@shanmugasundaram62986 жыл бұрын
nice, the way he communicated.
@PKAnExcelExpert6 жыл бұрын
Thanks
@sathishkumar-hv1cv5 жыл бұрын
hi..can you guide me how to upload file from floder to http link page..from destop
@akashtribhuvan81246 жыл бұрын
Awesome👍👍👍
@PKAnExcelExpert6 жыл бұрын
Thanks for your valuable feedback
@akashtribhuvan81246 жыл бұрын
@@PKAnExcelExpert Sir I really liked the way you have explained and i have subscribed to your channel. Keep sharing your knowledge. Thanks a lot.
@PKAnExcelExpert6 жыл бұрын
Thanks
@dushyantkumar97134 жыл бұрын
Sir SQL ke liye koi chanal hai kya
@tasneemrangwala90365 жыл бұрын
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
@whitefox82913 жыл бұрын
im having the same issue, did you figure it out ?
@jagiraliansari94054 жыл бұрын
How to add group drawing tool in excel 2010.
@naveenpattar97204 жыл бұрын
My slicer r not working and m not getting where m gng wrng
@ammadurrahman53216 жыл бұрын
Nice.....thanks...
@PKAnExcelExpert6 жыл бұрын
Thanks for watching
@SyedMuzammilMahasanShahi5 жыл бұрын
Thanks
@PKAnExcelExpert5 жыл бұрын
Thanks for watching
@DarkWhisperer134 жыл бұрын
Where can I download the files? Please
@PKAnExcelExpert4 жыл бұрын
Download link has been given in videos discretion box. Or you can download from my website www.pk-anexcelexpert.com
@jahanzaibaniq33634 жыл бұрын
Can i have this sheet sir?
@ashishsharma8715 жыл бұрын
Hi i don't find slicer option in my excel please help am using 2007
@PKAnExcelExpert5 жыл бұрын
Slicer is not available in Excel 2007. Please upgrade your Excel as 2010 or above
@ashishsharma8715 жыл бұрын
@@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
@InnerSparkNetwork3 жыл бұрын
can you send this sheet....
@NG-bn6fm6 жыл бұрын
I have some queries. How can I connect with you
@jagan1nathan5 жыл бұрын
Let me know what questions you have, I can help you out.
@raadghous54674 жыл бұрын
If I will give you data can you please help me?
@sagarikadubara82524 жыл бұрын
can you share the raw data
@PKAnExcelExpert4 жыл бұрын
Please download this excel file from link given vedio's description box or visit our website Www.pk-anexcelexpert.com
@user-pj6gf4jv4o6 жыл бұрын
dashboard pura honeke bad data Kase add kare
@PKAnExcelExpert6 жыл бұрын
Add your data in raw data worksheet then go to Data tab and click on Refresh All button. Entire dashboard will be updated
@andyzhao22056 жыл бұрын
Hi is it possible that we can have the raw data in ur video? thanks
@PKAnExcelExpert6 жыл бұрын
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-mf9ct4 жыл бұрын
Ye file plzzzz share krde muje
@muscatintl38716 жыл бұрын
Great job... May i get your email please?
@PKAnExcelExpert6 жыл бұрын
Thanks for your valuable feedback. Please connect with me on Facebook, Twitter and telegram. Details have been given in videos discretion box.