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 #اكسل
-
7:01
Evenout
17 hours agoTIME TRAVELLER TWIN PRANK💀🤯
10.7K -
5:22
ThinkStory
1 day agoDARK MATTER Episode 8 Breakdown, Theories & Details You Missed!
8.5K3 -
22:03
TheTapeLibrary
23 hours ago $0.26 earnedUncovering the TRUTH of the Serbian Dancing Lady
8.97K1 -
24:26
Code Blue Cam
1 day agoPit Bull Attacks Officer During Terrifying Rampage
1.58K14 -
10:35
SonnyFaz
13 hours agoSonnyFaz Reacts To HeelMike And Zherka...
11.9K28 -
1:44
Hack
1 day agoHow to Unlock Your Car in 30 Seconds
33.8K21 -
8:06
ErmzPlays
22 hours agoThe Acolyte Episode 4 - From Stupid To Insane
18.4K21 -
10:12
China Uncensored
12 hours agoBoeing Has a BIG China Problem
23.3K26 -
1:02
Maicy Renee
15 hours agoGetting That Beach Body Ready Yall!
31.8K5 -
42:43
The Why Files
1 day agoProof of Life After Death: Hope and a Warning From The Other Side
31.5K67