Premium Only Content
How to use the sum function in Excel and currency Formatting | #05 إتعلم حيل إكسل مع دكسلو 🇹🇳
How to use the sum function in Excel and Currency Formatting | Excel Practice Case #05
In this Excel trick we learn how to enter data in multiple cells, apply currency formatting and add a sum function using shortcuts.
The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10. =SUM(A2:A10, C2:C10) Adds the values in cells A2:10, as well as cells C2:C10.
🙋🏼♂️ PLEASE SUBSCRIBE
======================
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉 https://bit.ly/3p6wgUl
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:
======================
- Highlight data range and use CTRL + Enter shortcut
- Apply currency formatting
- Use the ALT + = shortcut for auto sum
- use CTRL + SHIFT + $ to apply currency formatting
======================
✏️ Course developed by Dexcelo.
======================
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
======================
0:00:00 - 0:00:27 Intro
0:00:27 - 0:01:25 Highlight data range and use CTRL + Enter shortcut
0:01:25 - 0:02:13 Use the ALT + = shortcut for auto sum
0:02:13 - 0:02:46 use CTRL + SHIFT + $ to apply currency formatting
0:02:46 - 0:04:14 Trick Objectives Summary
🔗 Useful Links
======================
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
======================
Thank you for your support 🙏🙏🙏 !!!
======================
Tags
#sum #sunfunction #excel #اكسل
-
3:42:32
Alex Zedra
15 hours agoLIVE! Chill stream before Thanksgiving!
195K29 -
5:00:01
Pepkilla
18 hours agoDouble XP Zombies and Warzone ~
80.2K10 -
0:46
Dr Disrespect
2 days agoIt's not just a stream... it's an experience
610K2.96K -
1:28:27
Kim Iversen
1 day agoBOMBSHELL: Secret British Military Plot to Prolong the Ukraine War And Take Down The Grayzone
172K291 -
11:54
Professor Nez
16 hours ago🚨CHILLING REVELATION: Tucker Carlson Reveals Dems NEXT PLAN to STOP Trump!
179K97 -
6:51
Colion Noir
16 hours agoI have Something To Say To Gun Owners
115K30 -
1:18:24
Glenn Greenwald
20 hours agoLiberals Encourage Family & Friends To Separate Over Political Disputes; Segment Debut Of System Pupdate: Profiles Of Rescued Dogs | SYSTEM UPDATE #373
168K510 -
1:24:53
Flyover Conservatives
1 day agoMarketing Madness or Manipulation? The War on Western Identity - Alex Newman; Economic Update - Dr. Kirk Elliott | FOC Show
84.7K8 -
1:15:05
PMG
1 day ago $15.38 earned"Big Pharma EXPOSED: The HIDDEN Cures They Tried to Bury"
69.1K20 -
3:26:12
Tundra Gaming Live
17 hours ago $4.19 earnedThe Worlds Okayest War Thunder Stream
55K1