Premium Only Content
How to use the sumif function in Excel | #02 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use the sumif function in Excel | Excel Practice Case #02
In this video we illustrate the use of the VLOOKUP function, name a range of data and we use the data validation tool to limit entries in one cell.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3SnY8ke
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:33 Intro
0:01:33 - 0:02:38 Naming a range of data
0:02:38 - 0:06:11 Data Validation
0:06:11 - 0:11:36 VLOOKUP Function
0:11:36 - 0:13:00 Testing the data validation and the VLOOKUP
0:13:00 - 0:18:16 Trick Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
-
4:20:46
Right Side Broadcasting Network
9 hours agoLIVE: President Trump Meets With Japanese Prime Minister Ishiba - 2/7/25
193K34 -
2:01:23
The Dilley Show
6 hours ago $15.32 earnedVought Confirmed, Elon Loves Trump and Q&A Friday! w/Author Brenden Dilley 02/07/2025
73.4K15 -
1:57:39
The Charlie Kirk Show
6 hours agoThe Greatest Deportation Wave in History + AMA | Homan | 2.7.2025
139K82 -
2:02:15
LFA TV
21 hours agoMAINSTREAM MAGA! | LIVE FROM AMERICA 2.7.25 11am
115K83 -
1:17:37
Game On!
7 hours ago $2.72 earned5 SHOCKING Super Bowl Stats and Trends!
66K4 -
2:01:29
The Nunn Report - w/ Dan Nunn
3 days ago[Ep 601] USAID / CIA | Panama | Guest Sam Anthony of [your]NEWS
47.4K11 -
58:57
The Dan Bongino Show
9 hours agoDOGE Uncovers More Corruption Than We Ever Thought Possible (Ep. 2418) - 02/07/2025
975K2.32K -
47:52
The Rubin Report
7 hours agoCalifornia Businessman Makes Joe Rogan Go Quiet with Never-Before-Told Details of LA Fires
115K41 -
2:05:11
Benny Johnson
7 hours ago🚨INSURRECTION: Violent Democrats Storm DC Federal Buildings! Vow to Impeach Trump | 100K Feds Resign
171K521 -
1:06:22
The Big Mig™
22 hours agoGlobal Finance Forum From Bullion to Borders
21K8