Top 5 Ultimate Advanced Excel Tips and Tricks

[@Umairbusinessvlog]

Mind-blowing not only this I watched 4 lectures regarding advance tricks....

[@Innozant]

Thanks dear

[@Bhasotra]

This is the best approach for solving the all problems in few seconds , I love it sir ❤❤

[@raselzamadder276]

From Bangladesh You are My BOSS in excel learning

[@Innozant]

Thanks Rasel ❤️🙏Happy learning❤️🙏

[@ramsiromanidixit7322]

Ur videos are truly amazing.....very helpful for working professionals

[@Innozant]

Thanks Ram

[@Creative_Samarpana]

It was nice to clear that last tak video dekho and second thing sath sath excel pr try kro tabhi kuch fayda h 👍👍 Again amazing 😃

[@uswahiqbal8288]

Sir, you are great teacher

[@Innozant]

Thanks dear..Keep learning ❤️

[@vanistajames346]

The way you explain the formula is amazing thank you so much and yes I've subscribed your channel☺

[@Innozant]

Thanks Vanisha , Really means a lot to me.Keep Learning And Keep Exploring👍❤️

[@HarpreetSingh1991]

Thanks i was looking for this duplicate formula I need it . I tried myself before but don't have solution now I do. So happy. Usually I was selecting all range .

[@Innozant]

Thanks dear

[@Sarita_Classes]

I am a real big fan of your sir.... Your all videos helps me.... Many ways.... I love your teaching style.... And also follows it.... When I am with my students.... I just remember your teaching style... And follow it... In my... Class... All my students... Are felling happy 🥰🥰🥰🥰🥰

[@Innozant]

Thanks Sarita..Really means a lot to me..Wow is it true ?❤🙏Hope these video are helpful and adds some values in your life..

[@mahimasharma8662]

I do not have word to praise you Sir

[@Innozant]

Thanks Mahima .Really means a lot to me dear.❤❤🙏🙏

[@superNareshg]

Excellent sir Thank you..

[@Innozant]

Thanks dear❤️🙏

[@sudhakarverma4705]

Kya baat h sir meri problem solve kar di apne last me

[@Innozant]

Thanks dear❤️

[@tahirwaseem8684]

you know you have a amazing talent

[@ITTrainerSofcon-Sec6]

it's too good video sir please make a videos like that sir

[@Innozant]

Thanks dear..Sure will make more videos

[@jyotijha7910]

No words.. Extraordinary

[@mahabashyadhanvanthri3994]

Thank u sir I have lern lot of excel formula from u

[@Innozant]

Thanks dear..Happy Learning 👍🙏

[@mohanpal13555]

Very great trick

[@rashidabbasi679]

heartly thanks

[@gouravnand612]

Bahut sundar sir

[@SachinKumar-lg7nl]

The video are superb sir

[@aishwaryaambasta7013]

Sir day by day u just increase your video clarity and this video is really helping me out enhance my skills too..

[@uniquemobiletipstricks7714]

Good👍

[@muhammadbilal1947]

lajwab sir from gujranwala pakistan

[@Innozant]

Thanks dear Bilal

[@aniloutlook]

Boss you really champ....

[@Innozant]

Really means a lot to me dear

[@HeartymindAlways]

Amazing video

[@shahzadsami5613]

Very good

[@jaynarayan1963]

Great Sir❤❤

[@Innozant]

Thanks Jay

[@hravichandran]

hi, I am frm Tamilnadu. Your videos are very useful . Have been learning both excel formulas, tricks, difficult tasks and Hindi Language. Your way of explaining step by step is exemplary. Thank-a- lot. Ravichandran. H

[@Innozant]

Thanks Ravichandran for your trust ,love and support.Have a wonderful career ahead.

[@priyankamondal6320]

Excellent

[@Innozant]

Good Morning Priyanka..Have a wonderful career ahead ❤️

[@thangaveluraj5366]

Excellent 👌

[@Innozant]

Thanks ❤️👍

[@adityaacharya984]

Please give a lecture on adding watermark and page layout

[@Innozant]

Ok .Aditya..👍🙏❤️

[@naeemulhassan1426]

Sir Good after noon. I m your subscriber and I want to know a complete tutorial on time calculation in ms excel. Plz share and upload a tutorial video. I will be thankful and greatful to u. Regards.

[@ShoebShaikh-jk7jk]

Amazing sir..

[@Innozant]

Thanks dear

[@arajitsardar5077]

দারুন দারুন দারুন

[@madhurirajmane8631]

Nice teaching sir

[@Innozant]

Thanks Madhuri..Recommend you to start your learning journey from Playlist Basic Excel onwards..step by step

[@gangireddyannareddy7000]

Your lecture is good, but plz also provide sheets as well.

[@Innozant]

Sheet are already there. Kindly see the link in video description

[@battlefansshorts8941]

Thanks sir❤🌹😊

[@Innozant]

Thanks ❤️🙏

[@mahabashyadhanvanthri3994]

Superb

[@Innozant]

Thy👍❤️❤️🙏

[@animals-video261]

Awesome video, my question is related to this duplicate which I had mailed you plz help me

[@Innozant]

Bht saare mail aate hain dear..miss ho gya hoga..Ok will check it again

[@animals-video261]

@@Innozant I understand sir...plz chk..not an issue

[@kabulkhatana5518]

Thinks sir

[@arunkumar-ws1pk]

Dear sir, May i know, demand forecast training videos, please suggest if possible.i want to take demand forecast training

[@pbbappy19]

Pl make regarding mailmerging.

[@Innozant]

Mail merge video available under ms word playlist

[@pbbappy19]

@@Innozant pl send link. Pl guide make wages slip of 1000 people by help Mail merging.

[@pradeepprajapati3057]

Amazing

[@Innozant]

Thanks Pradeep ji

[@ishutiwari5567]

10:21 sir i think apka ye conditional formatting ka formula always shi nhi hoga kyoki agr 1 se jyada duplicate hue to countif formula use highlight nhi krega you should use= countif(range,criteria)>=1 isse agr 1 se jyada bhi repetition h tb bhi highlight hoga

[@Innozant]

Ishu phir SE ek Baar dekhiye aap wo Question kya pucha gya tha..occurance 1 time ho to hi color krna hai na ..ek se jyada Hoga to wo to duplicate hi hai use kyu krna format..🙂M Happy ki aap analise karte Hain Questions ko aur different krne ki koshish krte hain..Good 👍❤️.

[@ishutiwari5567]

@@Innozant sir your question and solution was right according to your situation but agr range me vhi number 1 se jyada bar repeat hua ( like 3 times repeat,4 times repeat) then countif formula to sirf 1 time repeat ane pe hi cells ko colour krega na according to your condition. agr 2 ,3 4 ,i mean 1 se jyada bar repeat hora h number to mera wala formula shi hoga.kyoki apki condition ke according 1 se jyada bar repeat hone me countif formula 2,3,4 and so on answers dega aur apne apne =1 lgaya h condition me to colour hoga nhi us situation me. ab kya pta ki koi number range me kitni bar repeat hora h.mera solution meri condition ke according tha. ye mere kehne ka mtlb tha.🙏😊

[@Innozant]

Yes Ishu you are right in case of multiple duplicate value aur uspe formatting apply karna hai to,Jab bhi main interview cracker series me Questions Ka solution attempt krta hu aap koshish Kiya kro ki usse alag solution try Kiya kro aur mujhe btao ki iska solution Aise bhi ho skta hai jisse main ye Jan sakun ki aap logic Apne tareeke se laga pa re ho aur concept clear h apke jaisa ki aapne is Question me socha .👍❤️ Good morning.hv a nice day ahead. Happy Learning 🙏

[@gamerup2241]

Nice sir

[@gauravbhatia7987]

Thnq sir

[@ShwetaSingh-qg6dk]

Can i get ur website sir and how get yr online classes. So, i can have duscussion for projects.

[@Innozant]

Search Innozant on Google ,You may find Innozant website for more information

[@AmanSharma-yu4hc]

Find duplicate wale formulae me aapne formula ko freez kaise kiya sir ?

[@swarnas5617]

Super bro

[@Innozant]

Thanks Swarna..God bless You..Happy learning ❤️👍

[@Altaf_Alam]

Sir jo bhi word likhe uska first letter automatic uppercase mein ho jaye....iska setting kaha milega sir plz reply 🙏

[@Innozant]

File-options me sayd advanced ke andar hoga .

[@arunkumar-ws1pk]

This video is unrated, it should be on toppppppp

[@Innozant]

♥️♥️♥️

[@ravijain6713]

Sir how to add number with text......like...12pcs,10pcs,13psc,24pcs

[@Innozant]

Will make video for the same

[@ShwetaSingh-qg6dk]

As u replied inzannt team. Wesite sir???

[@Innozant]

Hi Shweta ,Unable to provide link in KZbin comments due to KZbin policy ,You may find our contact details in our any any latest video intro or KZbin channel introduction.

[@sunilkumar3209]

sir can you please provide excel sheet link again because when i click on that link G drive show empty.

[@Innozant]

Dear direct mis master link is working fine..m working on video broken link.. Still issue shre your mail id or you may mail us for the same

[@mriazmrs5975]

hi ak sheet make kar ni ha . ms execl par kuch is taraha say ha mujsay nai ho rahi ha S No particular 200gm /400 gm quty rate amount problems ya ha k items zida han jab invoice make karna hota ha to items list 70 ha or gm mai bhot dar ho jati ha koi asan sa trik ho

[@Innozant]

Custom formatting se gm suffix kar skte hain

[@sachindhariwal5786]

Sir 4th question m agr mutiple invoice no same h to ye kaam nahi kr raha kaise kiya jaaye sir

[@Innozant]

Duplicate vlookup use kren ..kya output chahte h

[@sachindhariwal5786]

Sir if we have 2group of numbers and both have dulipicate values and we want to know where tha duplicate values and also we want to match and romeve duplicate no from both of number groups

[@birebhushan]

sir...आपको email करके, questions पुछ शकते है...??

[@Innozant]

@innozantofficial telegram id

[@chetan1008]

👍👍👍

[@arghyasaha2639]

IE $ SIGHN KAISE A RAHA HAI ??

[@rizvanrizzy9534]

Sir meny 1300 logo ki list bnaye par glati say name or father's name 1 sath likh leya ab wo alag colom m kesy jaye ..?😭

[@Innozant]

Split kar lein ya to power query se yabusing formula

[@rizvanrizzy9534]

@@Innozant pls video bnaa k dkhaye.

[@karimsamnani3660]

[@pa2happiness13]

💞

[@Innozant]

Thanks ❤️

[@tarjitmalka3978]

🌟🌟🌟🌟🌟

[@AmarjitSingh-wn7ct]

Excel ka ABCD sikha rahe ho bhaiya.

[@Innozant]

Ye safar Abcd se Z tak ka hai..keep learning

[@virendrahardiya2797]

Sir, ये विडियो delet कर दें तो अच्छा है। क्यूं की इसमें आप कुछ खास करते हुए नही लगे

[@zohaib0999]

Sir have u any WhatsApp group???

[@Innozant]

No dear...telegram id is there