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

In this video you will learn how to use MIXED CELL REFERENCE.It is useful when you want to partially change the reference of cell the time of copying the data.Using this reference you are able to fix any row or column number and it will never change while copying the formula...
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

[@aatifrashid5413]

Awesome Lecture!

[@yurialexkov2797]

Very helpful video.

[@rohitpatil2307]

very helpful video sir🙏

[@princemjprasanth8954]

Thanks for the helpful video 🙏🙏🙏Sir

[@sushilchoudhary1328]

Great Example for Mixed Reference .....

[@Innozant]

Thanks Sushil Ji.Happy learning dear

[@H.RAJ123]

Thanks sir amazing😊

[@awanishanurag1763]

Operators par bhi full dedicated content layiye sir! i.e. Arithmetical operator , Range operators, Text operators and Comparison operators etc.

[@arshadpathan2758]

Thank you

[@kashifadeel8162]

سر اپ بہت اچھا کام کر رہے ہے۔

[@Innozant]

😊

[@SachinKumar-qe2cq]

Thanks a lot sir

[@Innozant]

Thanks dear.

[@aaqibchaudhary786]

aapki video dkhkar kahan se kahan pahuch gaya me comnpnay me...Thanks sir

[@Innozant]

Grear Keep learning

[@sadashivkage3133]

Tq...sir

[@shahzadsiddiqui5117]

this was the biggest mistake for me always...! thanks

[@gauravbhatia7987]

Good

[@shivamonestop380]

Wow

[@shashanksingh5170]

Hi sir,F4 is not working for freeze cell or column in my laptop, don't know why..

[@Innozant]

Use it witb Function key dear in laptop.☺️

[@prosanjitbhura1901]

Sir how you show formula shown in particular cell?...have you make any video in this..

[@Innozant]

Using F9..select the data range first then F9

[@prosanjitbhura1901]

@@Innozant unable to do..sir😢

[@artiverma5122]

🙏👌

[@Innozant]

Ye mujhe bht acha laga ki aapne bilkul start se seekhna shuru kiya hai..achese seekhiye koi bhi kabhi issue aaye to apke paas number hai kbhi bhi msg or call kar sakte hain aap dear

[@artiverma5122]

Really thanks, guru g, bs job lg jayegi, to apko call pr btaugi

[@Innozant]

Sure dear...kyu nhi lgegi job..bht jald lgegi

[@dicaprioleo8261]

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

[@prateekgupta7053]

Crtl+D for copy down and crtl+R for copy right

[@RA-rh5lb]

Sir Ji I am unable to understand the concept here.. You tried your best to explain but I dont understand it. Is there any substitute for the mixed reference😔

[@Innozant]

Again repeat the video..you may able to under .m sure

[@pawanwakale8801]

$A$1 JAB NICHE SCROLL KARTE TOH SAB 1 HI ATA AISE YUN HOTA

[@Innozant]

Aana hi chaiye.That means abosolue reference apply hua na ydi dono taraf dollar use krenge to

[@H.RAJ123]

Thanks sir amazing😊

[@BrajeshKumar-op2po]

Good