MS Excel Salary & Interest Calculation | Practical Office Work | Bengali Tutorial
Автор: Rajarampur Youth Computer Training Centre
Загружено: 2025-12-09
Просмотров: 5
Описание:
Computer Training Centre Name: Rajarampur Youth Computer Training Centre (RYCTC)
📞 Contact: 9609212325
📧 Email: [email protected]
▶️ Channel: RajarampurYCTC
👨🏫 Instructor: Biplab Saha
📌 About this Video
In this Bengali MS Excel tutorial, you will learn 2 highly useful office topics:
🧮 1️⃣ Salary Calculation in Excel
✔ Basic Salary
✔ DA, HRA Calculation
✔ PF Deduction
✔ Gross & Net Salary Formula
📌 Example Formulas
DA = B2 * 40%
HRA = B2 * 20%
Gross Salary = B2 + C2 + D2
PF = E2 * 12%
Net Salary = E2 - F2
💰 2️⃣ Interest Calculation in Excel
✔ Simple Interest (SI)
✔ Compound Interest (CI)
✔ Principal, Rate & Time based calculation
📌 Example Formulas
Simple Interest (SI)
=Principal * Rate * Time / 100
or =A2 * B2 * C2 / 100
Compound Interest (CI)
=Principal*(1+Rate/100)^Time - Principal
🎯 Best for:
• Office Job Seekers
• Data Entry Operators
• Computer Training Centre Students
• School/College Students
🔔 Subscribe for more Bengali Computer Tutorials:
MS Word | MS Excel | PowerPoint | Practical Computer Works
👇 Comment for:
✔ Practice Sheet (Excel File)
✔ PDF Notes
✔ Salary + Interest Calculation Project File
#Excel #SalaryCalculation #InterestCalculation #ExcelBengali #ExcelTutorial #RYCTC #BiplabSaha #PracticalExcel #OfficeWorkExcel #MSExcel2007
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: