Top 5 Ultimate Advanced Excel Tricks With Bonus Question

Top 5 Ultimate Advanced Excel Tricks With Bonus Question
Download Practice Set - bit.ly/4bsGh54
===========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 #top5exceltricks

[@nabialam6804]

Thanks sir jab lagne lagta h ki kafi kuch seekh liya h Excel me par jab aapki video dekhta hu to lagta h abhi aur seekhana h very useful video

[@Innozant]

Keep learning

[@T5AGamerz]

Same

[@caa22]

Really learnt amazing unexplored tricks which is much required in daily use, thank you😊

[@anjaligulatiamb_123]

Sir, sach bat btanj thi..meine first apki hi playlists dekhi Excel ki..usk Baad ..mein or sub ki bhi dekhi..
But finally meine apki videos ko hi approach kiya hai becz mughe Issey jyada appropriate work khin nhi mila.thank you so much .🎉

[@Innozant]

Thanks Anjali,Really means a lot to me..Keep growing ❤️

[@ankurghosh7734]

SIR THANKS FOR YOUR AWESOME VIDEO TUTORIAL

[@Innozant]

Thanks

[@swadealhadecooking5587]

Sir very useful tricks.🙏🙏
Apni khub bhalo explain koren. Onek upokar peyechi upnar theke.
Power BI start korechi apnar playlist theke.
Thank you Sir 😊🙏

[@mitulnandkeolyar1514]

अपने comment khub bhalo lagche
Ami ekta new channel start korchi power bi related
I hope you like the channel
@Nishant Nandkeolyar13289

[@asmrindia]

Yes Sir
Very True
Jai Shree Ram
Jai Hanumaan
Thanks
Date Picker, Developer Tab Se Liya Ja Sakta H.

[@sakshamdhiman565]

Sir insert tab main jaaker get add ins main date picker add krenge isse calander open hota hai jisse hum date pick ker skte hai

[@Altaf_Alam]

Good evening sir 😊
Thank u so much my dear sir ❤😊

[@dipak5651]

Superb tricks and great lines in the end because you are a superb personality.❤

[@Innozant]

Keep learning

[@arvindtech408]

Ekdum jabarjast guru ji

[@Innozant]

Keep learning

[@ritikjeenwal4951]

Thank you sir apse bohot kuch sikha maine thank you soo much..
Ye videos banate rahiye ga aap please🙏🙏

[@md.moslehuddinuddin4077]

Excellent! Thank you very much.

[@YKSharma9]

Date Picker: (a) for previous versions of Excel third party date pickers can be added using add-ins. (b) Excel 365 has added Mini Calender (go to Home tab - at last of Home tab click on Add-ins and select "Mini Calender" after use one can delete the same from current file (click on small button at top right - delete). in future, can use date picker again using same steps. Thanks.

[@arijeetkumarsharma226]

No words. How much I love your videos, Guruji.

[@Innozant]

Thanks..Keep Learning

[@devangagarwal3717]

Can you make a video to show a amount in terms of lakhs, crores, thousands
Example like if we have to make a balancesheet

[@vinayaksharma4131]

Very helpful video, sir ek aur help kr dijiye freelance job kaise milega bahut try kr rahe hai but mil nhi Raha hai

[@anilkumarsahoo8780]

Yes bro, I need also job in excel

[@AnilBineeta1993]

Thanks for your motivational speech

[@narayanbhave3020]

Thanks sir

[@khurramyaqub1568]

Great

[@sunnymanav7694]

Nice video sir

[@balkarSingh-iy8pw]

Ram Ram ji sir

[@A-R-V]

Superb sir....

[@davidsonsunny2886]

Zabardast Bhai. No words

[@manojchaursia6501]

Nice video

[@sivareddy3745]

Hi Brow How are you. Your explanation is very good and nice.

[@Learnwithvirendrakumar]

Sir, ham data validation ke thuru double click kar ke date pic kar skte hai.

[@wasfar4528]

Excellent Sir KARACHI PAKISTAN

[@rajendrashriwas9254]

super tricks Thankyou

[@sandeepgoswami9921]

Very nice sir 🎉

[@createyour6681]

great video sir

[@premchandsagar157]

Thank you sir ji ❤❤

[@subhasismondal1984]

❤❤❤ Great sir...

[@SHEERAZ-ALI]

Use addin date picker

[@umermanzoor7077]

Sir power BI ki videos continue kar den main bohat time se wait kar raha hn 😢

[@jishankhan-hw8io]

Nice one sir 😮

[@smoothdiycreative]

=sumif(range,"#n/a") Entre sum error

[@Nirajkwc70]

Love you sir ❤❤

[@user-ol4de1bi5e]

Date Picker bta dijiye Sir

[@SonuKumar-cx6ny]

General pr short date selection?

[@AmitKumar-vs7hl]

Use addin for date picker

[@situsahoo2482]

❤❤👌👌❤️❤️

[@sanjugalande]

Waiting your power BI videos

[@NiteshVishwakarma042]

Sir Basic To Advance Ki Video

[@asimali5820]

Plz explain date picker too

[@Mlbb_Nothing_Gaming]

Running total ka tho - Ctrl+R sai ho Jay go sir

[@bandhuupadhyay3401]

Hello sir i have a excel related problem can you solve this plss
Problem
Sir supose three columns
1st having some part number repeatedly 2nd have remarks against that part number in every row now i have to write all that remark in one cell against only unique part number plzz sir

[@Innozant]

Kindly share worksheet with query explanation @innozantofficial telegram I'd

[@ShankarKumar-po3jb]

Sir kal me interview me fail ho gya.
Rakesh H D K Singh
Isme se first name , middle name aur last name alag karna tha formule se. Apne jesa paraya tha left , mid aur right se alag karna usse to ye nhi ho paya .
Sir ye H D K middle name he , ye alag nhi ho paya , sir aap bataye ye kese hoga

[@vijaysharma-sk3nl]

Crt+:

[@prajwalshetty2047]

❤

[@DeepakSharma-zj7em]

Sir 🫂🙏❤️♾️🕉️💓

[@vijaykumarjain3222]

Very nice video sir

[@hsgusain2054]

Thanks Sir

[@manjit.sarania]

Very nice video sir