How to use the AutoSum feature in Excel | #01 إتعلم حيل إكسل مع دكسلو 🇹🇳
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
-
30:34
First Class Fatherhood
2 hours agoDaniel Stern Interview | Home Alone Actor Talks Fatherhood, Hollywood and His New Book
3.86K -
1:18:06
Steven Crowder
5 hours agoLETHAL FORCE: Why They Have to Kill Trump to Beat Him | GUEST: General Flynn
220K375 -
1:25:47
Benny Johnson
3 hours ago🚨 Joe Biden Authorized the Assassination of President Trump | Documents PROVE It! RNC on LOCKDOWN
46.8K90 -
1:51:20
The Shannon Joy Show
7 hours ago🔥WATCH The Skies! LIVE Exclusive W/ Dane Wigington On Global Plans To Spray The Sky & DIM The Sun🔥
22.7K17 -
57:59
Graham Allen
5 hours ago🚨DOCS REVEALED🚨 Biden Admin Wants Trump DEAD OR ALIVE?!
48.9K199 -
45:09
Rethinking the Dollar
4 hours agoExplosive Growth: Shanghai's Yuan Silver Futures Break Records at 8,733 Yuan/kg!
32.9K2 -
2:20:54
Matt Kohrs
13 hours agoMarkets Rip To New Heights, NVDA Earnings Preview & Live Trading || The MK Show
37.4K6 -
3:58:47
LumpyPotatoX2
6 hours agoHappy Lump Day! - #RumbleTakeover
39.5K5 -
1:43:38
Game On!
15 hours agoThe Celtics Will Never Win an NBA Title| Sports Morning Espresso Shot
40.1K5 -
1:57:04
Kim Iversen
18 hours agoWEF’s Klaus Schwab Is Retiring. Who's Next? GOP Bill Gives VA Benefits To IDF Soldiers | Anti-Genocide 2024 Candidate Jill Stein
102K321