What is R1C1 Reference Style in Excel Bangla || A1 vs R1C1 Style
Вставка
- Опубліковано 19 вер 2024
- In this lecture i will show you what is r1c1 reference style and a1 style,
There are two kinds of cell reference styles, first is A1 and R1C1.
Most of the Excel users don’t know about r1c1 referencing.
The R1C1 style is a kind of old one.It was first introduced in Multiplan which was developed by Microsoft for Apple Macintosh.
But after few years, Microsoft started to use A1 style so that people who migrated from Lotus would find it familiar, but R1C1 has been always there in Excel.
Every Excel spreadsheet contains rows and columns. Most of the time, columns are identified by letters (A, B, C), and rows are identified by numbers (1, 2, 3). In Excel, this is known as the A1 reference style. However, some prefer to use a different method where columns are also identified by numbers. This is known as the R1C1 reference style.
There are few additional benefits in R1C1 than A1.So in this excel bangla lecture, I’d like to share with you all the aspects of using R1C1 reference style.
I think you have enjoyed this video.
If this tutorial really helps you, please #like, #comment, #subscribe and #share with your close friends.
............................................................................
..............Subscribe to Get More Videos...........
www.youtube.co...
............................................................................
..................................................................................................
Most Favorite Videos
MS Excel Bangla Tutorial Playlist :
Microsoft Excel Super Tips & Tricks: Must Know: goo.gl/5qSphJ
IF Function in MS Excel Bangla: goo.gl/jY76m4
Microsoft Excel Essential Course for Beginners: goo.gl/7EX1hk
Microsoft Excel Intermediate Course: goo.gl/iatnNz
Microsoft Excel Advanced Course: goo.gl/WFrvzU
Microsoft Excel Formulas & Functions: goo.gl/7Da7oZ
Microsoft Excel Pivot Table Magic: goo.gl/NGp13W
Microsoft Word Essential Course: goo.gl/SVXefG
..................................................................................................
.................Social Media.................
Twitter : / cumamun
Google+ : plus.google.co...
LinkenIn : / abdulla-al-mamun-172629b4
Instagram: / al-mamun36
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► bit.ly/OffTMDes...
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks. .
.................................................................................................
.................Social Media.................
Facebook Page : / mamunacademy4u
Facebook Group : / mamunacademy
Google+ : plus.google.co...
LinkedIn : / abdulla-al-mamun-172629b4
..............................................
........................................................
Music Credit goes to: "Royalty Free Music from Bensound" & www.bensound.com
Intro/Outro/Banner Creator:
Official™ ► bit.ly/OffTMDes...
Glitchy FREE 2D Intro Template | After Effects Free Intro Template
.........................................................
Stay Tuned with Mamun Academy to get more Videos with Tips and Tricks.
ভাই আপনার ভিডিও এবং বোঝানোর ধরন খুবই সুন্দর। আমি অনেক দিন থেকেই দেখছি। আমিও আপনার কাছ থেকে শেখার চেষ্টা করি।
nice bhai, thanks
প্রাকটিস ফাইলটা দেন ভাইয়া!!!! খুব ভাল লাগছে!!!!!!
wonderful
nice
Very good Brother, Thank you
খুব ভাল। ধন্যবাদ!
এক সময় মনেহতো যে xl মোটামুটি কিছু যানি।এখন দেখি এটা একটা সমুদ্র। mamun academy নৌকা স্বরূপ, পার করতে পারে আমাকে ও সকল বন্ধুকে।
😆😃😆
আপনাদের ভালোবাসা পেলে
আপনাদের সাথে নিয়ে আগাবে Mamun Academy
Just share with your friends...
wow
mamun vai
tnks vai.......video ta onk helpful
তাই নাকী?
খুব ভাল। ধন্যবাদ
wc
Data consolidated niya vedio plz sir.
R ha apner sarir valo to .
Ok vai
Na akhon o sustho hoini..
Thursday te doctor asbe Dhaka theke then
very nice cell reference er by pass way taw jana gelo
yes
it will increase excel knowledge & techniques
very
vERY GOOOOOOOD
onek din por deklam
yes, boos,
valo achento?
bank e dps (taka jomano) er upor akta video banaben vaiya............ kmn tara hisab kore save rakhe ?
ok
Please One Project Development Tutorials in Excel ( Create Database Development in Excel)
বড় ভাই এমন কেন মনে হল আপনার। তাহলে আমি কি শিখব না।
Thanks
wc
Bhai Excel 2007 er video hobe
ami apnake suggest korbo 2016 use korar
tokhon mone hobe atodin ki vul korci....onek.moja paben
Thank you dear mamun Bhai
ভাই একটা সমস্যা!!!! 123 120 520 456 35 320 62 852 753 152 200 100 521 দুইশত এর উপরে থেকে যোগ করবো, দুইশত এর নিচের গুলো যোগ হবেনা !!!
use if function
wonderful
very
প্রাকটিস ফাইলটা দেন ভাইয়া!!!! খুব ভাল লাগছে!!!!!!