Dashboard Step by Step | Radio Button Example | How to build Interactive Excel Dashboard
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- Dashboard Step by Step | Radio Button Example | How to build Interactive Excel Dashboard
Learn how to create an interactive Excel dashboard from scratch using the built in Excel tools.
If you want to get serious about dashboards development and want a blooming career ahead I recommend you take a bit of time and learn step by step from scratch.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
(Playlist Folder-Excel Dashboard & Reports-dashboardradiobutton.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#dashboard#exceldashboard#Innozant #interactivedashboard
Good afternoon, you are really genius, i know whoever following you and learning from you, they are getting things from small one to giant things. best of luck
Thanks.Happy Learning
This series of Dashboard is just Amazing. Thank you Sir!🙏🙌
Thanks ❤️
sir your teaching very excellent really you r god of excel
Thank you so much sir, you are doing a great job the way you teach and guide us its tremendous...... You are the best mentor
Thanks Ranvir❤️
Super sir, excellent tricks & logic, love to see again & again
Thanks Salil..Happy Learning 🙏❤️
great
Sir, sabse jyada mushkil dashboard hee Lagta hai. Great video. Learn a lot from this video 🙏 thank you Sir.
Harivansh Ji,Muskil Word apse sunna acha nhi laga..Aap to bahot acha attempt karte ho questions aur seekh rahe ho..Phir kyu muskil..Koi baat nahi..Vloojup series me saara padhenge..choose offse sab..phir dubara ye videos seekhna aap..m sure aayega samajh
@@Innozant yes sir aapse bohot Kuch Seekh rha hoon or apki videos sabhi bohot informative Hoti hai or apka padhane Ka tareeka super best hai. Aisa Lagta hai Jaise aap psychologist ho or apko pata hai ke seekhne walo ke dimag me kya questions uthenge. You are the best teacher I have ever seen.🙏
Dear Sir
Really this is very informative tutorial. Highly appreciated that you accepted the request and shared the usage of offset function.
Thanks a lot Sir!!!! 🙏🙏
Yes Gulshan Ji,Wait for few days only.you may able the see all lookup function in depth...
It's really easy and helpful .
Your way of teaching is tremendous and very helpful.
Thanks Sharma Ji ..God bless You .Happy learning ❤️👍
Time Stamp @12:18 Sir, Sri Lanka ka value chart galat dikha raha hai...kyu ki hamne condition mein 0 rakha hai....aur Amla ki value bhi 0 h. So iss karan hamme Rabada ka value nai dikh raha h. Iska kya solution hoga.
Really very helpful video radio button working but score not Falucatuating in excel 2007 why it will not work
Really sir...osm
❤❤❤❤
बेहतरीन सर जी
Thanks
Sirji maja aa gaya
great video sir
Abhi aap step by step dekhna start kijiye dear..Kuch din baad feedback dena.Hows channel videos.🙏❤️🙂
@@Innozant Sir your video is Awesome and great useful
ye feedback hai 🙏🙏🙏🙏🙏
very nice sir
Namstai Sir Ji. You are very Good Teacher. Aapki wajah sai muje Dashboard muje achai sai aara hai. Mai aur tuotrial bhi dekhta tha Dashboard kai muje bahut tough lagta tha. Aap bahut hi neat & clean samjtai ho concepts ko. Sir interview mai Dashboard kai aisai hi questions puchai jaatai hai kya agar koi fresher ho?
Yes...kuch aur aane wale concept bhi dashboard ke helpful hoga..jal la ra hu apke liye dashboard step by step video..watch ,learn and apply gained knowledge in your work
When ever I am pasting radio button adjacently in same row then it gets jumped into another column
Why score was getting changed when you linked it to a cell after creating the radio button?
Sir it's amazing but I'm using Excel 2007 and there is no option of developer so pls give some idea
Sir m jab radio button ko cell s link krra hu toh 1,2,3,4... Jaise sequence nii aa raha...
India m 8, aus m 11....aise no. dera h.
Choose nii laga para m. What can be the problem.?
Dear aap radio button ek banaiye aur usika copy creat kar lijiye jitne chaiye.
Sir chart mai India and Australia kese le Raha hai jab app nai jab app nai select hi nahi kiya..
I am getting error if all score are zero. How to resolve it. I tried iferror but did not work
Excellent sir
Thanks
values are not changing in column
Super topic
Thanks Ramesh Ji
Chart title ka name change nhi ho rha hai
Thank you sir
Thanks dear
10:11
sir is question me ek doubt ara h.
apne jo score me "offset($M$5" liya h ,uski jgh "offset($N$5" le skte h kya?
aur agr nhi to kyo nhi?
please explain sir g🙏
Khud Check kijiye aur aap answer dena Ishu ki yadi hum offset Ka reference N5 par rakhenge to roe aur column ki value kya hogi..Btaiye pehle aap🙂Phir aap khud hi answer bhi doge aur mujhe samjhaoge bhi khud ki wo ref Lene ya na Lene Ka kya benefit.
@@Innozant
sir row and column me zero zero value hi rkhenge kyoki hme sirf score ki hi range chahiye na.
height me same countif lgayenge jo apne video me lgaya and width 1.
is time laptop available nhi h vrna debug krke jror check krti.
morning me hi check kr skti hu iska result.
Ok..Mujhse debug krke kal aap samjhaoge Ishu..Ki Kaisa Aapka offset kaam Kar rha hai..
Aajma wala Interview Cracker Dekh liye ?
Aal btana kitne question aap bina video dekhe Kar sakte Hain isme se ?
@@Innozant ok sir g
kl hi btati hu is question me problem ati h ya nhi.
mis cracker series dashboard ke bad start krungi sir starting se.
abhi nhi dekha koi bhi.
voto starting me kuch videos isliye dekh liye the apke kyoki interest unhi mis cracker vali videos se aya tha apke channel me.
bs dashboard ke bad unhi ka number h.
1 bhi video nhi chorna apke channel ka sir 🙏😊
Good Morning Ishu,Bilkul Sahi approach hai Aapka study krne ka,Pehle.saare concept clear Uske baad interview series attempt..Very nice 👍♥️
🙏
Agr kisi ne 0 run bnaya ho toh glt ho jyega.
Baki sab thik h magar sir 11:23 k time jo apne formula save karne k baad achanak chat change kese hogaya niche naam baar ka colour vo q skip kiye ? Ap sahi sahi batate batate achanak se kuch bhi karne lagte ho
Sir, aapne woh 5 Radio buttons keyboard se straight horizontal line mein kaise align kiya?
Ek saath select pehle kariye phir alignt
Hello Sir, I Clicked on Format Control- Control-Checked-3-D Shading and Cell Link. In Excel 1,2,3,4,5 is Showing when I clicked on States (India, Australia, England, South Africa and Sri Lanka). But scores not reflecting/moving/changed in main Table.
See the table value...just select that geadr instead of these number..see video again
Aur Sir aapne jo naming range ko dynamic kiya h offset use kr k score wale me usme Countif me jo range liya h wo range players se hi maine utha liya h kyuki score kisi ka 0 bi ho skta h aur agar hm "0" criteria pass kr dege to use problem aa rhi h...
0 se kyu prob Hoga..us wajah se to Aur Sahi na 0 wale player ko chart me show nhi krega.
@@Innozant haa to sir jb uske score wale me hm 0 criteria lgayege to jiska score 0 h use bi wo neglect kr dega to total count score ka kam ho jayega kyuki kisi player ka score agr 0 hua to wo use bi ni count kr payega pr hme aisa ni chahiye jiska player me bs 0 ho wo hme ni count krna na ki jin player ka score 0 ho use..
Aap jaldi jaldi short key batate Ho dheere batao sir Ji
Sure Pradeep ji
Hi Sir, There is but here, "Amla" a South Africa player scored "0" in the data but in map it is coming incomplete due to "0" logic in offset function, What will be the workaround here. Kindly check & confirm.
If Amla.scored 0 it will show 0 there as we use offset and counting for player not for value
@@Innozant Thanks, Got it 🙏
How to get developer in excel my excel doesn’t have it
Goto File-options-customize ribbon-Enable Developer Tab
Sir is dashboard me ek problem aa rhi h jaise jb bi kisi players ka score 0 ho rha to wo total players me se 1 kam kr ke chart me dikha rha h jaise south africa wale me Amla ne 0 score bnaye to uska jo chart bn rha usme Tahir tk hi data utha rha h last wala Rabada ka chodh de rha h.....??
Class time par connect krke check Kar lenge batana kya issue aa Raha hai
@@Innozant class kitne bje hoti h aur kaise connect krte h..??
Macro ka video kab ayega sir
Dashboard ke baad...Dnt worry..learn step by step
V nice video sir
Last wala part nahi samjha
Again repeat krje dekhiye video
🙏🙏🙏🙏🙏🙏🙏🙏🙏👌👌👌👌👌👌👌👌
Sir, muje iss format me data ek column (i.e. Zone), so ek hi zone kafi time repeat hua hai.... To usko kaise apply kar sakte hai???
Please suggest
I am using excel 2007.😅😅😅
Vaibhav Ab kamse Kam Excel 2013 to kar lijiye install itna kasht nhi katna hoga ☹️🙏
@@Innozant office ka hai sir.....😅😅😅😅 Can't help
Kya help chaiye dear..Office 13 link chaiye ?
Haan to office 2007 me bhi ho jayega..kya karna chahte h wo btaiye
@@Innozant sir, mere ek column A me zone hai aur B me HQ hai C me product and D me quarter/month... So muje aisa kuch krna hai k me zone k radio button pe click kr k data control kr saku..
👍💌