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

[@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]

Thanks Soumya for your love and support.Keep Learning..Keep Growing 👍

[@Rajput.Brand_]

Sir aap explain bhut hi ache se krte ho ❤❤ kafi kuch sikhne ko milta h apse ❤ Thank you so much 🎉🎉

[@Innozant]

Thanks dear..happy learning

[@artiverma5122]

Apka hr vedio uneeq h, bhut acha smjatey h ap

[@Innozant]

Thanks Arti for your valuable Feedback..Seekhiye har roj kuch naya

[@SwetaShaw-g3u]

Excellent explanation, first time m watching ur video, I really understood ur topic ... Thank you so much

[@Innozant]

Keep learning...Learn videos in sequence from playlist.

[@khalidmajeed2886]

Mashallah sir,,,,,,,,,,,,,,,,,,,,,,,,,bohat maza aaya..............great sir..Allah aap kaay ilm maay izafa karay.Aameen

[@Innozant]

Thanks Khalid sahab

[@virendernegi7632]

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]

Dear Virender Negi Ji,Keep watching ,Learn and enhance your skills in regular basis.Will try to upload quality video everyday.Thanks .Tc

[@shahzadsiddiqui5117]

You are the king of Excel...Respect

[@Innozant]

Thanks dear

[@sudamakumar6469]

Teacher ho to aap jaisa , aisa lgta jaise aap hath pakad kr Sikh rhe ho 🙏 u r great

[@Innozant]

Thanks dear..God bless

[@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

[@NitinSharma-sr5rn]

The way you teaches the concept shows your confidence and indepth knowledge in your subject Plz sir upload a one shot excel course

[@Innozant]

Thanks Sharma Ji. Excel video course is available ,Yoi may visit innozant website

[@Meditation5235]

Simple way to explain such a wonderful dashboard method. Great sir!!! Thanks a lot.

[@Innozant]

Thanks Saurabh Ji❤️🙏 for such a lovely appreciation ❤️🙏

[@GamingBasePoint]

mind blowing explaination sir hats off 😍😄😄😄

[@monicajoshi4936]

Very nicely explained, 🎉 thanks

[@qayyumkhan5447]

simple and informative teaching style

[@Innozant]

Thanks Khan sahab❤️

[@riddhishah9574]

Really very nice and helpful to begginers

[@Innozant]

Thanks Riddhi..Keep learning ❤️😊

[@aftabjaved4784]

i m speechless cant find words to praise you. superb

[@Innozant]

thanks Aftab.. Really means a lot to me

[@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]

Thanks Ansh,Have a wonderful career ahead.God bless You..Soon will meet in Your Success Journey Podcast series with me.👍

[@E_K18]

@@Innozant Sure sir, Thank you😇

[@Marathiboost]

सर आप बहोत अच्छे से सिखा रहे हो.

[@Innozant]

Thanks dear

[@anwarrza00]

The way you tought it's from deep of heart , I want to learn under your guidance. Pls suggest how to join .

[@Innozant]

You may connect us or visit innozant website for more details about live class

[@kirankumarp8270]

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]

You want the do dashboard only..if yes then star your learning journey from Povot table followed woth chat and dashboard.

[@binaykumarnayak9114]

Thank you Sir for your energetic and simplified exclamations.

[@Innozant]

Thanks Binay ji

[@RohitKumar-cc7zi]

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]

Thanks Rohit.God bless you dear

[@hassaanmirza3942]

Excel's Great Teacher

[@Innozant]

Thanks ❤️❤️🙏

[@shaikjaveed3934]

Thank you sir ji bahout badiya explan kiya hai app ne 🙂

[@Innozant]

Thanks Javeed sahab

[@aditiverma2452]

Thank you very much sir, I like the way you talk and make us understand things so easily. Thanks by heart.

[@Innozant]

Thanks Verma ji❤️❤️Recommend you to start your learning journey from playlist Basic Excel Onwards.

[@JuliPal-qt9pr]

Very nice sir aap bhot hi acha samjate hain thanks dir

[@Innozant]

Thanks

[@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]

As always..very informative..thanx

[@EkamAndNoor]

Really very nice way to teach sir. Thanks

[@Innozant]

Thanks dear❤️❤️

[@SuhasKulkarni-pp8jl]

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)

[@shailenderkumar6112]

Great sir, this is fantasic function and very useful, seriously you are tremendous.

[@Innozant]

Thanks Shailender ji..God bless you..Happy learning.❤🙏

[@SharwinAmazingWorld]

It's my interest in learning about Dashboard...Please guide me exactly how to start,I came across this video and understood all things

[@anayetsobuj397]

This is an amazing tutorial which i have ever seen.

[@Innozant]

Thanks Dear...Happy Learning dear.

[@gauravbhatia7987]

Good sir app toh knowledge gain kar kar hi chhodege hamari

[@Innozant]

Love You ❤️🙏Gaurav Ji itna yakeen show Karne ke liye ..Main koshish Apne taraf se karta rahunga humesha Kuch naya sikhaun.

[@gauravbhatia7987]

Thnq sir

[@hiteshchourey9730]

Sirji, best video

[@Innozant]

Thanks Hitesh Ji.Keep learning

[@sakshimundra6384]

I enjoyed making this mini dashboard with you

[@Innozant]

Thanks Sakshi.. KPI Dashboard 😀 bhi hai aage♥️♥️👍 God bless you.Happy Learning ❤️

[@computerorigin7434]

Awsm sir You r great explainer

[@vv9730]

very nicely explained....

[@pa2happiness13]

Thanks Sir💞

[@Innozant]

Thanks

[@pa2happiness13]

@@Innozant sir aap kaa sb trick super hai 💞

[@manojsingh-mf1lg]

Really superb guruji 🙏

[@Innozant]

Thanks Manoj ji.❤❤

[@surajrajput2752]

Sir is video ki tarif karne ke liye koi word hi nhi hai mere paas 😊 (owsm video)

[@Innozant]

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.

[@AmitSharma-xb8bi]

Excellent

[@ritikkanojia9870]

Sir video bahut acchi bani hai

[@Innozant]

Thanks Ritik,Keep watching.

[@sanathsaja9840]

good lesson

[@karankapoor200]

great video sir

[@muhammadanwer1033]

Job well done sir! Thanks

[@Innozant]

Thanks dear

[@up-to-date1795]

Thanks you so much sir......🥰🥰

[@Innozant]

Thanks Shivam Ji

[@artiverma5122]

You are superb

[@Innozant]

Thanks Arti

[@SharwinAmazingWorld]

Excellent Rating...

[@vijaykumarjain3222]

Really nice

[@Innozant]

Thanks dear❤️🙏

[@monikamanchanda1626]

There is no like button highlight..... Awesome

[@Innozant]

Thanks Monika for your valuable appreciation God bless you .Keep learning ❤️👍

[@AdeKaryadi]

nice video, thanks

[@Innozant]

Thanks Ade❤️🙏

[@jstips3558]

Thanku sir

[@rjraviraftarup7553]

Really great sir 👍👌🙏

[@Innozant]

Thanks dear

[@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

[@hemangiacharekar1999]

Thanks sir for this video, can i know how to delete tab incert from deloper bar

[@msexcelgooglesheet374]

Awesome sir ji

[@Innozant]

Thanks Dear

[@msexcelgooglesheet374]

@@Innozant welcome sir ji 🙏

[@nevergiveup3475]

Nice thanku sir

[@Innozant]

Thanks dear

[@ishutiwari5567]

sir developer tab ka combo box vhi same kaam to krra h jo data validation ka list+ match function krta h

[@Innozant]

Good hai..haan wahan position khud bta deta hai yahan apko match se pta krna hota h relative position

[@QamarAbbas-dq3fh]

jis ma driver ka over time b calculate ho jhy sath vehicle ka b record ah jhy

[@mahathavenramasamy6890]

Super

[@sagarmathur3535]

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]

Haan..start kariye ab chart..No issue

[@sagarmathur3535]

@@Innozant please create what's app link so that we can share problem of excel

[@sagarmathur3535]

I mean what's app group

[@kinghundred]

very nice sir

[@sadashivkage3133]

TQ....sir

[@solehashaikh5749]

Hii Sir ji, aap freeze kese kar rhe ho?koi shortcut hai kya uska??

[@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.

[@bhoopendraraghav9781]

Very nice

[@Innozant]

Thanks Bhoopendra,Keep learning and share with others.

[@ShubhamSharma-rb1dj]

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

[@sunitadakare7903]

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]

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

[@mdfirojansari887]

Sir combo box ka range select ni ho rha hai..ek hi cell par rah rha hai

[@dipakce]

Sir ji Can we do Same with Pivot Table ,,

[@mayurjain2003]

Sir, how to show our dashboard through web and it should be dynamic. Please tell me.

[@pushkalupadhyay]

Sir forcast analysis par vedios milengai kya

[@Innozant]

Abhi upload nahi kiye hain forcast analysis videos...jarur krenge pehle conceptual saare topic finish kar lein

[@pushkalupadhyay]

@@Innozant actually I need trand analysis so pls fast uploade kariye sir even I m ready to pay your fees sir

[@pushkalupadhyay]

@@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]

@@Innozant sir pls reply me

[@Innozant]

Nahi video bane hue nhi hai..m working on that

[@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

[@PrasantKumar-pc7bc]

HOW DID YOU BRING THE DATA IN BELOW TABLE WHERE YOU APPLIED VLOOKUP

[@FarhanAli-En7]

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-En7]

Will be very thankfull of you for this act of kindness

[@Innozant]

Ok dear..noted

[@FarhanAli-En7]

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

[@lifejourney1669]

How the data get is linked for North, east, west

[@nehamaheshwari6900]

As i am applying +1 in vlookup formula its not working

[@indianpigeon3680]

Bhai power bi ke interview Questions par video bana do

[@Innozant]

Pehle power pivot and power query finish krke phir beaten h

[@johndas8173]

Sir excel Jatadhari interview crack series kab aayega sir excel par dhyan do

[@Innozant]

Kuch time se busy hone ki wajajse videos nhi bana pa rhe hain..March se phir saare videos series aane lagenge dear..

[@pushpak5939]

Ise mail pe report ki tarah kaise publish kare ?

[@tagaiajay20]

Sir I want to learn excel please reply jarur dena

[@shubhrawat1011]

Sir How to freeze the formula

[@Innozant]

Using F4...basic excel se learning start kriye

[@syedali3755]

How you use freez in formula

[@Innozant]

Using F4 dear

[@syedali3755]

@@Innozant thank you

[@syedali3755]

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]

Can I get your number please

[@RakeshKumar-hn2jc]

when i create month wise result value is not correct

[@anitanongkhlaw]

Remove the cell colour where u enter vlookup function

[@shubhrawat1011]

Sir V Look formula Not applied Don't know why

[@Innozant]

What happen

[@tanushreechakraborty5827]

Last few days I'm trying this offset formula but every time it's showing#na please help me to solve the problem

[@Innozant]

Hi Tanushree .kindly share your query on @innozantofficial telegram id. What problem you are facing ij offset formula ?

[@RahulRoy-po9ct]

🙏

[@rakeshky1000]

Sir aap kaunse company me work karte hai?..exp aacha hai aapka

[@Innozant]

Thanks Rakesh Ji😊Hope aapko videos pasand aate honge aur aap unse seekhte honge.Happy Learning

[@rakeshky1000]

@@Innozant lekin aap baki ke form control nahi cover kiye..

[@Innozant]

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

[@avneeshyadav8734]

Sir mere main developer tab show nhi ho rha hai ..

[@Innozant]

File-options-customize ribbon Developer tab uncheck hoga use check krke ok press kr dien

[@virendersroha1754]

Sr isme ek baat smjh ni aayi vlookup me index value 1+1 kyu Direct 2 kyu ni Plss reply

[@Innozant]

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

[@chandrashekharbhosle65]

How to merged 2 graph dynamically

[@nikhilrustagi5161]

ITS AND URGENT REQUIRED FOR MAKE A DASHBOARD BECAUSE THIS DASHBOARD SEND TILL THE TONIGHT FOR INTERVIEW PROCESSING

[@Creativerachu]

how to freeze cell?

[@Innozant]

Using F4 key.kindly start leqrning from basic excel-The learning begins playlist

[@Marathiboost]

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]

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

[@monikakarar635]

Please show dashboard link with formula and check box

[@faheemurehman7800]

great vidio but work book download nahi ho rahi

[@Innozant]

Thanks Faheem Ji for your valuable feedback. Ab check kijiye link misplace ho gya tha.. download it and do practice.

[@tanushreechakraborty5827]

Hi sir

[@ayezuddinali2032]

But is not working at ms Excel 2021