How to use the AutoSum feature in Excel | #01 إتعلم حيل إكسل مع دكسلو 🇹🇳

2 years ago
3

How to use the AutoSum feature in Excel | Excel Practice Case #01

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

🙋🏼‍♂️ 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

Loading comments...