How to use the sum function in Excel and currency Formatting | #05 إتعلم حيل إكسل مع دكسلو 🇹🇳

2 years ago
1

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 #اكسل

Loading comments...