Performance Dashboard In Excel : Part-1

Hello Friends,
This is the first part of Performance dashboard. In this video you will learn how to create a Performance dashboard in excel by using Slicers.
Please watch Performance dashboard part-2:
• Performance Dashboard ...
Please watch Performance dashboard part-3:
• Performance Dashboard ...
Please watch Performance dashboard part-4:
• Performance Dashboard ...
Please download this dashboard from below given link:
www.pk-anexcele...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Follow me on Facebook:
/ pkan-excel-expert-9748...
Website:
www.PK-AnExcel...
Pinterest:
/ pkanexcelexpert
Telegram: t.me/joinchat/...
blogger: pk-anexcelexper...
Twitter:
/ priyendra_kumar
************ 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-m...

[@jessijuniper7687]

I use your videos all the time! You’re the reason I landed my first account management job. :)

[@PKAnExcelExpert]

Congratulations

[@congphan1704]

Tks you so much from Vietnam. It usefull to my work.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@congphan1704]

@@PKAnExcelExpert you wellcome. May I have your your facebook or zalo to discuss. Please sr.

[@SameerShaikh-jb3hu]

sir, you are great. these so helpful and creative things

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AdeKaryadi]

Bermanfaat videonya, nice tutorial thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@illusion1888]

Wow, this is sooooo cool! I will use it in my dashboard!! Thank you PK!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PAUL_Raftaar]

Wow it's beautiful and fantastic

[@PKAnExcelExpert]

Thank you so much 😀

[@christopher768100]

PK sir your doing a very good job of sharing your knowledge through these videos, but you should also reply to questions asked below in the comment box. I was following your video and did exactly the same but my dynamic selection of data array is not happening. i asked this twice but no reply at all. Its coz of that im stuck. Please reply sir

[@sachinshetty5162]

Excellent Mr. P.K. Thanks for the sharing your knowledge to world wide.

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@soniyapursani5852]

Nice! Very well explained ..Thankyou..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@DrDJ319]

Very Good. Excellent explanation and application. I loved it

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@noeldoyle2477]

A really well put together example and explanation.

[@maryparmar8594]

Hello Sir, Many days I was searching for this kind of training session and finally got it Thank you I want to create new metrics which need to calculate volume work effort and resources utilization,. Can you please help on this

[@sujitsingha4153]

Hi Mary, even I am looking for the same. If you have prepared can you share

[@technologymadeeasy4311]

U r a champ bro ...kudos to u

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends and colleagues.

[@MrMosoani]

I like the speedometer show the percentage of how likely the team will meet the aht target by end of month.

[@iwanregarbatam]

it's very lucky for me to find your video PK....many thanks to you. wish you all the best

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback. Audience like you always encourage me to do something innovative in Excel.

[@davidquinn8327]

looks very impressive and user friendly

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rajatshinde25]

You have helped me to learn some very good aspect in excel. Thank you

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@aptrends3257]

Thanku very sir such a osm chart

[@nithikasn]

Dear Mr.Priyendar, Very beautiful & usefull presentation. Great Bhai!!

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@studiod2002]

very nice

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nassnass1930]

Dear, thank you for this effort, but the database used in the video explanation was not attached to be applied to to obtain results matching your explanation.🌹

[@bolmarullu]

This is awsome! 5.25, i can't really see what did you put after third ","

[@Fawwaz_Abu_Saad]

You R the best thanks a lot

[@PKAnExcelExpert]

Thanks for watching and sharing your valuable feedback

[@lanphamphuong4210]

Xin chào PK- An Excel Expert. Tôi đã vào website để download file excel nhưng không thấy file dữ liệu gốc để làm mà chỉ thấy file bạn đã thực hiện. Mong bạn up lại file data để làm. Cảm ơn sự chia sẻ và hướng dẫn của bạn. P/s: Bạn nên thực hiện chậm và có chú thích mỗi thao tác để mọi người có thể theo dõi, thực hiện và hiểu được. Cảm ơn bạn đã chia sẻ và hướng dẫn. Chúc bạn nhiều sức khỏe. Trân trọng!❤

[@kirandamodar]

Superb !!!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tasneemrangwala9036]

nice tutorial .. can u share the raw Data which helps us to practice basis on ur above video .. appreciate your kind help and support

[@mortennielsen8601]

Stunning! well done

[@PKAnExcelExpert]

Thanks Morten, Thanks for watching and sharing your valuable feedback.

[@tunisbabasisaiah6462]

Thanks for sharing your knowledge. I created the Pivot using name manager but I was unable to connect back to pivot sheet. kindly help out. thanks.

[@prkchpsnaplsaws2322]

Do you still need to "Create" a dynamic range using name function? Or can you simply define a table as your source and create pivot information from the defined table?

[@dineshpandi8608]

I have a doubt how can I contact you

[@ankoresh1523]

Hi Mr @PK, thanks for the knowledge, it's very amazing dashboard. Can you add the guide how to export data from the dahsboard to excel if we want to see the detail of data. Thank you before

[@PKAnExcelExpert]

Thanks for your valuable feedback. You can simply copy data from raw data sheet or any pivot table to another excel file

[@ankoresh1523]

@@PKAnExcelExpert thank you..

[@The-Instructor]

Thanks for your videos.. I have a question; I want to use median instead of average.. how to do that?

[@NetworthPlus]

please provide that excel file also it will be helpful to follow along, nice tutorial by the way

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please download this excel file from below given link. www.pk-anexcelexpert.com/excel-dashboard/performance-dashboard/

[@kamilalsaati2623]

Excellent

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@naveend3392]

Hello thank you for a wonderful video, I am also trying this video but the problem is there is no analyze tab in my excel, I have tried Google it for but I didn't get how to set Analyze tab in excel, please help me on this...

[@kempdinesh9754]

Hi PK excellent, But I have a one question. Could you please help me

[@christopher768100]

hello sir i followed your steps till creating dynamic pivot. Now i have 3 columnd, shop, units sold and revenue..how do i create percentage of revenue for each shop through value field settings

[@mujahidalikhan1623]

Employees will be on week offs, holidays and leaves etc, how to exclude those days and calculate Login hours and deficits login hours and inbound Calls

[@lukev730]

Hello PK Can you please upload any LFL comparison 2017vs 2018 sales with pivot charts and formulas. Thank you

[@monicasoni89]

Am unable to use calculate field via analyse tab. Can you help me to use theis tab with OLAP data?

[@SyedMuzammilMahasanShahi]

Thanks

[@PKAnExcelExpert]

Thanks for watching

[@putrasaminhoneybee]

like video....

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Rvnchtv]

Good day! Sir, Is this related on industrial quality control? Thanks!

[@Alma913521]

This is excellent. I am wondering could you please tell me how did you do start 6:00, I can't really see which that page was from? Thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback . I create the pivot table in new worksheet. Select the data on raw_data worksheet and press Alt D+P+F.

[@AliShah-fc2kh]

Dear could u tell how did u make them from start?

[@AlexisKimberlyGamit]

Great! But if i have a big data in a chart, normally big data needs big size of chart.how can i minimize the size without making the letters n number so small? aside from adjusting sizes . coz normally big n long data names will compress...

[@AlexisKimberlyGamit]

btw, I'm using excel 2010 😊 looking forward for your reply. Thanks!

[@ShivaSingh-vs4yv]

Hey I have the data for which I wanted to create a inforgraphics.. In the data I have area, No of days , total customer met. For example: New Delhi, 12, 50 It means in new Delhi in 12 days I met 50 people.. And my data goes on like this.. So how can I create a Inforgraph for this.. So that it is better understanding through chart. Pls help

[@ArmanKhan-iq3ji]

Hello Sir Can you make a video on automobile industry dashboard in excel, ..

[@Vegeta9142]

I want to see one dashboard for employees who are working on different projects. Let's say employee 1 works on project 1 and simultaneously works on project 2 aswell. And similarly employee 2 works on project 3 and project 4. So my requirement is I want to view there utilization report. Please can u suggest.

[@PKAnExcelExpert]

Hi I will definitely try to make such video very soon

[@Vegeta9142]

PK: An Excel Expert Pls let me know once you created

[@sureshchander1706]

Hi PK I need your help for dashboard.can you please share your number.

[@sureshchander1706]

Please share dashboard performance and sales number and percentage and region and state wise and month wise.

[@noumanali461]

Please provide practice material.

[@salmanadhikari4614]

Hi this video was amazing. Would like to learn advance excel. how can i connect you.

[@shubhambarge1977]

Will you please share the dataset that you used in this video please

[@PKAnExcelExpert]

Excel dashboard link has been given in videos discretion box. Please download this excel file from there.

[@shubhambarge1977]

I need the dataset please

[@safialam3597]

Please share the sheet for practice.....

[@PKAnExcelExpert]

Download link has been given in video's description box or visit our website WWW.PK-AnExcelExpert.Com

[@ramesh-ub4kz]

Hi, I have to role out excel dashboard as per Hierarchy to sales people, Means Manger can't see his boss data, What function i have to use for this.

[@MrKIRAN777]

If the person is entering twice in same day how the working hours calculated , insted of 8 it will show 16 hrs .

[@duynguyen598]

hi sir, i tried to listen to you the way of using the key to pastname function when you change the name of pivot. thanks.

[@nagajyothi9698]

Plz explain in cell tab data sir

[@alyce4042]

The music is really not needed, it's very distracting during your demonstration.

[@PKAnExcelExpert]

Thanks for your valuable feedback. You are right. I have removed it from my on going videos. Thanks for highlighting this.

[@sandyeagle9]

I need to make an excel dashboard for weekly performance is it possible to make one for me. kindly let me know how much it will cost if you have to make one

[@RajneeshKumar-co7hy]

Hi Priyank, Can You Enplane me about Average Handle Time ( is in Second ).

[@PKAnExcelExpert]

Hi Rajneesh, AHT (Average Handle Time) is the average time which were taken to handle a call.

[@RajneeshKumar-co7hy]

PK: An Excel Expert Thanks

[@abnan0001]

Hai brother.. I have seen most of your videos and its wonderdable & i have a made dashboard with your help and the videos which you have made.. If im trying to hide the sheets the links which are hyperlinked with the sheet are not working when i hidden the sheet.. i want to keep only dashboard sheet & list of the employees sheet which are hyperlinked to each sheet of driver but the links are not working when hidden , please can you provide me the help thank u

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please do not hide the worksheets. Go to Excel option(Press Alt T+O) >>Advanced >>Display Option for this workbook >>uncheck show sheet tabs I hope it will help you. Thanks for connecting with me.

[@abnan0001]

Thank You Pk.. I would like to know , how can i add refresh button on dashboard , once i do refresh , it automatically should refresh dashboard graphs.. thanks

[@PKAnExcelExpert]

Just press Alt + A+R+A to refresh the entire dashboard

[@preethirajini]

How can i download the excel for practice

[@PKAnExcelExpert]

Download link is in description box

[@preethirajini]

@@PKAnExcelExpert it’s asking me to buy the sheet - please provide me the download link here

[@christopher768100]

Hello Sir, when i set the data dynamic range as you mentioned using the =offset formula, all the rows dont get selected. For eg i have 2079 rows and it gets selected only till row no 1390. Columns are fine. Can you help me plz

[@Anonymous11245]

share the offset formula you have used

[@christopher768100]

@@Anonymous11245 hello sir, i resolved that problem. Can you help me with blanks in date column of raw data. Whenever i add month wise slicer my charts show blank cells as well. If i filter the blanks some charts show correct data some some wrong.If i remove monthwise slicer everything works fine. But Monthwise is important.

[@Anonymous11245]

@@christopher768100 Right click on your slicer > Select Slicer Settings > Check Hide Items with no data

[@bhumidave4825]

I Created the dashboard for client but after delivering client is getting the error "cant open ..." please advise. (Pivot table taking the source data from my local machine)

[@Alma913521]

Hi another question, I don't know why I don't have drop-down box in drag fields. So I can't follow the video from 7:39, also, is there any way that I could contact you. I tried Telegram, but it didn't work for me. Thanks in advance.

[@skrishna998]

Can you send me the offset data formula used in the vedio

[@javedshaikh-cm1vs]

sir ji plz upload your 2 part again , it's all seeing blur , it's humble request to upload again 🙏

[@mariamnegm58]

I wonder how the Grandtotal icon is there can you please tell me I'm having a trouble.

[@ibrahimmuhammad9509]

soft too, kindly send data file for practice

[@sudhanshubhatt1]

Can you help me get quality dashboard for my process

[@padmakrishnan4459]

Hi Can you share performance appraisal with a proposed bonus report

[@JDFromAnotherPlanet]

How you have you create it??

[@KnowEverythin]

sir, I have working on daily production report per shift in excel vb form. sir how can i avoid duplicity ....I want to add data 1 /per Day with 3 shift(A,B,C). I also see ur previous video for avoid duplicity, but problem not solve due to u checking only 1 column i.e employee id

[@PKAnExcelExpert]

Hi Haradhan, Please create a key column (support column) by concat your two column. Then use that key column to check the duplicate entry.

[@KnowEverythin]

sir, I dont understand.sir,is their any this type of video ( Day and shift(A,B,C) u made, pls give me the link...sir pls give me your mail id, sir, pls help me... my mail id [e-mail]

[@KnowEverythin]

If Application.WorksheetFunction.CountIf(sh.Range("A:A"), Me.TextBox1.Value) > 0 And Application.WorksheetFunction.CountIf(sh.Range("A:B"), Me.ComboBox1.Value) > 0 Then MsgBox "duplicate entery", vbCritical sir, here i select textbox1=date, and combo box1 =shift( A,B,C) but nt proper work

[@mayanarayan5723]

Do u have any notes created for dashboard can u share

[@anjankotha5689]

After press F3 no window will open.. wats the problem I did.

[@christopher768100]

i didnt catch the shortcut formula to get to pivot....Alt D...what is later was not clear

[@PKAnExcelExpert]

It was Alt+D+P+F

[@christopher768100]

@@PKAnExcelExpert thanks actually i did guess work n got it right

[@phediabui6271]

How can we demonstrate the Bar chart in case we exceed 100%, says 125%??

[@anandrengasamy1298]

how to get Pivot data anlayze menu bar for ms office 2010

[@lore5817]

Hello please help me How to hide the bar below??

[@PKAnExcelExpert]

To hide the sheet tab please follow the below steps- 1.Go to File > Excel Option (or press Alt+T+O) 2.Got to Advanced >> Display option for this workbook 3.Uncheck show sheet tabs and click on ok

[@kriparaghunathki3578]

Hindi me apke videos nahi hai sir? I understand English, but for better understanding, need hindi videos

[@mitulpatelful]

Please create kpi dashboard

[@PKAnExcelExpert]

will try

[@Kodavati0707]

Hey !!! Can you share me the Excel which you have created? please

[@PKAnExcelExpert]

Hi, Excel download link has been given in last part (Part-4) videos discretion box. Please download this excel file from there.

[@mdilbrahim4874]

please give download link row data ...description link not good please give google drive link

[@majazsayed1634]

sir ,Please advice how to hide the tabs & access it through hyperlink

[@amlankarmakar1018]

Give me your raw data in excel file please I want to learn that according to your video.

[@PKAnExcelExpert]

Please download this excel file from the link given videos discretion box or visit our website Www.pk-anexcelexpert.com

[@jincyjose6704]

@@PKAnExcelExpert sorry, there is no option to download the raw file as .xl.

[@quynhmaittruc4776]

@@jincyjose6704 Alt + O + H + U you can unhide data sheet

[@uniquesingh7604]

Apse bate ho sakta hai Dashboard banwana hai

[@cheysanity]

I did not get the short cut for pivot, ALT+D+P and what?

[@PKAnExcelExpert]

Alt+D+P+F

[@yumiko-wt3fn]

how to create like these table, charts?

[@pietroHK]

Instead of using the Offset convert the Raw Data data into a table.

[@PKAnExcelExpert]

Hi Pietro, Yes, we can use table also instead of using Offset Function but there is slightly difference in table and offset function. Offset Function:- You can row and column in you data and refresh the pivot table. Table:- You can add row only. If you will add column you have to change the pivot source. However thanks for watching the video and sharing you valuable feedback.

[@mutlaqsaud1028]

Hi Pietro .I need help in setting up Dashboard to report call centers Email: [e-mail]

[@gauravrathod9173]

Can i get the dataset you used

[@PKAnExcelExpert]

You can download it from the link given in video's description box. or visit our website WWW.PK-AnExcelExpert.Com

[@daveschutz3294]

Would be better to lower the music volume....Thanks...

[@PKAnExcelExpert]

Sure Dave, i will take care of this in upcoming videos

[@dcs1859]

I forgot to mention, Thank you very much... this is one of the best series of "how-to" for dashboard I have ever seen.. great job!

[@PKAnExcelExpert]

Thanks David for nice words. Audience like you always encourage me to do something innovative in Excel. Thank you so much for your valuable feedback.

[@mashkoorezdigyasi2314]

Can you post the link to the drive to retrieve the raw data.

[@PKAnExcelExpert]

Excel dashboard link has been given in last part(Part-4) videos discretion box. Please download this excel file from there.

[@arjasarkar13]

Too good Mr.PK. can we have your email address. Thanks!

[@hossammohamed7096]

Can any one help me with offset function ? each time i type the formula, i receive an error message saying that i am entering too many arguments !!

[@PKAnExcelExpert]

Hi Hossam, You can watch this video to learn OFFSET function: kzbin.info/www/bejne/gmOcm6StasqVfZY

[@harnoorwaraich5045]

=offset(sheetsselction,,,counta(verticalsheetselction),countahorizentalsheetselction))

[@ashashaik749]

Please sent formula ur using bcz it is not shown properly

[@sonukejriwal2759]

can i get the dummy data

[@eng.shimulhassan6885]

please provide me pivot table open short policy

[@samaras894]

Can you please not use shortcuts or complicated terms without explaining them to your viewers? As many of us including me are not fully aware of these terms. Please tell me what did u say on the 5:53??

[@Anil-Digital-Marketing]

Sir you didn't even tell me how to connect performance button with pivot table

[@dineshmamgain108]

Pls share raw data for practice

[@PKAnExcelExpert]

Hi Dinesh, Excel download link has been given in last part (Part-4) of this video's discretion box. Please download this excel file from there.

[@dineshmamgain108]

So Fast PK .......thanks

[@ShahabKhan-mf9ct]

Ye file mujje share krskty plzzz