Index Maharaj | Excel Interview Realtime Problem & Solution
Вставка
- Опубліковано 13 гру 2023
- Index Maharaj | Excel Interview Realtime Problem & Solution
===========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 #exceltricks #indexformula#indexmaharaj
Sir main Apka Eh subscriber hun mere Ko apki videos Dekhte huye 2 saal Ho chale hai apki badolat ajj main ek ashi post par hun sir Thanq so much pehle meri Id Gaurav BHATIA ke naam ki thi Abhi change Ki hai sir Thanq so so much because apke formulas ke sath hi kaam karta hun main Abhi tak yaad hai mere Ko pivot table advance micro hamara Sab ka favourite sumproduct 😂 is sumproduct se excel mein Kam Karna ehsan hogeya sir thnq again so much sir good bless you bother
last wala simple hai index(productareey,match(large(sales arrey,1),salers arey,0)) issey bhi nikal jayega kuki ager interviewer boley index ke hi through nikalna ho toh
thanku for your support you are a good not best teacher 😃
=index(product name range, match(max(grade range), grade range))
Thank u my dear sir ❤
Very powerful function index
Excellent Sir g
Hello sir. First of all thanks a lot for sharing video like this. My question is max grade 9 is for Lyf and Nokia so how we can fetch all max grade value not only for first matching Lyf nokia as well?
❤All the content Very much need ful .#Sum product Series superb with Dilip sir ❤❤
Sir aap se bahut kuch seekhne ko mila🎉
2. Sum(e3:index(sales range, j7)) 😊❤
Excellent video
great video sir
Sir ,good lesson ,but for 4th questions sortn is best formula
12,5,45,65,8,4,3 ye ek cell pe likha hua tha or iska sum Krna with the use of formula
Note-
*The system supports Excel 2007 version*
Only use of formula
No use of copy paste and not use text to column
Love and Respect to you sir🙏❤️
Practice Practice Practice 😊
Great sir❤❤❤
Superb sir ji isi tarah ms access par bhi beginning se Advance ka video daliye sir please
Thanks sir
आफ़ताबे हुस्न तेरा मोहब्बत ए काबिल हुआ हुई नज़रे
शर्म से तार तार जब दिल मे वो शामिल हुआ हुस्ना
मोहब्बत के कुछ लब्ज़ अभी बाकी है वो दिल अभी
बाकी है वो जान अभी बाकी है 🌹🌹🌹
Hi sir ..thanks for your every teaching video....sir me apka sare video dekhta reheat hu ...sir Mera ek questions tha ..question ye hai ki colored cells kaise count karate hai with out vb code se .plz iska upar ek video banaye sir ji ..👍
Colored cell count ka ek video bayate sir plzz
Sir as usual you are top of Excel world ❤
Thanks dear
Very very beneficial and helpful content thanq sir dil se
Thanks dear
Sir you too good.. your all videos inspired me ..
Thanks dear
sir agar laptop mein ms excel ki jagah wps office se assignment complete karsakte haina ?
Sum of sales whose represenative name starts with letter R
=SUMIF(B2:B21,"R*",D2:D21)
Sir mujhe mathematics aur excel mein interest hai kya koi aesi job hai jisme na toh mera excel ka aur math ka dono ka sath bana rahe hai kyonki dono hi mujhe pasand hai.
Sir please koi suggestion dijiye ki mujhe apna kadam kiski aur badhana chahiye Excel ka sath chor du ya math ka ya dono ko hi leke aage kis job mein ja sakhta hu
Sir main confused hun please batayein ki math aur excel dono ke combination ki koi job hai mere liye kya kerna chahiye
Mera career roadmap kya hoga excel+mathematics based skill ke liye
Sir Aisa hi Excel mai maharaj series banaya Karoo. Bahut mast lagta hai aise questions ko aap se phele solve karne mai..
Thanks ..Sure dear
Sr power bi plz do vdos
Please Explain Any Formula For Monthly Attendance Sheet Continues more than 3 Off + including Leave Countinues without a Punch
Sir ek video aapke paid advance excel course hai or jo youtube ka contant hai unme kya difference hai kya sbhi playlist jinme ab ab video upload nahi hui hai peechle 2 saalo mei kya wo complete ho chuki hai ya or video aaenge jaise
Dashboard series
Or chart series
Power pivot
Please sir details m btaiye😇
Nokia has also maximum grade 9
Plz power bi in easy way as u do
sir please aise questions ki aur bhi sheets le aao
Sir I Have One Question Sir Agar mujhe Pta lgana ho ki Iss cell ya Range me Special Character hai ki nhi with use of Formula Toh kaise Pta lagayenge. Aur data esa hai Data: Sure$h$ Kumar), Mansi# Please Reply Sir...
Where is the practice file sir?
Find link in video description
Hello sir,
Really sir you so are bad because of I was say you loot of comments please make video on how to get job related advance excel. 🙏🙏
Kindly watch career guide video sereis for job guidance also nite that this is learning channel not job consultancy
Sr power bi plz do vdos