Тёмный

Dashboard Step by Step | How to Build Interactive Excel Dashboard | Beginners Guide In Hindi 

Innozant
Подписаться 149 тыс.
Просмотров 69 тыс.
50% 1

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

Опубликовано:

 

5 июл 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 188   
@SoumyaPodder
@SoumyaPodder Год назад
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.
@Innozant
@Innozant Год назад
Thanks Soumya for your love and support.Keep Learning..Keep Growing 👍
@GamingBasePoint
@GamingBasePoint 8 дней назад
mind blowing explaination sir hats off 😍😄😄😄
@mousamtour
@mousamtour Год назад
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
@QamarAbbas-dq3fh
@QamarAbbas-dq3fh Год назад
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
@rajibmukherjee9179
@rajibmukherjee9179 2 года назад
As always..very informative..thanx
@vv9730
@vv9730 Год назад
very nicely explained....
@monicajoshi4936
@monicajoshi4936 11 месяцев назад
Very nicely explained, 🎉 thanks
@ManishSharwinAmazingWorld
@ManishSharwinAmazingWorld 2 года назад
It's my interest in learning about Dashboard...Please guide me exactly how to start,I came across this video and understood all things
@Meditation5235
@Meditation5235 3 года назад
Simple way to explain such a wonderful dashboard method. Great sir!!! Thanks a lot.
@Innozant
@Innozant 3 года назад
Thanks Saurabh Ji❤️🙏 for such a lovely appreciation ❤️🙏
@aftabjaved4784
@aftabjaved4784 3 года назад
i m speechless cant find words to praise you. superb
@Innozant
@Innozant 3 года назад
thanks Aftab.. Really means a lot to me
@sanathsaja9840
@sanathsaja9840 Год назад
good lesson
@virendernegi7632
@virendernegi7632 3 года назад
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.
@Innozant
@Innozant 3 года назад
Dear Virender Negi Ji,Keep watching ,Learn and enhance your skills in regular basis.Will try to upload quality video everyday.Thanks .Tc
@binaykumarnayak9114
@binaykumarnayak9114 3 года назад
Thank you Sir for your energetic and simplified exclamations.
@Innozant
@Innozant 3 года назад
Thanks Binay ji
@karankapoor200
@karankapoor200 4 года назад
great video sir
@JuliPal-qt9pr
@JuliPal-qt9pr 9 месяцев назад
Very nice sir aap bhot hi acha samjate hain thanks dir
@Innozant
@Innozant 9 месяцев назад
Thanks
@shahzadsiddiqui5117
@shahzadsiddiqui5117 Год назад
You are the king of Excel...Respect
@Innozant
@Innozant Год назад
Thanks dear
@computerorigin7434
@computerorigin7434 2 года назад
Awsm sir You r great explainer
@hiteshchourey9730
@hiteshchourey9730 Год назад
Sirji, best video
@Innozant
@Innozant Год назад
Thanks Hitesh Ji.Keep learning
@artiverma5122
@artiverma5122 3 года назад
Apka hr vedio uneeq h, bhut acha smjatey h ap
@Innozant
@Innozant 3 года назад
Thanks Arti for your valuable Feedback..Seekhiye har roj kuch naya
@khalidmajeed2886
@khalidmajeed2886 2 года назад
Mashallah sir,,,,,,,,,,,,,,,,,,,,,,,,,bohat maza aaya..............great sir..Allah aap kaay ilm maay izafa karay.Aameen
@Innozant
@Innozant 2 года назад
Thanks Khalid sahab
@qayyumkhan5447
@qayyumkhan5447 2 года назад
simple and informative teaching style
@Innozant
@Innozant 2 года назад
Thanks Khan sahab❤️
@AmitSharma-xb8bi
@AmitSharma-xb8bi 2 года назад
Excellent
@anayetsobuj397
@anayetsobuj397 3 года назад
This is an amazing tutorial which i have ever seen.
@Innozant
@Innozant 3 года назад
Thanks Dear...Happy Learning dear.
@ManishSharwinAmazingWorld
@ManishSharwinAmazingWorld 2 года назад
Excellent Rating...
@shaikjaveed3934
@shaikjaveed3934 3 года назад
Thank you sir ji bahout badiya explan kiya hai app ne 🙂
@Innozant
@Innozant 3 года назад
Thanks Javeed sahab
@sudamakumar6469
@sudamakumar6469 2 года назад
Teacher ho to aap jaisa , aisa lgta jaise aap hath pakad kr Sikh rhe ho 🙏 u r great
@Innozant
@Innozant 2 года назад
Thanks dear..God bless
@aditiverma2452
@aditiverma2452 2 года назад
Thank you very much sir, I like the way you talk and make us understand things so easily. Thanks by heart.
@Innozant
@Innozant 2 года назад
Thanks Verma ji❤️❤️Recommend you to start your learning journey from playlist Basic Excel Onwards.
@kirankumarp8270
@kirankumarp8270 3 года назад
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.
@Innozant
@Innozant 3 года назад
You want the do dashboard only..if yes then star your learning journey from Povot table followed woth chat and dashboard.
@hemangiacharekar1999
@hemangiacharekar1999 Год назад
Thanks sir for this video, can i know how to delete tab incert from deloper bar
@shailenderkumar6112
@shailenderkumar6112 3 года назад
Great sir, this is fantasic function and very useful, seriously you are tremendous.
@Innozant
@Innozant 3 года назад
Thanks Shailender ji..God bless you..Happy learning.❤🙏
@mayurjain2003
@mayurjain2003 2 года назад
Sir, how to show our dashboard through web and it should be dynamic. Please tell me.
@Marathiboost
@Marathiboost 3 года назад
सर आप बहोत अच्छे से सिखा रहे हो.
@Innozant
@Innozant 3 года назад
Thanks dear
@mahathavenramasamy6890
@mahathavenramasamy6890 Год назад
Super
@jstips3558
@jstips3558 Год назад
Thanku sir
@kinghundred
@kinghundred 3 года назад
very nice sir
@RohitKumar-cc7zi
@RohitKumar-cc7zi 3 года назад
Excelent sir, you are Jenious and always Anspire us thanks a lot and just keep it up and do whatevere you want to do
@Innozant
@Innozant 3 года назад
Thanks Rohit.God bless you dear
@vijaykumarjain3222
@vijaykumarjain3222 3 года назад
Really nice
@Innozant
@Innozant 3 года назад
Thanks dear❤️🙏
@up-to-date1795
@up-to-date1795 2 года назад
Thanks you so much sir......🥰🥰
@Innozant
@Innozant 2 года назад
Thanks Shivam Ji
@sadashivkage3133
@sadashivkage3133 Год назад
TQ....sir
@manojsingh-mf1lg
@manojsingh-mf1lg 3 года назад
Really superb guruji 🙏
@Innozant
@Innozant 3 года назад
Thanks Manoj ji.❤❤
@SuhasKulkarni-pp8jl
@SuhasKulkarni-pp8jl 8 дней назад
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)
@hassaanmirza3942
@hassaanmirza3942 3 года назад
Excel's Great Teacher
@Innozant
@Innozant 3 года назад
Thanks ❤️❤️🙏
@muhammadanwer1033
@muhammadanwer1033 2 года назад
Job well done sir! Thanks
@Innozant
@Innozant 2 года назад
Thanks dear
@nevergiveup3475
@nevergiveup3475 2 года назад
Nice thanku sir
@Innozant
@Innozant 2 года назад
Thanks dear
@sakshimundra6384
@sakshimundra6384 2 года назад
I enjoyed making this mini dashboard with you
@Innozant
@Innozant 2 года назад
Thanks Sakshi.. KPI Dashboard 😀 bhi hai aage♥️♥️👍 God bless you.Happy Learning ❤️
@artiverma5122
@artiverma5122 2 года назад
You are superb
@Innozant
@Innozant 2 года назад
Thanks Arti
@dipakce
@dipakce Год назад
Sir ji Can we do Same with Pivot Table ,,
@NitinSharma-sr5rn
@NitinSharma-sr5rn 9 месяцев назад
The way you teaches the concept shows your confidence and indepth knowledge in your subject Plz sir upload a one shot excel course
@Innozant
@Innozant 9 месяцев назад
Thanks Sharma Ji. Excel video course is available ,Yoi may visit innozant website
@QamarAbbas-dq3fh
@QamarAbbas-dq3fh Год назад
jis ma driver ka over time b calculate ho jhy sath vehicle ka b record ah jhy
@riddhishah9574
@riddhishah9574 Год назад
Really very nice and helpful to begginers
@Innozant
@Innozant Год назад
Thanks Riddhi..Keep learning ❤️😊
@sahibvicky
@sahibvicky 2 года назад
Really very nice way to teach sir. Thanks
@Innozant
@Innozant 2 года назад
Thanks dear❤️❤️
@solehashaikh5749
@solehashaikh5749 2 года назад
Hii Sir ji, aap freeze kese kar rhe ho?koi shortcut hai kya uska??
@nehamaheshwari6900
@nehamaheshwari6900 11 месяцев назад
As i am applying +1 in vlookup formula its not working
@AshokKumar-el8nr
@AshokKumar-el8nr Год назад
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
@ritikkanojia9870
@ritikkanojia9870 4 года назад
Sir video bahut acchi bani hai
@Innozant
@Innozant 4 года назад
Thanks Ritik,Keep watching.
@rjraviraftarup7553
@rjraviraftarup7553 3 года назад
Really great sir 👍👌🙏
@Innozant
@Innozant 3 года назад
Thanks dear
@elinakhatoi7337
@elinakhatoi7337 2 года назад
Very nice
@Innozant
@Innozant 2 года назад
Thanks Elina...Keep Learning ♥️
@mdfirojansari887
@mdfirojansari887 Год назад
Sir combo box ka range select ni ho rha hai..ek hi cell par rah rha hai
@E_K18
@E_K18 Год назад
As always, your videos are a rescuer for me at the right moment❤️ many thanks, sir! Btw missing your classes, really good old days.
@Innozant
@Innozant Год назад
Thanks Ansh,Have a wonderful career ahead.God bless You..Soon will meet in Your Success Journey Podcast series with me.👍
@E_K18
@E_K18 Год назад
@@Innozant Sure sir, Thank you😇
@lovnishkumar5803
@lovnishkumar5803 Год назад
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.
@ShubhamSharma-rb1dj
@ShubhamSharma-rb1dj 2 года назад
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
@PrasantKumar-pc7bc
@PrasantKumar-pc7bc Год назад
HOW DID YOU BRING THE DATA IN BELOW TABLE WHERE YOU APPLIED VLOOKUP
@classs7474
@classs7474 Год назад
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
@chandrashekharbhosle65
@chandrashekharbhosle65 2 года назад
How to merged 2 graph dynamically
@lifejourney1669
@lifejourney1669 4 месяца назад
How the data get is linked for North, east, west
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Good sir app toh knowledge gain kar kar hi chhodege hamari
@Innozant
@Innozant 3 года назад
Love You ❤️🙏Gaurav Ji itna yakeen show Karne ke liye ..Main koshish Apne taraf se karta rahunga humesha Kuch naya sikhaun.
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Thnq sir
@surajrajput2752
@surajrajput2752 4 года назад
Sir is video ki tarif karne ke liye koi word hi nhi hai mere paas 😊 (owsm video)
@Innozant
@Innozant 4 года назад
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.
@monikamanchanda1626
@monikamanchanda1626 2 года назад
There is no like button highlight..... Awesome
@Innozant
@Innozant 2 года назад
Thanks Monika for your valuable appreciation God bless you .Keep learning ❤️👍
@monikakarar635
@monikakarar635 2 года назад
Please show dashboard link with formula and check box
@msexcelgooglesheet374
@msexcelgooglesheet374 3 года назад
Awesome sir ji
@Innozant
@Innozant 3 года назад
Thanks Dear
@msexcelgooglesheet374
@msexcelgooglesheet374 3 года назад
@@Innozant welcome sir ji 🙏
@pushpak5939
@pushpak5939 2 года назад
Ise mail pe report ki tarah kaise publish kare ?
@RakeshKumar-hn2jc
@RakeshKumar-hn2jc 2 года назад
when i create month wise result value is not correct
@AdeKaryadi
@AdeKaryadi 3 года назад
nice video, thanks
@Innozant
@Innozant 3 года назад
Thanks Ade❤️🙏
@ayezuddinali2032
@ayezuddinali2032 3 месяца назад
But is not working at ms Excel 2021
@ishutiwari5567
@ishutiwari5567 3 года назад
sir developer tab ka combo box vhi same kaam to krra h jo data validation ka list+ match function krta h
@Innozant
@Innozant 3 года назад
Good hai..haan wahan position khud bta deta hai yahan apko match se pta krna hota h relative position
@pa2happiness13
@pa2happiness13 3 года назад
Thanks Sir💞
@Innozant
@Innozant 3 года назад
Thanks
@pa2happiness13
@pa2happiness13 3 года назад
@@Innozant sir aap kaa sb trick super hai 💞
@tagaiajay20
@tagaiajay20 Год назад
Sir I want to learn excel please reply jarur dena
@sunitadakare7903
@sunitadakare7903 2 года назад
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 🙏
@Innozant
@Innozant 2 года назад
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
@RahulRoy-po9ct
@RahulRoy-po9ct 6 месяцев назад
🙏
@FarhanAli-um7zn
@FarhanAli-um7zn 2 года назад
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
@FarhanAli-um7zn
@FarhanAli-um7zn 2 года назад
Will be very thankfull of you for this act of kindness
@Innozant
@Innozant 2 года назад
Ok dear..noted
@FarhanAli-um7zn
@FarhanAli-um7zn 2 года назад
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
@shubhrawat1011
@shubhrawat1011 Год назад
Sir V Look formula Not applied Don't know why
@Innozant
@Innozant Год назад
What happen
@sagarmathur3535
@sagarmathur3535 3 года назад
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...
@Innozant
@Innozant 3 года назад
Haan..start kariye ab chart..No issue
@sagarmathur3535
@sagarmathur3535 3 года назад
@@Innozant please create what's app link so that we can share problem of excel
@sagarmathur3535
@sagarmathur3535 3 года назад
I mean what's app group
@virendersroha1754
@virendersroha1754 4 года назад
Sr isme ek baat smjh ni aayi vlookup me index value 1+1 kyu Direct 2 kyu ni Plss reply
@Innozant
@Innozant 4 года назад
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
@indianpigeon3680
@indianpigeon3680 3 года назад
Bhai power bi ke interview Questions par video bana do
@Innozant
@Innozant 3 года назад
Pehle power pivot and power query finish krke phir beaten h
@tanushreechakraborty5827
@tanushreechakraborty5827 2 года назад
Last few days I'm trying this offset formula but every time it's showing#na please help me to solve the problem
@Innozant
@Innozant 2 года назад
Hi Tanushree .kindly share your query on @innozantofficial telegram id. What problem you are facing ij offset formula ?
@avneeshyadav8734
@avneeshyadav8734 Год назад
Sir mere main developer tab show nhi ho rha hai ..
@Innozant
@Innozant Год назад
File-options-customize ribbon Developer tab uncheck hoga use check krke ok press kr dien
@faheemurehman7800
@faheemurehman7800 4 года назад
great vidio but work book download nahi ho rahi
@Innozant
@Innozant 4 года назад
Thanks Faheem Ji for your valuable feedback. Ab check kijiye link misplace ho gya tha.. download it and do practice.
@johndas8173
@johndas8173 2 года назад
Sir excel Jatadhari interview crack series kab aayega sir excel par dhyan do
@Innozant
@Innozant 2 года назад
Kuch time se busy hone ki wajajse videos nhi bana pa rhe hain..March se phir saare videos series aane lagenge dear..
@shubhrawat1011
@shubhrawat1011 Год назад
Sir How to freeze the formula
@Innozant
@Innozant Год назад
Using F4...basic excel se learning start kriye
@nikhilrustagi5161
@nikhilrustagi5161 Год назад
ITS AND URGENT REQUIRED FOR MAKE A DASHBOARD BECAUSE THIS DASHBOARD SEND TILL THE TONIGHT FOR INTERVIEW PROCESSING
@ayazali1716
@ayazali1716 9 месяцев назад
Plz write here formula
@pushkalupadhyay
@pushkalupadhyay 3 года назад
Sir forcast analysis par vedios milengai kya
@Innozant
@Innozant 3 года назад
Abhi upload nahi kiye hain forcast analysis videos...jarur krenge pehle conceptual saare topic finish kar lein
@pushkalupadhyay
@pushkalupadhyay 3 года назад
@@Innozant actually I need trand analysis so pls fast uploade kariye sir even I m ready to pay your fees sir
@pushkalupadhyay
@pushkalupadhyay 3 года назад
@@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
@pushkalupadhyay
@pushkalupadhyay 3 года назад
@@Innozant sir pls reply me
@Innozant
@Innozant 3 года назад
Nahi video bane hue nhi hai..m working on that
@Creativerachu
@Creativerachu 9 месяцев назад
how to freeze cell?
@Innozant
@Innozant 9 месяцев назад
Using F4 key.kindly start leqrning from basic excel-The learning begins playlist
@Marathiboost
@Marathiboost 3 года назад
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
@Innozant
@Innozant 3 года назад
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
@tanushreechakraborty5827
@tanushreechakraborty5827 2 года назад
Hi sir
@syedali3755
@syedali3755 3 года назад
How you use freez in formula
@Innozant
@Innozant 3 года назад
Using F4 dear
@syedali3755
@syedali3755 3 года назад
@@Innozant thank you
@syedali3755
@syedali3755 3 года назад
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?
@syedali3755
@syedali3755 3 года назад
Can I get your number please
@rakeshky1000
@rakeshky1000 3 года назад
Sir aap kaunse company me work karte hai?..exp aacha hai aapka
@Innozant
@Innozant 3 года назад
Thanks Rakesh Ji😊Hope aapko videos pasand aate honge aur aap unse seekhte honge.Happy Learning
@rakeshky1000
@rakeshky1000 3 года назад
@@Innozant lekin aap baki ke form control nahi cover kiye..
@Innozant
@Innozant 3 года назад
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
@tarjitmalka3978
@tarjitmalka3978 4 года назад
🌟🌟🌟🌟🌟
@samrao98
@samrao98 2 года назад
Purchase dashboard bhi banado
@Innozant
@Innozant 2 года назад
👍❤️
@sagarmathur3535
@sagarmathur3535 3 года назад
Sir aapki videos sequence mein nahi milti...
@Innozant
@Innozant 3 года назад
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)
Далее
EXCEL DASHBOARD CREATION STEP BY STEP IN HINDI
34:04
Просмотров 101 тыс.
В GEOMETRY DASH СДЕЛАЛИ GTA
00:27
Просмотров 690 тыс.
НОВАЯ ПАСХАЛКА В ЯНДЕКСЕ
00:20
Просмотров 491 тыс.
📊 How to Build Excel Interactive Dashboards
19:21
Просмотров 2,4 млн
8 Excel tools everyone should be able to use
18:31
Просмотров 2,3 млн
Build Awesome Excel Visuals to Grab Anyone's Attention
18:11
В GEOMETRY DASH СДЕЛАЛИ GTA
00:27
Просмотров 690 тыс.