Dashboard Step by Step | How to Build Interactive Excel Dashboard | Beginners Guide In Hindi
ฝัง
- เผยแพร่เมื่อ 5 ก.ค. 2020
- 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.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#dashboard#exceldashboard#Innozant #dashboardtutorial
![แฉ [2/4] 12 ก.ค. 67 เจ้าของไวรัลดังในโซเชียล 'ลิลลี่ เหงียน' ฝันอยากเข้าวงการ โดนหลอกสารพัด | GMM25](http://i.ytimg.com/vi/7zntQK2U8-8/mqdefault.jpg)
![[TH] VCT Pacific Stage 2 - Playoffs Day 3 // DRX vs GEN | PRX vs TLN](http://i.ytimg.com/vi/CWM1Q-2-o3M/mqdefault.jpg)
you have the ultimate depth knowledge in excel & its uses, you are ,just an artist or a Guru, who knows all the creation...bahut , magic dikhane wala sasta teacher bhi dekh liya, but un sabhi ko agar aap ke samne byatha diya jaye to un log ka asli aukat nikal ke aa jayega...because, they make videos for earning money, unka content ke ilaba, kuch bahar se topic de diya jayega, to sabhi ka hawa fussss ho jayega. But sir, you spread knowledge, inspiration, motivation, kyun ki sara kuch aap ke andar hain...really you are my inspiration & true motivation of learning excel with interest.
Thanks Soumya for your love and support.Keep Learning..Keep Growing 👍
Apka hr vedio uneeq h, bhut acha smjatey h ap
Thanks Arti for your valuable Feedback..Seekhiye har roj kuch naya
mind blowing explaination sir
hats off
😍😄😄😄
Simple way to explain such a wonderful dashboard method. Great sir!!! Thanks a lot.
Thanks Saurabh Ji❤️🙏 for such a lovely appreciation ❤️🙏
I am really fond of seeing your videos as there are lots of things which is unknown to me can be easily learnt. May God Bless You in your future a
Thank you Sir for your energetic and simplified exclamations.
Thanks Binay ji
As always..very informative..thanx
Very nicely explained, 🎉 thanks
i m speechless cant find words to praise you. superb
thanks Aftab.. Really means a lot to me
simple and informative teaching style
Thanks Khan sahab❤️
Thank you very much sir, I like the way you talk and make us understand things so easily. Thanks by heart.
Thanks Verma ji❤️❤️Recommend you to start your learning journey from playlist Basic Excel Onwards.
This is an amazing tutorial which i have ever seen.
Thanks Dear...Happy Learning dear.
Awsm sir
You r great explainer
Sir I have learned dashboard from an institute but it was not closely explained..but the way of your explanation about dashboard, it's very easy to understand and completely explain. I am happy that I m your subscriber.
Dear Virender Negi Ji,Keep watching ,Learn and enhance your skills in regular basis.Will try to upload quality video everyday.Thanks .Tc
very nicely explained....
great video sir
Excelent sir, you are Jenious and always Anspire us thanks a lot and just keep it up and do whatevere you want to do
Thanks Rohit.God bless you dear
Great sir, this is fantasic function and very useful, seriously you are tremendous.
Thanks Shailender ji..God bless you..Happy learning.❤🙏
Thank you sir ji bahout badiya explan kiya hai app ne 🙂
Thanks Javeed sahab
Excellent
You are the king of Excel...Respect
Thanks dear
good lesson
Excellent Rating...
It's my interest in learning about Dashboard...Please guide me exactly how to start,I came across this video and understood all things
सर आप बहोत अच्छे से सिखा रहे हो.
Thanks dear
Very nice sir aap bhot hi acha samjate hain thanks dir
Thanks
Thanku sir
Really superb guruji 🙏
Thanks Manoj ji.❤❤
Really very nice way to teach sir. Thanks
Thanks dear❤️❤️
Excel's Great Teacher
Thanks ❤️❤️🙏
I have recently came through your videos and i must say they are indeed very informative and insightful. I'm in process of learning Dashboard so please guide from where should i begin my journey.
You want the do dashboard only..if yes then star your learning journey from Povot table followed woth chat and dashboard.
Job well done sir! Thanks
Thanks dear
Mashallah sir,,,,,,,,,,,,,,,,,,,,,,,,,bohat maza aaya..............great sir..Allah aap kaay ilm maay izafa karay.Aameen
Thanks Khalid sahab
Sirji, best video
Thanks Hitesh Ji.Keep learning
Sir ap bhot best person ha main ak semi organization ma computer py kam krta hoin actually mugy driver ka over time and vehicle maintenance record wagra ko excel py banana ha auto tor py gari ka num enter kryin to detail show ho jhy
TQ....sir
The way you teaches the concept shows your confidence and indepth knowledge in your subject
Plz sir upload a one shot excel course
Thanks Sharma Ji.
Excel video course is available ,Yoi may visit innozant website
Really very nice and helpful to begginers
Thanks Riddhi..Keep learning ❤️😊
Teacher ho to aap jaisa , aisa lgta jaise aap hath pakad kr Sikh rhe ho 🙏 u r great
Thanks dear..God bless
I enjoyed making this mini dashboard with you
Thanks Sakshi..
KPI Dashboard 😀 bhi hai aage♥️♥️👍
God bless you.Happy Learning ❤️
very nice sir
There is no like button highlight..... Awesome
Thanks Monika for your valuable appreciation God bless you .Keep learning ❤️👍
Really great sir 👍👌🙏
Thanks dear
Super
As always, your videos are a rescuer for me at the right moment❤️ many thanks, sir! Btw missing your classes, really good old days.
Thanks Ansh,Have a wonderful career ahead.God bless You..Soon will meet in Your Success Journey Podcast series with me.👍
@@Innozant Sure sir, Thank you😇
Really nice
Thanks dear❤️🙏
nice video, thanks
Thanks Ade❤️🙏
Sir video bahut acchi bani hai
Thanks Ritik,Keep watching.
sir very nice one secrate you have kept ,the values which were selection not having suffics "$" hence error showing , eg =VLOOKUP(A12,$A$1:$J$9,$K$3+1,0)
Thanks you so much sir......🥰🥰
Thanks Shivam Ji
You are superb
Thanks Arti
Nice thanku sir
Thanks dear
Very nice
Thanks Elina...Keep Learning ♥️
Thanks sir for this video, can i know how to delete tab incert from deloper bar
Awesome sir ji
Thanks Dear
@@Innozant welcome sir ji 🙏
Thanks Sir💞
Thanks
@@Innozant sir aap kaa sb trick super hai 💞
Sir, how to show our dashboard through web and it should be dynamic. Please tell me.
Sir ji Can we do Same with Pivot Table ,,
Sir is video ki tarif karne ke liye koi word hi nhi hai mere paas 😊 (owsm video)
Thanks Suraj for wonderful feedback,It really motivates me a lot and gives me reason to make good content that adds some value in students Life.
Good sir app toh knowledge gain kar kar hi chhodege hamari
Love You ❤️🙏Gaurav Ji itna yakeen show Karne ke liye ..Main koshish Apne taraf se karta rahunga humesha Kuch naya sikhaun.
Thnq sir
Sir ak request hai,agar excel me calculator kese banate hai basic to advanced level ka kuch video upload kar dete to thoda help ho jata
🙏
Sir kindly reply... I was asked an question in interview that how to count alphabet.. like
A
a
A
A
How many capital A in this range.. kindly reply
jis ma driver ka over time b calculate ho jhy sath vehicle ka b record ah jhy
I need our help, regarding chat for our construction sites quality issue, year wise (Actually issue type also many, year also many , project also many,) i need on one graph
Hello Sir I want to pursue my career in Business Intelligence analyst please guide me which are main things to learn so that i start my career quickly.
How to merged 2 graph dynamically
Hii Sir ji,
aap freeze kese kar rhe ho?koi shortcut hai kya uska??
sir developer tab ka combo box vhi same kaam to krra h jo data validation ka list+ match function krta h
Good hai..haan wahan position khud bta deta hai yahan apko match se pta krna hota h relative position
As i am applying +1 in vlookup formula its not working
HOW DID YOU BRING THE DATA IN BELOW TABLE WHERE YOU APPLIED VLOOKUP
How the data get is linked for North, east, west
Please show dashboard link with formula and check box
Hi sir, Earning much knowledge from your videos, i would like to draw your attention, please make industrial daily weekly monthly yearly report dashboard which includes plan/actual production raw material consumption yield% quality,supply..Thanks
Will be very thankfull of you for this act of kindness
Ok dear..noted
Sir am still waiting your response
Can you please share dashboard video as i need on my E-mail address???
I shall be very thankful to u for this act of kindness
Bhai power bi ke interview Questions par video bana do
Pehle power pivot and power query finish krke phir beaten h
Sir combo box ka range select ni ho rha hai..ek hi cell par rah rha hai
ITS AND URGENT REQUIRED FOR MAKE A DASHBOARD BECAUSE THIS DASHBOARD SEND TILL THE TONIGHT FOR INTERVIEW PROCESSING
Hi sir
Sir I want to learn excel please reply jarur dena
Sir muze complete excel aur usame dashboard bhi sikhana hai, apaka 1 vedio mene dekha hai apa bahut acchi tarah se padate hai plz sir 🙏
Hi Sunita.
.Aap Basic excel playlist se start kijiye seekhana(Announcement playlist me jaiye whan ek video maine bnaya hai mis learning process wo vidoe dekhiye ki kaise padhai karna hai sequence me)
Assignment download kar lijiye aur practice regular basis par
🌟🌟🌟🌟🌟
Ise mail pe report ki tarah kaise publish kare ?
when i create month wise result value is not correct
But is not working at ms Excel 2021
Sir isko dekhne kee baad kya charts series start kar sakte hai...konse chart kab use kiya jata hai...jaise gauge chart,Gantt chart, waterfall chart so on...
Haan..start kariye ab chart..No issue
@@Innozant please create what's app link so that we can share problem of excel
I mean what's app group
Sir How to freeze the formula
Using F4...basic excel se learning start kriye
Sir excel Jatadhari interview crack series kab aayega sir excel par dhyan do
Kuch time se busy hone ki wajajse videos nhi bana pa rhe hain..March se phir saare videos series aane lagenge dear..
Sir V Look formula Not applied Don't know why
What happen
how to freeze cell?
Using F4 key.kindly start leqrning from basic excel-The learning begins playlist
Sir forcast analysis par vedios milengai kya
Abhi upload nahi kiye hain forcast analysis videos...jarur krenge pehle conceptual saare topic finish kar lein
@@Innozant actually I need trand analysis so pls fast uploade kariye sir even I m ready to pay your fees sir
@@Innozant but I need all topics of trend analysis agar aapke pass bane huye ho to aap mail kar de mujhe jo apki fees ho me pay karne ke liye ready hu
@@Innozant sir pls reply me
Nahi video bane hue nhi hai..m working on that
Plz write here formula
Last few days I'm trying this offset formula but every time it's showing#na please help me to solve the problem
Hi Tanushree .kindly share your query on @innozantofficial telegram id.
What problem you are facing ij offset formula ?
Purchase dashboard bhi banado
👍❤️
Sir aap kaunse company me work karte hai?..exp aacha hai aapka
Thanks Rakesh Ji😊Hope aapko videos pasand aate honge aur aap unse seekhte honge.Happy Learning
@@Innozant lekin aap baki ke form control nahi cover kiye..
Dear Rakesh abhi Dashboard ke basics hi start hue hain..Aage aane wale videos me saare form control cover honge Aisa koi topic nhi hoga Excel se related ki aapko is channel par na mile..but time lagega usme thora ..step by step seekhte chaliye
Sir mere main developer tab show nhi ho rha hai ..
File-options-customize ribbon
Developer tab uncheck hoga use check krke ok press kr dien
great vidio but work book download nahi ho rahi
Thanks Faheem Ji for your valuable feedback.
Ab check kijiye link misplace ho gya tha.. download it and do practice.
Sr isme ek baat smjh ni aayi vlookup me index value 1+1 kyu
Direct 2 kyu ni
Plss reply
Virender ji humne drop down list bnaya haina ab usme sequence kya hai region ka ex-north ka 1st position South ka 2nd and so on....vlookup ko dynamic banaye rakhna h isliye hume index no. Ki value drop-down list se lena hai ..yes or no..?yes..ab aap dekho yadi main usme 1 plus nhi krunga to wo to pehle column ki value le lega..jo humen nhi chaiye..
Aap keh re ki 2 likh do sidhe phir index no ka drop down list se koi link hi nahi reh jayega na dear..ab saamjh aayega sayad ..ya ap dubara video repeat krke dekhiye maine btaya hua hai.thanks
How you use freez in formula
Using F4 dear
@@Innozant thank you
Friend, when I have raw data contain absenteeism, Bill to pay score, schedule adherence and 2 more. These are call center data on daily basis. I want it to present on dashboard. Can u make a video on it please?
Can I get your number please
Sir aapki videos sequence mein nahi milti...
Sagar ji ...Aisa sequence me course aapko mil hi nahi sakta guaranteed.
Dear aaap direct uploadrd video dekh rahe hain.. Playlist wise topic dekhiye.
Eg..start with Basic Excel Playlist-73 videos hain use finish nkrne ke baad (aap kisi bhi lateset video ke description me jaake dekhen aapko videos in sequence playlist dikhega.usi sequence me course karna hai)
Bus value jab freeze karte ho to wo bata do .. ki kaha freeze karni he is bar apne 2 bar freez ki aur ek hu bar bataya
Pehalevali value freeze kiya vo nahi bataya dusari vali value freeze ki vo bataya vlookup ke doran
10.17 to 10.18 time
Dear pehle aap cell reference ke video dekhen basic excel playlist se..in sequence yadi playlist wise seekhenge to ye prob nhi aaygi..
Videos in sequence playlist available hain video description me