Learn Discount Formula In Ms Excel ✍️✍️

Описание: 📊 Discount Formula in MS Excel | How to Calculate Discount in Excel | Excel Tutorial for Beginners

|Learn With Kamran|
Subscribe Now 📥

#learning
#excel
#computereducation

Welcome to our complete tutorial on Discount Formula in MS Excel 🎉
In this video, you will learn how to calculate discount in Microsoft Excel step by step using simple and easy formulas.

🔍 About This Video

Microsoft Excel is one of the most important tools used in offices, schools, shops, businesses, and accounting work.
One of the most common tasks in Excel is calculating discounts.

In this video, we explain:

What is discount

Discount formula in Excel

Discount percentage calculation

Discount amount calculation

Final price after discount

Real-life examples using Excel

---

🧮 What Is Discount?

A discount is a reduction in the original price of a product or service.
Discounts are commonly used in:

Shops

Online shopping

Sales offers

Business invoices

Billing systems

Accounting records


Example:
If the original price is 1000 and the discount is 10%, the discount amount is 100, and the final price becomes 900.

---

🖥️ Discount Formula in MS Excel (Concept)

Basic Discount Formula:

Discount Amount = Original Price × Discount Percentage / 100

Final Price Formula:

Final Price = Original Price − Discount Amount
---

📊 Example Used in This Video

Suppose:

Original Price is in cell A2

Discount Percentage is in cell B2


Discount Amount Formula:

=A2*B2/100

Final Price After Discount:

=A2-(A2*B2/100)


---

💼 Why Learn Discount Formula in Excel?

Learning discount formulas in Excel helps you:

Work faster in office jobs

Create professional invoices

Manage shop billing

Handle business sales data

Improve accounting skills

Increase job opportunities

Save time and effort


Excel skills are highly demanded in today’s job market.


---

🧑‍🎓 Who Can Learn From This Video?

This video is perfect for:

Excel beginners

Students

College learners

Office staff

Accountants

Shopkeepers

Business owners

Freelancers

Data entry operators

Anyone learning MS Excel


No advanced knowledge required.


---

🏫 Use of Discount Formula in Real Life

Discount formulas are used in:

Shopping bills

Sales invoices

Retail stores

Online shopping platforms

GST calculations

Accounting sheets

Business profit analysis

Monthly sales reports



---

📈 Benefits of Using Excel for Discount Calculation

✔ Automatic calculations
✔ Saves time
✔ Reduces human error
✔ Easy to edit and update
✔ Professional data handling
✔ Suitable for large data

Once you enter the formula, Excel calculates everything automatically.


---

🎯 Excel Skills for Career Growth

Microsoft Excel is used worldwide in:

Offices

Banks

Companies

Schoolse

Government jobs

Private sector


Learning Excel formulas like discount calculation is a big step toward becoming Excel-smart.


---

🧠 Beginner Friendly Explanation

This video explains:

Each step slowly

Easy language

Practical examples

Clear screen recording

Simple formulas


Even if you are learning Excel for the first time, you will understand easily.


---

📚 Topics Covered in This Video

Introduction to Discount

Discount Formula

Percentage Calculation

Excel Cell References

Discount Amount

Final Price Calculation

Practical Excel Sheet Example

Common Mistakes to Avoid



---

📝 How to Practice After Watching This Video

1️⃣ Open MS Excel
2️⃣ Enter product prices
3️⃣ Enter discount percentages
4️⃣ Apply the formula
5️⃣ Check the final price
6️⃣ Practice with different values

Practice makes you perfect in Excel.


---

❤️ Support Our Channel

If this video helped you: 👍 Like the video
💬 Comment your doubts
📤 Share with friends
🔔 Subscribe for more Excel tutorials

Your support motivates us to create more free learning content.


---

📌 Related Excel Videos

MS Excel Basic Formulas

Percentage Formula in Excel

Profit and Loss Formula in Excel

GST Calculation in Excel

Salary Sheet in Excel

Invoice Format in Excel

Attendance Sheet in Excel

Excel for Beginners



---

🌐 Learn Excel Step by Step

Our channel focuses on:

Basic to advanced Excel

Office work tutorials

Practical examples

Job-oriented skills

Easy learning methods


We believe anyone can learn Excel with proper guidance.


---

🧾 Importance of Discount Calculation in Business

Correct discount calculation helps businesses:

Attract customers

Increase sales

Avoid losses

Maintain accurate records

Build customer trust


Excel makes discount calculation fast and accurate.


---

📢 Note for Students & Office Users

This video is: ✔ Beginner friendly
✔ Practical based
✔ Office useful
✔ Time saving
✔ 100% free

You can use these formulas in real office work.


🙏 Thank You for Watching

Thank you for watching Discount Formula in MS Excel.
We hope this tutorial helps you improve your Excel skills and confidence.

👉 Subscribe now for more Excel & computer learning videos
👉 Press the bell icon to get all updates

Happy Learning 📊😊