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 👉 [email protected]

📊 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