Тёмный

INDEX MAHARAJ | Awesome 3 Realtime Excel problem & Index Solution 

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

INDEX MAHARAJ | Awesome 3 Realtime Excel problem & Index Solution
Excel Maharaj Playlist link- • EXCEL MAHARAJ - For Ex...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#innozant#indexmaharaj#excelmaharaj#indexmatchfunctioninhindi
#exceltutorial

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

 

14 июн 2022

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 89   
@sudhirhiwale9784
@sudhirhiwale9784 2 года назад
I never feel lazy to watch your videos as videos are not lengthy. You save our time and increase our knowledge. And the most important thing is that you come up with good problems with great solutions. Thank you very much sir.
@Innozant
@Innozant 2 года назад
Thanks Sudhir ji.. Really means a lot to me..God bless you..keep learning ❤️
@createyour6681
@createyour6681 2 года назад
Very Great Sir
@rahulprasad9198
@rahulprasad9198 2 года назад
Sir... mujhe bahut daar lagta...jab aap bade bade approach lagte ho questions ko solve karne... Mujhe self doubt hota hai ki main kar pauga ki nahi... EXcel sikhne mein.
@Innozant
@Innozant 2 года назад
Ohho..dar kis baat ka..jitna practice krte jayenge..nikharte jayenge dear aap
@MohanLal-tv1ix
@MohanLal-tv1ix Год назад
गुरुजी नमस्ते, लॉकडाउन में आपकी MIS series देख के excel सीखा है I इस वीडियो में दो minutes हुए तब आपने index की range B2:L8 ली जबकि आउटपुट रेंज B1:L1 होनी चाहिये था , पर जब video में पता नहीं चला कि Range कब ठीक की I और जहाँ फार्मूला insert किया वहाँ background colour dark है पता नहीं चलता कि क्या type किया है , 45 की age से ज़्यादा में थोड़ी problem होती है I बहुत useful है ये video. office में कई बार इसे use किया हैI कृपया ऐसे और video भी डालें I धन्यवाद I
@Innozant
@Innozant Год назад
Thanks Mohan JimmJaroor banayenge aur videos
@rajparihar4856
@rajparihar4856 2 года назад
Very helpful video sir👌👌
@asmrindia
@asmrindia 2 года назад
Wow Great Thanks Sirji Om Sai Ram
@Innozant
@Innozant 2 года назад
Thanks dear
@saahilsaahil5912
@saahilsaahil5912 2 года назад
simply superb👌
@sonukumarskp6933
@sonukumarskp6933 2 года назад
Vlookup ke Jayda hm Index use karte hai ... Bahout most important formula hai ye
@Innozant
@Innozant 2 года назад
Yes very true
@SanjeetKumar-yx2oc
@SanjeetKumar-yx2oc 2 года назад
Great logic....i was trying this type of problem sir....abhi bhe mujhe mera wala question jyda tangg kar raha h sir... Agar same isi question m , Naina sharma continues 03 September to 04 September tak rahti hei, again Naina leave chali jati h 06 September to 08 september then sir agar Naina ki summary banai jaye, jisme naina kab se kab leave jati hei, then 4 column [(from)(to), (From) (to)] mein uski leave detail date wise aa jaye....please isko or jyda explore kryega sir... sir ur skills of teaching is wonderful, abhi tak itna seekha h to vo bhi aapse hi seekha h....
@arpannandy961
@arpannandy961 2 года назад
Thank you sir....Without your excellent teaching nothing is possible to grow.❤❤❤❤❤
@Innozant
@Innozant 2 года назад
Thanks Arpan ji..Happy learning ❤️
@ramakantarana3400
@ramakantarana3400 2 года назад
Thank you ❤️ sir ji
@hitraj1705
@hitraj1705 2 года назад
You are great sir amazing ♥️♥️
@shubhamgupta392
@shubhamgupta392 2 года назад
Fabulous these three index maharaj queries... ❤️
@Innozant
@Innozant 2 года назад
Thanks dear
@KuldeepSingh-nq1vi
@KuldeepSingh-nq1vi 2 года назад
Man gaye Sir, Dil jeet liya aapke ending Note ne.
@Innozant
@Innozant 2 года назад
Thanks Kuldeep ji❤️
@manojkumarsingh3385
@manojkumarsingh3385 2 года назад
Always great video upload sir Last me ending note to ❤️ ko chhu jati hai🙏🙏🙏
@Innozant
@Innozant 2 года назад
Thanks Manoj Ji..God bless You
@kishorpanara4191
@kishorpanara4191 2 года назад
Man gaye aapko sir
@raj0936
@raj0936 2 года назад
Sir vlookup ,if function ,match, index and miscellaneous of all a ek separate Playlist bana dijiye sir
@Innozant
@Innozant 2 года назад
Already playlist hai lookup and reference function ka
@TheSuvankarKundu
@TheSuvankarKundu 2 года назад
Keep helping us and keep growing sir.. Much respect ☺
@Innozant
@Innozant 2 года назад
Thanks dear
@aoasoyal4272
@aoasoyal4272 2 года назад
awesome......
@durgeshrai8938
@durgeshrai8938 2 года назад
Nyc sir
@AnkitKumar-gs3bv
@AnkitKumar-gs3bv 2 года назад
very nice dear
@Altaf_Alam
@Altaf_Alam 2 года назад
Hii sir ji 😀 plz VBA macro per aur video laiye❤️❤️
@satishojha6240
@satishojha6240 2 года назад
Phir se revise ho gaya sir thanku. Good night
@Innozant
@Innozant 2 года назад
Good hai...good night ❤️
@SaurabhSharma-ry8iz
@SaurabhSharma-ry8iz 2 года назад
Kar diya sir
@shalujain6332
@shalujain6332 2 года назад
Happy to see notification of this channel..
@Innozant
@Innozant 2 года назад
Thanks Shalu.. Really means a lot to me❤️❤️
@user-fp1wo5qz6l
@user-fp1wo5qz6l 2 года назад
Last line osm sir ji
@Innozant
@Innozant 2 года назад
Thanks dear
@sawaimalhi8439
@sawaimalhi8439 2 года назад
First comment
@Me-ow5rw
@Me-ow5rw 2 года назад
Hi Sir, I want to find correspondence column and cell of these two results area and want to highlight through conditional formatting. I able to find the cell value in excel through this formulas =CHAR(64+COLUMN(INDEX(B1:L1,MATCH(E12,B1:L1,0))))&ROW(INDEX(A2:A8,MATCH(D12,A2:A8,0))) how to light the result cell
@balamira297
@balamira297 Год назад
2nd ques we can use filter func with transpose as well sir. Formula: transpose(filter($B$2:$B$29,$A$2:$A$29=$F2))
@Innozant
@Innozant Год назад
👍Think beyond office 365 as this application is not available for all now
@swasi001
@swasi001 Год назад
Hi please help me with a question which is a pain to me I have a range of table. It have first column as city where I have multiple cities, column 2nd have 4 product names which are repeating for each city(of column 1) and 3rd to 90th column I have the no of sold for each product every week. I want to sum the total sold of a particular product based on column 1 and 2. Please advise
@anan___hkla____6922
@anan___hkla____6922 2 года назад
Superb Sir....
@Innozant
@Innozant 2 года назад
Thanks dear Shuklaji❤️👍
@golmaal935
@golmaal935 2 года назад
Waah... 👍Keep uploading
@Innozant
@Innozant 2 года назад
Thanks dear
@monsterspubggaming51
@monsterspubggaming51 2 года назад
Sir how to use index with vlookup for rows and columns please make video on this
@RahulRoy-po9ct
@RahulRoy-po9ct 11 месяцев назад
🙏
@MIS_PRODUCTION_AAA
@MIS_PRODUCTION_AAA 2 года назад
thanks sir, please make vidio on vba
@Innozant
@Innozant 2 года назад
👍♥️
@Me-ow5rw
@Me-ow5rw 2 года назад
Question No.1
@Me-ow5rw
@Me-ow5rw 2 года назад
My question is "I want to highlight the leave as well." through conditional formatting. Help me
@arjunspata1913
@arjunspata1913 2 года назад
Nice 👍🙏 sir
@Innozant
@Innozant 2 года назад
Thanks
@sakshamdhiman565
@sakshamdhiman565 3 месяца назад
Sir jb main data ko usi sheet main kisi or jagah rakh rha hoon to ref error aa rha hai plzz iska solution bta dijiye
@mashailfurqan5150
@mashailfurqan5150 Год назад
I have a dataset that is 4x4. I want to see what formula will bring out the desired output. I have tried index& match, data validation with offsets. I still think it can get better please let me know where I can share my table with you. I will really appreciate your response on this.
@Innozant
@Innozant Год назад
Watch index maharaj series
@secretkingstatus9343
@secretkingstatus9343 Год назад
Last question bahut eazy tha
@Innozant
@Innozant Год назад
👍
@mohammedsalwan382
@mohammedsalwan382 2 года назад
Is it possible to use sum , average and count functions together in single subtotal operation ?
@Innozant
@Innozant 2 года назад
What kind of output you are looking for
@mohammedsalwan382
@mohammedsalwan382 2 года назад
@@Innozant Sir, For example i have a student marksheet and i want to calculate total marks of students, average and count functions together in Single subtotal? It will work? This question asked me in test.
@pawankumardk9399
@pawankumardk9399 2 года назад
Aaj der ho gayi sir ji 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
@Innozant
@Innozant 2 года назад
❤️❤️
@ryanhawk366
@ryanhawk366 2 года назад
mast sikhate hain aap bhai please i need your help please sir encourage me i am not expert in excel
@Innozant
@Innozant 2 года назад
Thanks.. No one is expert ..Devote your time in excel..after some time you may feel the difference
@ryanhawk366
@ryanhawk366 2 года назад
@@Innozant thanks sir i really appreciate it and i respect you but sir really you are amazing and i want you to bring us new videos 4 within a week
@RaviVerma-fs4cp
@RaviVerma-fs4cp 2 года назад
Sir can u please tell me what will be the fee of SQL * I will be preffered online mode of class
@Innozant
@Innozant 2 года назад
Hi Ravi Kindly connect with Innozant team or visit Innozant website for more details about love classes
@RaviVerma-fs4cp
@RaviVerma-fs4cp 2 года назад
@@Innozant I am fan of your level of understanding logics and yours too . Keep it up and make us star as you are.
@sathishvijay6934
@sathishvijay6934 2 года назад
#ref sir first index, showing
@Me-ow5rw
@Me-ow5rw 2 года назад
Please provide file link
@Innozant
@Innozant 2 года назад
Ok..will share it today
@ashishshiriskar123
@ashishshiriskar123 2 года назад
Sir full to bounce 😂
@Innozant
@Innozant 2 года назад
❤️❤️❤️
@hitraj1705
@hitraj1705 2 года назад
Sir are great but sad to see your videos views 😔😔😔😔
@Innozant
@Innozant 2 года назад
Koi nahi....aayega samajh ek din viewers ko.
@golmaal935
@golmaal935 2 года назад
Mujhe notification nahi aata hai aapka new video upload hota hai to
@Innozant
@Innozant 2 года назад
Ek baar unsubscribe karke dubara subscribe kriye aur notification me all kar dena ..ok👍♥️
@golmaal935
@golmaal935 2 года назад
Okay
@hrhelpteam
@hrhelpteam 2 года назад
Practice Sheet bhi To Daalo karo sir, vo milta nahi hai. itna folder main.
@Innozant
@Innozant 2 года назад
Ok...kal update hoga practice sheet ka link
@hrhelpteam
@hrhelpteam 2 года назад
Great👏👏😊😊 thanks sir
@spsubir1451
@spsubir1451 2 года назад
Excel Sikh ke kya hoga? Kaha job job milega? Kuch nehi hota bekar ki chiz hai
@Innozant
@Innozant 2 года назад
Itna demotivated. Yadi seekhke kuch nhi hota to ye jo lakhon log hain jo padh rahe hain kyu?? Bekar ki cheej nhi ..ye apki frustration hai...Ya aapne ek do jagah try krke chor diya... Sayad excel seekhke hi bht log bht ache profile par hain..
@spsubir1451
@spsubir1451 2 года назад
@@Innozant kaise mujhd job milega excel ka advance course karke.? Aap bataiye plz
Далее
Top 5 Excel Unseen Productivity Tricks
8:19
Просмотров 10 тыс.
Index Match Multiple Header & Challenge Question
10:12
Top 5 Excel Productivity Tricks
9:43
Просмотров 12 тыс.