Top 5 Ultimate Advanced Excel Tips and Tricks-You must Know
Вставка
- Опубліковано 5 жов 2024
- Top 5 Ultimate Advanced Excel Tips and Tricks-You must Know
Download Practice Set - bit.ly/47QWyxA
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
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/innozanti...
#innozant #exceltricks #exceltipsandtricks#exceltutorial
Q no. 3
❤=COUNTA(OFFSET(A1, MATCH(H1,A2:A11,0),1,1,4))
❤=VLOOKUP(H1,TABLE,COUNTA(OFFSET(A1, MATCH(H1,A2:A11,0),1,1,4))+1, 0)
THANK U SIR, ye sara logic laga pa raha hu because of you ❤😊
Q no. 5 (my attempt)
=sum(offset(a1, match(f3, a2:a9, 0) 1,1,3))
We can extract the same output with help of index function as well..
Thnk u my dear sir ❤
Namaste sir,aap ne toh power query ka series Lana hi band kar diya
Nice Video Sir
Sir Kya Excel Ki Ek Hi Sheet Me 2 ya Jyada Tables Banaye Ja Sakte Hain?
Ha Bhai bana sakte hai
लास्ट डायलॉगस आर व्हेरी इंप्रेषिव सर जी 👍
Thanks.keep growing
Last wording is very useful in life
Great Video Sir thanks
Great video sir
Sir excel me sheet and sheets formula window 2010 me kaam karega
Hello I have a 1 question I don't understand question is emp. Name - ronnie kumar
Require data without kumar
Substitute function is not working please help
Hi,
Nice video.
Regards.
Shakeel Ahmad
Karachi, Pakistan.
Hello sir thanks for made your channel today I got a job on mis executive by your videos as a fresher.😀😀
Congratulations..have a wonderful career ahead.
Sir please Power Query, Power Pi Board and power Bi ka video banayaaa....
Sir i have question if I have to find Out "DATE OF BIRTH" FROM AGE GIVEN , HOW COULD I DO THAT? PLEASE HELP
good efforts to teach and helping us through journey. but brother kia ap batasakte hain ek vba k through hum list ke mutabiq sheets with same format copy karsakte hain. matlab ek form hai jis main humain ek khas jagah par wo value paste karni hai aur jahan list khatam wahan same sheets with form and format bhi khatm.
Very Nice !
Plz upload power bi course in easy way
Thank you sir. Amazing info.
Value added content 🎉😊sir ✌️💯
Sir, for trick number 1 sumproduct can also be used in place of Sumif
Sir please make series on SQL
Hello Sir.. Which software you use to record your screen? The screen recording quality is too good. Please reply...
Helpful video sir 😍
Sir power bi ki playlist ko continue krdo
Bhot acha smjahaya thank u
we can use the given below formulas to find the total number of payment methods and the last payment method for that particular payment id- =COUNTA(OFFSET(A1,MATCH(H1,A2:A11,0),):OFFSET(OFFSET(A1,MATCH(H1,A2:A11,0),),,4))
=INDEX(OFFSET(A1,MATCH(H1,A2:A11,0),):OFFSET(OFFSET(A1,MATCH(H1,A2:A11,0),),,4),,H2)
Sir SQL ki series bhi padhao please
Nice sir❤❤❤
Please make auto-update Google sheets from Google finance for India stocks
You are the Master of Excel.🫡
Paji, Can u please Show Method, How to covert Total VALUE/ AMOUNT in words automatically
Kindly watch spellnumber video
Question 3
=sum(Filter(array,productrange="nokia",""))
LOVE U SIR
Killer sir I need mi and ai series pl
Sir I Have One Question sir agar mere pass values hai ek cell mai like 23+90+678+9076 toh mujhe iska sum chahiye textsplit se toh ho raha hai but iske alawa aur koi formula hai toh So please reply the answer sir
Sir ek hi cell mei 2 ya 3 date ko formula se kese laye. Jese 26,27&28 Jan 2024
Sir we need power BI videos
Visit innozant website
Waha to hai par u tube par nahi aarahe latest
I'm trying first trick but not working correctly ? Why?
😍❤❤❤
Sorry Sir,
Trick No. 05 wrong function
Because in case of lookup function the very first column has to sorted but in this case our data hasn't sorted.
Its not a wrong function ,Its understood that in case of lookup fubction your data must be sorted ij ascending order