How to Build Dynamic Dashboard in Excel ( Hindi )

how to build dynamic dashboard in excel ( hindi ) - in this excel video you will learn
how to Create dynamic Dashboard in excel Using Pivot Table, Doughnut Chart, Slicer & Timeline in Hindi. if you know how to use pivot table then its easy to make dashboard in excel , Summarize Data using pivot table | create a professional dashboard in excel, create a progress chart in excel, doughnut chart in Microsoft excel 2007/ excel 2010/ excel 2016 and excel 2013.
My New Channel : bit.ly/3qFrbl5
Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
Vlookup Complete Tutorial : bit.ly/2K0C1Sb
Complete Microsoft Word Tutorial : • How To Do Office Work ...
POWERPOINT COURSE : • MS Power Point Tutoria...
Don't worry if you have never created a Pivot Table, dashboard and progress chart before, i show you how to insert a pivot table in excel in Hindi or i have published 2 pivot table special video in detailed explanation... links is given below.
How do I create a dynamic dashboard in Excel?
How do I create a dashboard?
How do I create a dashboard in Excel?
How do I create an interactive dashboard in Excel?
Download Training File: drive.google.c...
pivot table for beginners in excel in Hindi || Microsoft excel 2007,2010,2016 • pivot table for beginn...
Pivot Table 2nd Video with slicers.
• Pivot Table in excel i...
Create Dynamic Charts in Excel || Using Drop Down List || Best Video In Hindi
• Create Dynamic Charts ...
other videos:
Excel 👉 create automatic Employee id cards in excel Hindi 👍 ID Cards बनाना सीख लो 👌बहुत आसान है • How To Create ID Cards...
How to Maintain Attendance Sheet in MS excel in Hindi
www.youtube.co...
Create Fantastic Fully Automated 👌Attendance Sheet in Excel
www.youtube.co...
how to make payroll sheet in excel | in Hindi
www.youtube.co...
pivot table for beginners in excel in Hindi || Microsoft excel 2007,2010,2016
www.youtube.co...
how to automatically transfer & Save data from one sheet to another in excel || HINDI
www.youtube.co...
how to create automated invoice in excel || in hindi
www.youtube.co...
how to link data between two (multiple) workbooks in excel | Hindi
www.youtube.co...
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld Playlist's:
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER TECHNICAL videos ► goo.gl/paZmpn
Automatic Invoice's in excel ► goo.gl/dFhg54
Subscribe to Deepak EduWorld ► / deepakeduworld
Follow on Instagram ► / deepakeduworld
Like my Facebook page ► / deepakeduworld
Follow on LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
We Always Provide Useful & Helpful Content On The Deepak Eduworld KZbin Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.

[@DeepakEduWorld]

🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳 *Show Me ♥ By Like Share & Comment* 🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪 *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

[@chetanshinde3154]

Hello, I tried in excel 2010 but unable to do it. Pl help

[@deepalilokhande7118]

I am also facing same issue...

[@jalanshyam11]

@@deepalilokhande7118 Hello Ma'am, which version of excel you are using. I am using excel 2007 and facing issue

[@rajeshkalijkar6789]

Very informative and useful for my analysis. Looking forward for more such videos. Thanks.

[@tajmuhammad3944]

Excellent video 👍👍👍

[@TechVPPandey]

Aap free mai ye sab sikhate ho mai aapka bada abhari hu. Nhi to tamam log KZbin par subscription mangte hai jo hum dene mai asmarth hai

[@sandeeproy3359]

Sir Excel 2007 may combo option under change series chart type nahi hai iske liye Kya karun

[@belamahajan7453]

No fill krne pr pura blank ho ja raha hai 😭😭😭

[@praveenjhariya102]

Sir mere pass sales data hai excel me date wise Ab mujhe month wise report kaise banyge excel me Cash sales Credit sales Online sales Please publish video Thanks Sir mein el software banaya hai medical stores

[@bharatbhore4899]

Hi sir Mera mess ka business hai jisame 20 customer hai unaka daily morning or evening tiffin hota hai jisame half aur full tiffin hota hai Mujhe excle me uska Daily sale aur daily tiffin add karake dash board banana hai jisase mujhe jaise day wide entry karane ke baad dash board pe abhi tak Kitana tiffin hu a hai overall aur pay Kitana huva hai aur customer name wise kaise banaye sir please help kijiye

[@DeepMawar]

Vedio is good. no doubt But ad. bht jyada hone wajah s apke baki vedios dekhne ki himmat nhi ho rhi.

[@bhimkunwor3894]

Its simple data can you please share comparision data with business (tgtvs ach,growth)share etc

[@MdIrfan-yy9jf]

Series value me 20time 1,1 type karne per chart show nahi ho rha hai

[@sarishwishmarketing]

Thank you, sir. Best wishes from Pakistan. Your Efforts will enlighten many people. Keep it up. Proud of you.

[@forshareskedaar9461]

how to add multiple inputs in rows like you have added item name only one time in row i have multiple inputs then where to add it should come in front of it but its coming below first name

[@jogendrasingh.narwariya]

मुझे एक दिक्कत आ रही है अगर मै किसी एक महीने को select करता हूं और यदि उस महीने में किसी एक ने सेल नहीं किया है तो चार्ट में 0% नहीं आ के कभी DI% आता है कभी कुछ नहीं आता है please resolve it

[@zitechupdates2195]

G sir distribution office ma stock kasa manage kra plz guide

[@zitechupdates2195]

G sir distribution office ma stock kasa manage kra plz guide

[@zitechupdates2195]

G sir distribution office ma stock kasa manage kra plz guide

[@dharmikmakwana4088]

Isme one item list ho to phir sathe me grand total bhi dikha raha hay isme range lock ny hoti kya kru

[@chandumouli2875]

Bro how u merge that donut chart I didn't see that chart combo in excel

[@ALGPD3699]

Sir, is it works out in wps office? Because undere text box formula not able to enter.

[@rahulsarswat9926]

bhai excel sheet kahan se milegi please dal do bhai app

[@bindashbhatt4774]

Helo sir...Mujhe bhi excal shikha h kya aap online bhi sikhate h..Plz btayen

[@DeepakEduWorld]

Aap humare channel pe advanced excel ki playlist dekhe 👍👍

[@1990panki]

Plz provide compare between sales man

[@MeriApeksha]

Sir daily deposit money receipt 365 days ka plan sheet bna dijiye 🙏

[@aftabkhan21april]

second wala donut jo cover karne wala option tha "computer" jo select karna tha wo nahi aaraha hai mere me....

[@ramkumarbhagat6610]

Same issue but not solve

[@zitechupdates2195]

G sir distribution office ma stock kasa manage kra plz guide kra

[@zitechupdates2195]

Plz

[@RahulSharma-su3vq]

Sir, Facing error #DIV/0! while checking another months reports after using timeline option

[@RahulSharma-su3vq]

Still waiting for your reply?

[@sandeepry01]

Bhai agar item name change or increase hogi toh

[@PramodTivari-lz8gn]

insert timeline me field formatted as date aise sho ho rha he

[@hasnatahmad5997]

mujhe ek bill book bnani hai jo k directly account ledger se connected ho. iss se related aap ki koi video hai

[@DeepakEduWorld]

New Video : Invoice With Stock [ Inventory] Management in Excel kzbin.info/www/bejne/mISneKWIqbOWms0

[@studyzone352]

If you have excel program where I can search student name it show results and roll number. Plz provide

[@burningheart007]

How you about to reach 1m subscriber, how u got 1m view for this video it shows your quality work with full dedication, left no confusion, doubts to viewer full pack satisfaction to clear topic. Thank Q bro...we wish you best of luck from Br. Shahid - TN

[@denomk]

also like and subscribe you deserve sir

[@prahladsharma9749]

Dear sir.. 2010 excel par ye work karta hi Mujhy waha par chart customs k option nahi mil raha...

[@DeepakEduWorld]

Aap iske liye at least office 2013 use kijiye 👍

[@prahladsharma9749]

@@DeepakEduWorld thanks a lot for ur response...

[@indianmonster1445]

How to make secure excel file...normally I was make excel file password.......so this password easy break in online......... How to more securities in this excel file ......let show......sir

[@zitechupdates2195]

Assalam.o.alaikum

[@mafaza.hifaza]

There are many questions but no reply but his explanation is very good and easy

[@ityou522]

Brother ye tu kafi mushkil hai 🙆‍♂️ but thanks for that 💁🏼‍♂️💯👍 good working God bless you 🤲🏻🙂

[@DeepakEduWorld]

Muskil nahi hai... Video dhyan se dekho.. or bnao.. maza aayega jab muskil kaam karoge to... 👍

[@RitikSharmaVlogs2]

@@DeepakEduWorld Yes

[@RBTechacademy]

Sir ye 20 one q type karana hai

[@prasadramanand5199]

Please share labre Excel data entry

[@tehseennaaztehseennaaz860]

sir ye deta hm ly skty hain ???

[@abhinayagrawal-g1j]

how to get database for experiment different chart

[@abhinayagrawal-g1j]

database source options plz

[@padmagopal5368]

Sir your video is super But I one clarification sir when in my Excel i am not able to find the change series chart type ✓ (doughnut )

[@Khan786amaan]

Can i change colour of slicer

[@ayazkhan3802]

Link tu share ker dien data kie

[@bhimkunwor3894]

You can remove get pivot option

[@ashah7246]

I really appreciate the efforts you have taken to explain the whole process. Thank you. Just a query, the steps from 8.30min is not possible in google sheet coz it doesn't have the option to enter series value manually. Pls advise.

[@yashneog5383]

Can you help me to make this

[@sanjivkumat4115]

20 baari 1 kyun type kiya

[@DhruvTechandSunitaKitchen]

Second series pe click karne ke baad change series chart par click karne ke baad combo options nahi aa raha hai

[@vestigeluckywilliamteam5156]

Though video is very very helpful brother.. thank you but sort out my problem

[@letgettowork3324]

Sir, yeh itni achi sheet toh humne bana li ab isko kaise banaya hai koi aur isey n jaan paye asa koi rasta hai is sheet ko 100 % protect karne ka...jisse ki koi iska bs data dekh paye pr edit n kar paye ya isme kya kya formulas use kiye hain voh n jaan paye...

[@dewanz4u79]

sir,,show values as is missing when i right click the mouse??could u plz let me know the reason?

[@Englishmust]

nice bro , good explain

[@syedkarim3631]

help full video i learn thata

[@paragparekh3795]

hi sir i want to talk with u on some my issues can i call u pls

[@lokendrachand7859]

Deepak sir mujhe ek video urgently chahe please help conver binary to decimal octal hexa

[@Pramodpramod-xb5bq]

Company galat likha h

[@UJJWALMBA1]

can you share me your data

[@Jamalhappy]

Sir.... If you don't mind..... Excel ki data sheets bhi attach kia karain.... Practice k lye

[@naushadahmadkhan6436]

जो चार्ट में परसेंटेज का कलर दिखा रहा है क्या हम उसे कलर में फॉरमेट कर सकते हैं? जैसे की मान लिजीए अगर कोई व्यक्ति 25 परसेंट का सेल कर रहा है तो उसका कलर ब्लु, अगर 50 है तो रेड, 50 से उपर है तो ग्रीन हो जाए। कहने का मतलब कंडिशनल फॉरनेटिंग का उपयोग हो सकता है या नहीं? अगर हाँ तो कैसे? कृपया रिप्लाइ जरुर करें।

[@arvindvishwakarma449]

Sir ek mera question hai,.... Excel 2007 mai.....Yadi mai koi bhi nam kama karke ek se adhik bar likhu to uska value jo maine diya hai o jis column/row me chahu o apne aap add karke likh jaye. Exp.... A=210, b=510, c=100...........value hai to ise a, b, c pahle row mai aur uska addition uske bagal wale row mai.

[@PrashantSingh-up6pe]

मेरे प्रोजेक्ट में हॉस्पिटल्स की संख्या प्रति वर्ष के हिसाब से प्रोग्रेसिव नंबर में है, जैसे 2019 में 50, 2020 में 60, 2021 में 70. टाइमलाइन में इयर सेलेक्ट करने पर शेप के अन्दर ये नंबर तो आ रहे है, लेकिन जब टाइमलाइन से फ़िल्टर क्लियर करे तो 2021 का डाटा शो करवाना है, ये कैसे शो होगा.

[@ashish905]

Combo option is not shown

[@umeshchandarana8415]

Wow. But lengthy. Needs more practice.

[@aalapvora6853]

Very very informative and simple video.... Thank you🎉❤🎉

[@greatlog4u]

Thanks Deepak for the hard work. Bhoot acha laga itni saf Urdu bolta howa (Hindi)

[@manojgiriya3442]

Urdu hai yeh tum log humari he bhasha ko Urdu bol dete ho copycat tum logon ki ek he bhasha arab woh nahi aati tum log musalman nahi confused ho tum log original muslim toh Dubai UAE wale hain 😂🤣

[@atulthakre5664]

Sir muze ek formula explain karke bataiye....muze samaz nahi aa raha hai.... Excel me ek hi cell me maine 1 twenty baar likh jab dusre cell par jata hu to jisme Maine 1 twenty baar likha us cell me 15 digit ke baad five digits 0 ho jata hai....use kounsa formula lagakar wah cell me all twenty digit me 1 dikhna chahiye.....kaise kare ispar ek video banao.....

[@arjunnegi26]

Nice video sir, Mene apki vedio dekh k same dashboard banaya But (As per data) Ram ki sale July me - 2 he items ki thi... So automatically 3rd row grandtotal ki ho gyi n vo he donut chart me show ho rhi thi . Any solution for it?

[@rubiccubic8795]

Why sleep comes whenever we study

[@MohanSingh-df8bi]

Take a chilled beer 😂😂😂

[@indianmonster1445]

Sir, I was try ......data summery.... I was make pivot table , this question is ." How to hide zero value find & hide row in pivot table .........

[@paramjeet975singh3]

Bhai sql vba aur power bi kaha se kiya

[@sudaisbhatti6735]

Hello Deepak Saheb I want to ask this when we write something in a box by doing excel then it should be opened in it when we don't write it stay white

[@alimuhammad8220]

Hi sir how are you

[@vvickyarora5651]

I am using excel 2007 but i couldn't find Combo option to select the series name and secondary axis. Please guide

[@sanjibpramanik9268]

✅

[@commonservicecentermandnak5450]

Bhai ji apna number de do please Aap say kuch point clear karnay h kyuki Aap nay un points ki koi video nahi banai h please bro

[@bakbakhappy]

superb

[@RaviGitSho]

The method of presentation was really appreciable. I would also like to learn, if my data is with multiple content, how to do for them. Current sheet its with only total quantity. What if i have data which need to be worked upon same design with A,B,C field & then the total. Your demo would be really appreciable, if shared.

[@kazimmehrozali]

Behterin v VIP

[@amitkakkar1681]

Hi Sir, if % going above 120% then ? The circle chart is showing not correct. Please help.

[@mohammadnasim1895]

Raw material production attendance sales benefit ka Excel mein software banane ki koshish karen Badi Meherbani Hogi

[@metalrattle7357]

good job

[@ankitsharmaarrockxzz955]

Hello deepak.. i want to send individual performance dashboard to individual person through outlook. Can you help me

[@saurabhbagde5998]

Great sir Thankuhh 💬🎉

[@mohammadzaman7383]

Nice ! Thank you.

[@rajasahu9171]

Sir change series chart type me mujhe click krne k bad chek list ka option nhi mila???? Ms office 2003

[@sujaymenon2691]

Deepakji aapkey sabhi video bhadiya hey ....please ho sakey toh financial modelling mey bhi ho sakey toh video banayiega

[@venkatrao3776]

Very Nice Classes of your end. These are not only classes, these Classes are Wealth Freedom. Thank You. Venkata Rao Telugu guy from Odisha, near Visakha Patnam.

[@salmanaslam5216]

Hello sir can you please provide the source code for free

[@pranavgosain8244]

Jatan Shah 2.21 Cr is good business. RS. 677 FOR 32000 STUDENTS

[@aka3396]

Good morning sir, When i click on salesman name i find no changing in my chart after doing in same way. Where is disconnect please suggest

[@humikhan9489]

Sir ap sy 1 help chahiyay thi k agr 12 months k fee record ho student hamary pass 500 plus ho tu enka dash bord kaise banay gy har month ki paid bacho ki percentage dash board py bta dy esy kaise banay gy plzzzzzzzz bta dy 1 video bana k

[@ManishKumar-ht6gm]

Agar kisi sales man ne mouse ni becha to result kharab ho jayega

[@Peoplescientist]

Sir how to make this whole dashboard in Google sheets? Plz make video series on Google sheets....!!!!

[@teckhindi8291]

Sir Qty mai pcs, kg, nos etc kai tarah ki quantity ho ....Tab hum sum kese nikalenge.... Ek tarah ki qty ho toh nikal lete hai.. Plzzz help...

[@DeepakEduWorld]

I ll publish video shortly.. Please wait

[@durgimajhi1629]

thnks ,Sir ....

[@pandharinathjoshi6565]

Sir beautiful sir... In your sheet shows search bar and Icon how we can made and search bar sir...pls

[@cyrttlegaming3193]

Sir Kounse company ka kitana item sell hua hai wo kaise check karna hai dashboard me.....

[@raziahmad5366]

my ms office 2010 therefore in pivot table there is no option of show value for change the percentage , how can i change the percentage of the vaue

[@funnyvids8622]

Start Mai percentage say 1 minus q kia tha uskA define kardiye samjh nah ayaa or Jo 20 time 1 likha tha woh bh

[@nickbell6311]

Excellent💯👍👏 thanks for great excel tutorial, youre effort in creating dashboard using pivot tables are much usefull,

[@mr.ashishjoshi5361]

aapki video bahut achhi hai mujhe sub samjh me aa gaya achhe se bus 1 cheej ni ayi humne Helper Column kyu banaya?? Helper Column se hota qa h kyu us ko use karte hai??

[@jetendrachaturvedi5873]

Hi, how can u help creating a dashboard of recruitment business of my small business