Sir one more request to you for creating simple and compounding interest calculation table. In this worksheet table coloumn are start date,end date, period, interest amount, TDS amount, remaining interest amount, principal amount.now as soon as we select the period , rate of interest and interest amount with TDS deduction and remaining interest amount to be continued with principal till maturity.but every year interest And TDS amount should be counted as per financial year wise. Means if We kept amount on 10nov20 so interest and TDS to be calculated till 31mar2021.then every year interest amount and TDS amount to be shown till maturity date.please create video on this ASAP. It's very very important and helpful to us.thank you very much in advance.
Is subject ke liye hamne New taxable slab ka table ka screen shot send kyon ki kuch slab me taxable figure minus ma aa raha hai to aapse guzarish k Zara check kijiye mere worksheet may and new slab ke hisab se tax calculator table kaisa hoga ye check kariye or kaha mistake hain ye show kijiye ASAP
Sir, In Income Tax Calculation there is calculation method is different from you have posted in this video, There are step for calculation up to 2,50,000 - nil 2,50,000 to 5,00,000 -10% But amount between 5,00,000 to 10,00,000- I want to learn formula to calculate tax above 10% Tax slab amount + 20% of amount ( between above 5,00,000 and bellow 10,00,000) How can we calculate by formula ?
Respected Sir, I am working in Postal Department, I Have a data based on which I have to calculate commission to employees, Here they prepare manually and submit , Can You Help to Prepare Excel file for calculations of commission.. I will be very Grateful 🙏 I have all the rule and conditions , Percentage rate of commission that can be required for preparation of excel... Please
how to make it serial 5with alphabets in zig, zig mode.i.,e, 1, 5a, 2, 16, 18b, 20, 30c etc. Please suggest me formulae for this , making it as serial 1,1a, 1b, 1c, 2, 2a, 2b etc.
👉 Buy Excel Course: TechGuruPlus.com/Excel-Course
👉 My Instagram: instagram.com/TechGuruPlus
👉 Facebook Group: facebook.com/groups/ExcelExpertGroup
Sir Aapka Jo samjhneka tarik Hain bahut achha he
I get much help through this video
Nazim bahi zbr10
Bhai nice explanation
Very Nice Sir
Nice video sir g
sir agli video tamam formula aur in k function ka use pe banaayn please k formuly kin jaghon per uese hongaayn
Shukria
Sir your excel course is good . please make more videos on macros
sure
Please create taxable slab and calculation as per New slabs rate of fy-2020-21.it is very helpful to us.thanks
Sir one more request to you for creating simple and compounding interest calculation table. In this worksheet table coloumn are start date,end date, period, interest amount, TDS amount, remaining interest amount, principal amount.now as soon as we select the period , rate of interest and interest amount with TDS deduction and remaining interest amount to be continued with principal till maturity.but every year interest And TDS amount should be counted as per financial year wise. Means if We kept amount on 10nov20 so interest and TDS to be calculated till 31mar2021.then every year interest amount and TDS amount to be shown till maturity date.please create video on this ASAP. It's very very important and helpful to us.thank you very much in advance.
Good
Sir make debtors aging vedio. If payment received then its show no dues or if not receive then its show due with over due dt.
Is subject ke liye hamne New taxable slab ka table ka screen shot send kyon ki kuch slab me taxable figure minus ma aa raha hai to aapse guzarish k Zara check kijiye mere worksheet may and new slab ke hisab se tax calculator table kaisa hoga ye check kariye or kaha mistake hain ye show kijiye ASAP
Sir, In Income Tax Calculation there is calculation method is different from you have posted in this video,
There are step for calculation up to 2,50,000 - nil
2,50,000 to 5,00,000 -10%
But amount between
5,00,000 to 10,00,000-
I want to learn formula to calculate tax
above 10% Tax slab amount + 20% of amount ( between above 5,00,000 and bellow 10,00,000)
How can we calculate by formula ?
Respected Sir,
I am working in Postal Department, I Have a data based on which I have to calculate commission to employees,
Here they prepare manually and submit , Can You Help to Prepare Excel file for calculations of commission..
I will be very Grateful 🙏
I have all the rule and conditions , Percentage rate of commission that can be required for preparation of excel...
Please
Ye great wala formula h kya
how to make it serial 5with alphabets in zig, zig mode.i.,e, 1, 5a, 2, 16, 18b, 20, 30c etc. Please suggest me formulae for this , making it as serial 1,1a, 1b, 1c, 2, 2a, 2b etc.
Income tax ka calculation working wrong aayega aapke formate se
700000 ka tax 70000 kaise aayega