P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida
#iptmnoida #payrolltraining #PayrollPlayer
P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida
In this video, i have explain and give you free download excel vba function to calculate P.Tax Professional Tax in India for all states.
Formulas Name: = PTAX(STATE,SALARY)
Download Link: https://payrollpedia.org/ptax-professional-tax-calculation-formula-in-excel-add-ins-free-download/
P.Tax calculation for following states:
1. MAHARASHTRA
2. JHARKHAND
3. WEST BENGAL
4. TELANGANA
5. ANDHRA PRADESH
6. ASSAM
7. BIHAR
8. GUJARAT
9. KARNATAKA
10. MADHYA PRADESH
11. MANIPUR
12. ODISHA
13. TRIPURA
14. PUNJAB
15. TAMIL NADU
16. KERALA
⌚ Timestamps
00:02:00 Introduction
00:01:00 PTax Formula
00:03:00 Install Add-ins
🔔 Channel Subscribe जरूर करे : https://www.youtube.com/c/IptmOrgInakumar?sub_confirmation=1
_____________________________________________________
☑️Payroll Training Course by IPTM: https://www.iptm.org.in
☑️New Batch Enquiry: http://bit.ly/training-enquiry
Payroll Blog: https://www.payrollpedia.org/
Excel Blog: https://99excel.com/home/
Excel Tools: https://99excel.com
_____________________________________________________
EQUIPMENT’S & SERVICES I USE:
Laptop: https://amzn.to/3bE0JDD
Webcam: https://amzn.to/2LqRkVl
Microphone (Boya): https://amzn.to/2LtEMMW
4K Ultra HD Smart LED TV: https://amzn.to/3ssTNPD
Chromakey Green Scree: https://amzn.to/3sAMbL9
I RECOMMEND:
Start Own Busines Online: https://amzn.to/39AEOua
Get Amazon Prime: https://amzn.to/2LU0bPe
Best Hosting (hostgator): https://bit.ly/3oJDzPD
Find People and Services: https://fwd.cx/NVOg9i3VfkSS
CREATED BY:
Ajit Kumar Yadav (AKumar)
Follow Me on Instagram: https://www.instagram.com/akumar0808/
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Thanks for coming over here.
#iptmnoida #PayrollPlayer
Видео P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida канала The Institute of Payroll Training and Management, India
P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida
In this video, i have explain and give you free download excel vba function to calculate P.Tax Professional Tax in India for all states.
Formulas Name: = PTAX(STATE,SALARY)
Download Link: https://payrollpedia.org/ptax-professional-tax-calculation-formula-in-excel-add-ins-free-download/
P.Tax calculation for following states:
1. MAHARASHTRA
2. JHARKHAND
3. WEST BENGAL
4. TELANGANA
5. ANDHRA PRADESH
6. ASSAM
7. BIHAR
8. GUJARAT
9. KARNATAKA
10. MADHYA PRADESH
11. MANIPUR
12. ODISHA
13. TRIPURA
14. PUNJAB
15. TAMIL NADU
16. KERALA
⌚ Timestamps
00:02:00 Introduction
00:01:00 PTax Formula
00:03:00 Install Add-ins
🔔 Channel Subscribe जरूर करे : https://www.youtube.com/c/IptmOrgInakumar?sub_confirmation=1
_____________________________________________________
☑️Payroll Training Course by IPTM: https://www.iptm.org.in
☑️New Batch Enquiry: http://bit.ly/training-enquiry
Payroll Blog: https://www.payrollpedia.org/
Excel Blog: https://99excel.com/home/
Excel Tools: https://99excel.com
_____________________________________________________
EQUIPMENT’S & SERVICES I USE:
Laptop: https://amzn.to/3bE0JDD
Webcam: https://amzn.to/2LqRkVl
Microphone (Boya): https://amzn.to/2LtEMMW
4K Ultra HD Smart LED TV: https://amzn.to/3ssTNPD
Chromakey Green Scree: https://amzn.to/3sAMbL9
I RECOMMEND:
Start Own Busines Online: https://amzn.to/39AEOua
Get Amazon Prime: https://amzn.to/2LU0bPe
Best Hosting (hostgator): https://bit.ly/3oJDzPD
Find People and Services: https://fwd.cx/NVOg9i3VfkSS
CREATED BY:
Ajit Kumar Yadav (AKumar)
Follow Me on Instagram: https://www.instagram.com/akumar0808/
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
Thanks for coming over here.
#iptmnoida #PayrollPlayer
Видео P.TAX Professional Tax Calculation formula in Excel - PTAX(STATE,SALARY) - IPTM Noida канала The Institute of Payroll Training and Management, India
Показать
Комментарии отсутствуют
Информация о видео
8 августа 2021 г. 10:00:13
00:08:10
Другие видео канала
![How to Merge Form 16 Part A and Part B in 1 PDF through Excel Automated : PDF Merge - Combine](https://i.ytimg.com/vi/7WNwN0w9tpQ/default.jpg)
![Income Tax Slabs | Tax Rates | Calculation for FY 2020-21 | Old vs New | Payroll Training](https://i.ytimg.com/vi/nNDfxcbY1zU/default.jpg)
![payroll calculation, practices and payroll training | live employee data | free excel add-ins - IPTM](https://i.ytimg.com/vi/j6KEz4-pet4/default.jpg)
![How to make CTC, Payroll, Income Tax and Salary Pay Slip In Excel : 2019 - 2020](https://i.ytimg.com/vi/uMqJLWMC994/default.jpg)
![PF Contribution Reduced to 10% | कॉन्ट्रीब्यूशन में 2 फीसदी कमी | Payroll Training](https://i.ytimg.com/vi/3Ieaq8CD7DM/default.jpg)
![Salary Increment PDF Letters from mail merge - Increment PDF लेटर कैसे बनाते है - IPTM Noida](https://i.ytimg.com/vi/6f9htFs10_8/default.jpg)
![how to generate PF ECR text file automatic from excel - vba code for EPFO portal | IPTM](https://i.ytimg.com/vi/fjKfJpRbSd0/default.jpg)
![New Income Tax Slab | Budget 2020 | Payroll Changes | Indian Payroll Training](https://i.ytimg.com/vi/X4dJWq1yQMo/default.jpg)
![HRA - House Rent Allowance Rules in CTC Salary for metro and Non Metro city | Payroll Training](https://i.ytimg.com/vi/DKKUd94nIQo/default.jpg)
![How to Make Payroll Sheet | Salary Processing in Excel | Create Employee CTC Register & Payslip](https://i.ytimg.com/vi/zW9UcIhacks/default.jpg)
![Create Individual Increment PDF from Mail Merge | How to Mail Merge in MS Word in Hindi | Excel link](https://i.ytimg.com/vi/u9w3M3nwvIA/default.jpg)
![How to file salary TDS return Form 24Q | e- Filing TDS Quarterly return via RPU](https://i.ytimg.com/vi/DxZHhwcLOTI/default.jpg)
![Time Saving Excel Trick | Autocorrect in Excel and Outlook | Excel for Payroll | IPTM](https://i.ytimg.com/vi/wxQqV0-A0xI/default.jpg)
![How to Convert Excel to PDF VBA | Salary Slip in Excel and Convert in PDF](https://i.ytimg.com/vi/-nITLknZj9s/default.jpg)
![how to validate digital signature in pdf file, DSC validation process in TDS form 16 | IPTM](https://i.ytimg.com/vi/E2j8waIAP0I/default.jpg)
![How to make ctc breakup (Cost to Company) explain by Mr. AKumar](https://i.ytimg.com/vi/ttFpHr4Tn4k/default.jpg)
![how to file salary tds return form 24q for last quarter in excel | annual return for form 16 - IPTM](https://i.ytimg.com/vi/XSJLgx31krc/default.jpg)
![How to Search Jobs in Google using CSE from Naukri.com and LinkedIn](https://i.ytimg.com/vi/lBj9maByMdQ/default.jpg)
![Tax on PF (Provident Fund) Employee PF and Employer PF](https://i.ytimg.com/vi/cPDfJOmVfyo/default.jpg)
![Automatic Attendance Sheet in Excel with Formula in Hindi | How to Make Attendance Register | IPTM](https://i.ytimg.com/vi/JAVoQel5HrE/default.jpg)