Excel Cell Reference:-Mixed Reference Part-1 | Ms - Excel Cell Reference

Another Example of Mixed Reference,Learn it and Rehearse it.
Basic Excel Playlist Link - • Basic Excel-The Learni...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
===========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
#excelformulareference #cellreference #mixedreference #innozant

[@amansaxena102]

stop like the entertainment and start like the knowledge . you are absolute sir, I personally want your vdo's to be in infinity likes. appreciate your way and hard work truly helped.

[@Innozant]

Thanks Aman for your valuable appreciation.God bless you dear, ❤️

[@indianlifeinsaudiarabia]

Wow sir.... Concept bataya...then trick bhi bataya hai.... Nicely explained

[@Innozant]

Thanks dear...keep learning

[@salmanishaq8705]

Ek dm clear sath hi aage seekhne ka bhi mnn hai... Thank you sir ☺️

[@Innozant]

Go ahead..Happy Learning ♥️👍

[@srinivasbattula1863]

I got interest to learn, because of your explanation sir......tq

[@Innozant]

Thanks dear..Keep learning ❤️

[@AkashKumar-tu4fm]

Thank you very much Sir ❤really appreciate your efforts to make us understand it

[@ManishKumar-se8fi]

Bahut bahut dhyanyawad sir aap mahan ho

[@Innozant]

Thanks Manish Ji God bless you

[@kiranbabar86]

Thank you so much sir bahut dino se function clear nahi ho raha tha , aaj aap ka ye lesson dekha to sab doubt clear ho gayee aap bahut achhe se explain karate hai ..🙏

[@Innozant]

Thanks Kiran .Happy learning

[@prosanjitbhura1901]

Yest its complicated...but you make it easy. Sir...

[@Innozant]

Thanks dear

[@shahzadsiddiqui5117]

very important video for me, it was always a confusion for me..!

[@suparnaray7513]

THANK YOU SO MUCH.EXCELLENT VIDEO.EASY TO UNDERSTAND.

[@Innozant]

Thanks Suparna..We Welcome you to experience the taste of success with Innozant-Seed of success.
Recommend you to start your MIS learning from Playlist -Basic Excel ,after completing Basic excel proceed with Sorting,AdvFilter,What if Analysis,Excel Array, Vlookup series etc step by step.❤️🙏

[@RA-rh5lb]

In the basic series, this is my favorite and try to practice more.. I truly owe you for amazing teaching.

[@Innozant]

Thanks dear..Keep Learning ❤️

[@princemjprasanth8954]

Thanks for the helpful video 🙏🙏🙏Sir

[@ganeshgaikwad7076]

Thanks Sir it's very useful for me

[@yuvrajsinghchauhan6759]

Thank you sir it is helping a lot.

[@BSJ1947]

All concept cleared thank you sir.

[@aatifrashid5413]

Awesome Lecture!

[@learn1min311]

Great Teachings, Thnx a lot.

[@Innozant]

Thanks

[@farooqA143]

All concept cleared thank you so much sir.😍😍

[@haaarrdik]

Thankfully ek hi attempt mei samajh aagya sir. Mene video pause Kari, Khud se challenge liya... Table Ke single Rows and columns ko drag krke Fun kiya, Pehle Galat hua but then jab aapne Last mei Pura table bana diya... I was like, Ye toh kamaal hi hogya. Problem solved⚡
You are A great Teacher Sir!

[@Innozant]

Thanks Hardik for your valuable appreciation.Keep Learning 👍♥️

[@user-hq5gr9hk1j]

This is the best explanation 👏

[@Innozant]

Thanks dear 👍❤️

[@AnkitSingh-mh7ee]

Outstanding explanation sir . You are one of the best teacher for Excel.

[@Innozant]

Thanks Ankit..Keep Learning

[@BrajeshKumar-op2po]

Smart formula super sir.

[@aarishali1418]

Bhai ek number samjhaya apne mja aagya

[@Innozant]

Thanks Niyaz ❤️

[@Suryakant89]

Great Teaching 👍

[@Innozant]

Thanks Suryakant ji

[@sarojkumarsahu2858]

Sir,your explanation is excellent,even a lay man like me can understand, thanks u

[@Innozant]

Thanks dear..kedp learning ❤️

[@shivamonestop380]

Fantastic

[@learn1min311]

this channel deserves to have high number of views, thnx for your efforts.

[@Innozant]

Thanks dear

[@dubey308]

Realy Nice Sir!

[@swetadas7026]

Thank u so much sir

[@yurialexkov2797]

This video deserves 1 million views minimum
👍👍👍👍👍

[@Innozant]

Thanks .God Bless You..Happy learning dear❤️

[@sadashivkage3133]

TQ...SIR...🙏🙏

[@sahareshekhar3432]

Good series sir

[@pavansanadi5832]

very usefull reference class.....

[@Innozant]

Thanks Pavan.Keep watching,Keep supporting🙏♥️

[@Sidha_Devbhoomi_se]

Your new student sir 🙇

[@Innozant]

Welcome to innozant family

[@lokenderuniyal1390]

Great sir

[@satishmestry5687]

Wahh sir, kya sikhate ho aap.
thank you sir. keep it up.

[@Innozant]

Thanks Satish Ji..Step by step in sequence seekhiye..🙏❤️

[@kumarsudeep837]

Ekdam mst

[@sushilchoudhary1328]

In References explanation that you gave was great no doubt at all. We could have also used Show Formula to understand the row and column reference changes.. That is my point of view. As I am learning step be step by your all videos, I thought as a student I should share the thought that came to my mind... I am trying to cover 10 Videos a day.

[@Innozant]

Offcourse you may refer show formula for the same.. OH 10 VIDEOS in a day..Wow..But kindly note that you need more practice as well

[@vasimuddinsheikh7478]

You are excellent

[@Innozant]

Thanks dear❤❤

[@shishirbatham]

Wonderfull

[@Meenamannu448]

Super sir thanks

[@Innozant]

Thanks Meena..Happy learning dear ❤❤🙏🙏🙏

[@ankitachoudhary2802]

Nice method

[@Innozant]

Thanks Ankita..Keep learning ❤️

[@The_Beast_Copied]

Love you bos😍

[@Innozant]

Thanks dear

[@abhishekshirsekar2065]

Perfect understanding

[@abhishekshirsekar2065]

Pls share ur numer sir I want join ur cources

[@Innozant]

WhatsApp/Call-7065069985

[@sawaimalhi8439]

@@Innozant sir code starting m kiya aiga

[@sawaimalhi8439]

@@Innozant WhatsApp/Call-7065069985 ye aaap ka number whtsp pa show nhe ho rha hai sir

[@RA-rh5lb]

Sir ji thank you so much. I don't think anybody could have explained such a simple way. I haven't come across the such video. Truly your channel deserves the best. Thank you so much. I am truly obliged ..
Sir do you teach online paid classes too.

[@Innozant]

Thanks dear..Keep Exploring.
Yes we are running hybrid (online,offline) classes.You may visit Innozant website

[@RA-rh5lb]

@@Innozant sure Sir

[@gauravbhatia7987]

Good

[@susantadas2209]

👌👌

[@royroyals007]

Sir, plz share months ways vlookup formula

[@piyushbhaivekariya370]

Very nice sir please more vidio power bi

[@Innozant]

Yes will upload more videos soon

[@yogeshkushwaha5309]

Mast ❤️❤️❤️💯

[@Innozant]

🙏❤️ Thanks

[@artiverma5122]

🙏👌

[@Innozant]

Thanks Arti

[@dicaprioleo8261]

Sir ye aap formula kaise drag krte ho blank drag krk ek dam se formula kaise paste ho jata hai please btayen

[@anil23]

Sir VBA ka bhi Play list upload kro sir

[@Innozant]

Sure..but Kuch time baad...🙏♥️

[@jaynarayan1963]

sir Please advise advance playlist how can i learn

[@Innozant]

Kindly watch upcoming notification playlist (Mis Learning process video)

[@vinayakpotadar4093]

Sir super speach. Sir.
One que sir.that is In master long sheet me filter kar ke unique other name sheet me data lena hi sir. Or filter karana dynamic atomatic how to lana hi sir. bar bar filter karke print dena hi muskil hi sir . One time how to set master sheet me copy & paste karane baad more than shhet me dusiti sheet me update hona hi sir. Please solve sir problem I hope 🙏 please reply me sir

[@Innozant]

Filter function se to bht asani se ho ja to jayega.kaunsa version aap use kr re h

[@vinayakpotadar4093]

Sir thankful I am so happy for your reply . Me keb office me kaam karate hai sir. I 2010 ms office Excel use hi hai sir.

[@vedikapatel1517]

Hello , I have been go through your vidioes. now i want to do practice but their is no excess in assignment so please give access so i can do practice.

[@Innozant]

Hi Vedika..Kindly download Assignment Master folder from 2nd link(available in all video description)
Direct link is broken now we are working on that.
Happy Learning dear ❤️👍

[@atulgoodify]

Sir column तो vertical होता है और row horizontal इसमें बड़ा कन्फ्यूजन होता है

[@Innozant]

Column left to right counting and row top to bottom.
Phirse video recap lijiye

[@PANKAJRAJ-ox5le]

how can i ask questions to you

[@Innozant]

via telegram @innozantofficial or [e-mail]

[@sanjayTECH04]

ONLINE CLASS LETE HAI..
WOULD LIKE TO JOIN FOR pOWER bI

[@Innozant]

Yes Dear..You may enquire for course (For contact detail kindly visit our website)

[@devendergusain8974]

सर अगर मैं प्रैक्टिस कर रहा हूँ आपके असाइनमेंट से अगर मुझसे प्रैक्टिस करते टाइम कोई दिक्कत हुई तो क्या करूँगा कुछ बताओ सर.

[@Innozant]

telegram @innozantofficial or mail

[@sawaimalhi8439]

thora thora ab samaj aya hai sir aaap ka naam nhe bataya ??

[@Innozant]

Practice krenge to aayega samjh

[@rahularya3509]

Hi Sir,
How can we convert $1000 text to number or value?

[@Innozant]

Kaise kiya haim.show ne your formula

[@rahularya3509]

@@Innozant Basic assignment HW(15).
Units
$15.00
$25.00
$62.00
$52.00
$25.00
$62.00
$32.00
(Data->Text to columns->delimited->next->tab->next->general->finish)

[@Innozant]

👍

[@rahularya3509]

@@Innozant sir, please advise...how will we change text to number/value?

[@Innozant]

Alt +d+e+f

[@AbhishekSingh-jy7tu]

sir fridge nahii ho raha 🤣 Jk.....

[@Innozant]

Function key ke saath F4 press kriye

[@AbhishekSingh-jy7tu]

@@Innozant ho raha tha sir bas thode maze le raha tha btw your videos are too good. ❤️
Ek playlist chahiye jisme sirf office work sikhne ko mile 2-3 din me interview hai kin kin cheezo pe kaam karke jana chahiye interview ke liye kuch topics aap bata dete toh HELP ho jati.

[@Innozant]

@@AbhishekSingh-jy7tu sure

[@karankapoor200]

sir whatsapp send

[@shampamallick430]

thora sa plm ho raha hye sir..

[@Innozant]

Kya issue

[@shampamallick430]

F4don't work. On the laptop