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.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 #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😊

[@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

[@asmrindia]

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

[@ankurghosh7734]

SIR THANKS FOR YOUR AWESOME VIDEO TUTORIAL

[@Innozant]

Thanks

[@Altaf_Alam]

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

[@md.moslehuddinuddin4077]

Excellent! Thank you very much.

[@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

[@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

[@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 ❤️

[@Learnwithvirendrakumar]

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

[@ritikjeenwal4951]

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

[@balkarSingh-iy8pw]

Ram Ram ji sir

[@AnilBineeta1993]

Thanks for your motivational speech

[@A-R-V]

Superb sir....

[@narayanbhave3020]

Thanks sir

[@khurramyaqub1568]

Great

[@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.

[@sunnymanav7694]

Nice video sir

[@davidsonsunny2886]

Zabardast Bhai. No words

[@manojchaursia6501]

Nice video

[@sivareddy3745]

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

[@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

[@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

[@rajendrashriwas9254]

super tricks Thankyou

[@wasfar4528]

Excellent Sir KARACHI PAKISTAN

[@subhasismondal1984]

❤❤❤ Great sir...

[@arijeetkumarsharma226]

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

[@Innozant]

Thanks..Keep Learning

[@createyour6681]

great video sir

[@premchandsagar157]

Thank you sir ji ❤❤

[@SHEERAZ-ALI]

Use addin date picker

[@jishankhan-hw8io]

Nice one sir 😮

[@sandeepgoswami9921]

Very nice sir 🎉

[@umermanzoor7077]

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

[@user-ol4de1bi5e]

Date Picker bta dijiye Sir

[@Nirajkwc70]

Love you sir ❤❤

[@smoothdiycreative]

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

[@NiteshVishwakarma042]

Sir Basic To Advance Ki Video

[@Mlbb_Nothing_Gaming]

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

[@AmitKumar-vs7hl]

Use addin for date picker

[@sanjugalande]

Waiting your power BI videos

[@prajwalshetty2047]

❤

[@situsahoo2482]

❤❤👌👌❤️❤️

[@SonuKumar-cx6ny]

General pr short date selection?

[@asimali5820]

Plz explain date picker too

[@vijaysharma-sk3nl]

Crt+:

[@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

[@DeepakSharma-zj7em]

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

[@hsgusain2054]

Thanks Sir

[@manjit.sarania]

Very nice video sir

[@vijaykumarjain3222]

Very nice video sir