Top 5 Ultimate Advanced Excel Tips and Tricks-You must Know

Подписаться 154 тыс.

Просмотров 11 тыс.

50% 1

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

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

3 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 47

@Altaf_Alam 5 месяцев назад

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 ❤😊

@VinodThakur-v2b Месяц назад

लास्ट डायलॉगस आर व्हेरी इंप्रेषिव सर जी 👍

@Innozant Месяц назад

Thanks.keep growing

@ChandrakalaChouhan-jt5cj 7 месяцев назад

Sir excel me sheet and sheets formula window 2010 me kaam karega

@Altaf_Alam 5 месяцев назад

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 ❤

@manishmandal3942 8 месяцев назад

Namaste sir,aap ne toh power query ka series Lana hi band kar diya

@psangram007 6 месяцев назад

Last wording is very useful in life

@KaranSaim 8 месяцев назад

Hello sir thanks for made your channel today I got a job on mis executive by your videos as a fresher.😀😀

@Innozant 8 месяцев назад

Congratulations..have a wonderful career ahead.

@createyour6681 8 месяцев назад

Great Video Sir thanks

@ranvir0392 8 месяцев назад

Great video sir

@adnanbhatti8452 8 месяцев назад

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.

@SHAKEELAHMAD-kt9fs 8 месяцев назад

Hi, Nice video. Regards. Shakeel Ahmad Karachi, Pakistan.

@asmrindia 8 месяцев назад

Nice Video Sir Sir Kya Excel Ki Ek Hi Sheet Me 2 ya Jyada Tables Banaye Ja Sakte Hain?

@Lofemusic471 8 месяцев назад

Ha Bhai bana sakte hai

@Lord_itachi15 8 месяцев назад

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

@Abhishekkumar-nv4se 8 месяцев назад

Sir power bi ki playlist ko continue krdo

@syedfaraz1903 8 месяцев назад

Plz upload power bi course in easy way

@vasimshaikh5833 8 месяцев назад

Value added content 🎉😊sir ✌️💯

@Master.Jiraiya 8 месяцев назад

Sir i have question if I have to find Out "DATE OF BIRTH" FROM AGE GIVEN , HOW COULD I DO THAT? PLEASE HELP

@KaranSaim 8 месяцев назад

Question 3 =sum(Filter(array,productrange="nokia",""))

@gandhisunil3 8 месяцев назад

Sir, for trick number 1 sumproduct can also be used in place of Sumif

@utsabsana 8 месяцев назад

Sir please Power Query, Power Pi Board and power Bi ka video banayaaa....

@mohammedasifshaikh622 8 месяцев назад

Very Nice !

@nirupmamishra5230 8 месяцев назад

Helpful video sir 😍

@Apna_tahlka_123 8 месяцев назад

Bhot acha smjahaya thank u

@nehaaggarwal1618 5 месяцев назад

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)

@ganeshshelkar4333 7 месяцев назад

Sir please make series on SQL

@shrikantbadge3978 8 месяцев назад

Thank you sir. Amazing info.

@rashidkhan8467 8 месяцев назад

Sir SQL ki series bhi padhao please

@pappubora506 8 месяцев назад

Sir ek hi cell mei 2 ya 3 date ko formula se kese laye. Jese 26,27&28 Jan 2024

@jayshankar4658 8 месяцев назад

LOVE U SIR

@laiquekhan10415 8 месяцев назад

You are the Master of Excel.🫡

@rks_92 8 месяцев назад

Hello Sir.. Which software you use to record your screen? The screen recording quality is too good. Please reply...

@gajendersingh6825 8 месяцев назад

Nice sir❤❤❤

@nikhilthedreamer4339 8 месяцев назад

Please make auto-update Google sheets from Google finance for India stocks

@vijayrattan973 8 месяцев назад

Paji, Can u please Show Method, How to covert Total VALUE/ AMOUNT in words automatically

@Innozant 8 месяцев назад

Kindly watch spellnumber video

@vikaskohli1375 8 месяцев назад

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

@pranalisuryawanshi7909 6 месяцев назад

I'm trying first trick but not working correctly ? Why?

@MIS_PRODUCTION_AAA 8 месяцев назад

Killer sir I need mi and ai series pl

@surjeetyadavlifeexperience4752 7 месяцев назад

😍❤❤❤

@sanjugalande 8 месяцев назад

Sir we need power BI videos

@Innozant 8 месяцев назад

Visit innozant website

@sanjugalande 8 месяцев назад

Waha to hai par u tube par nahi aarahe latest

@gaukarangaurav 8 месяцев назад

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.

@Innozant 8 месяцев назад

Its not a wrong function ,Its understood that in case of lookup fubction your data must be sorted ij ascending order