How to use SUM function 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 #excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial ... https://www.youtube.com/watch?v=EzDX5rTlgFE