Premium Only Content

How to use formula reference in excel | #03 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use formula reference in excel | Excel Practice Case #03
What does it mean to use an absolute cell reference in a formula?
In contrast, the definition of absolute cell reference is one that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook. It's indicated by a dollar sign in the column or row coordinate.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉
SUPPORT THE CHANNEL
======================
👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n
Social Media / Contact Me
======================
🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU
📥 Business Inquiries 👉 dexcelo03@gmail.com
📊 In this course you will learn how to:
======================
- name a range of cells
- name a table
- use a named cell and a named range in a formula
- use VLOOKUP formula
- testing the efficacy of the VLOOKUP formula by changing the referenced cells
- import and export data,
- Learn multiple shortcuts
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:01:08 Intro
0:01:33 - 0:07:18 Create formula based on cell reference input
0:07:18 - 0:12:18 Absolute and relative cell reference
0:12:18 - 0:13:38 SUM Function with ALT + =
0:13:38 - 0:15:32 Testing different hypothesis
0:15:32 - 0:17:07 Trick Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#howtouseformulareference #formula #formulareference #excel #اكسل
-
LIVE
SpartakusLIVE
1 hour ago$1,000 Spartakus Gauntlet on VERDANSK for the FIRST TIME || TrulyEvil, Enzo Alder, Firefighter MDO
201 watching -
55:21
Donald Trump Jr.
2 hours ago"Publicly" Funded Propaganda Dealt Reality Check, Live! | TRIGGERED Ep.259
112K100 -
LIVE
Mally_Mouse
6 hours agoLet's Play!! -- Jak 2 pt. 14!
65 watching -
1:05:50
BonginoReport
3 hours agoWhite House Confirms President Trump’s Chronic Medical Diagnosis - Hayley Caronia (Ep.92)
31.4K38 -
LIVE
GritsGG
12 hours agoWSOW Group Stage Final Day! Most Wins 3080+! 🔥
61 watching -
1:22:29
Dr. Drew
1 day agoJenny McCarthy: After Son's Near-Death Reaction & Autism Diagnosis, Star Fights For Safer Childhood Vaccines w/ Alison Morrow – Ask Dr. Drew
52.6K12 -
LIVE
bigbossrobinson
5 hours agoLIVE - STRAIGHT INTO HELL - HELLDIVERS 2
54 watching -
9:30
MattMorseTV
4 hours ago $2.47 earnedWe just got the CONFIRMATION.
11.7K24 -
20:04
World2Briggs
4 hours ago $0.58 earnedTop 10 States That Are Getting Worse Every Year
8.83K1 -
LIVE
Quite Frankly
6 hours ago"Jumbotron Affair, Customer Service & 24hr America, Haunted Objects" 7/17/25
705 watching