Calculate Deprecation in MS Excel |Methods of Deprecation in Microsoft Excel |Online Excel Training
HTML-код
- Опубликовано: 22 фев 2018
- Learn how to calculate deprecation in MS Excel. How to use Different Methods of Deprecation in Microsoft Excel? Learn how to calculate deprecation on fixed asset in excel. What is the formula of depreciation used to calculate deprecation for straight line method (SLM) of depreciation and written down value method (WDV) of depreciation? How to calculate depreciation as per company law in excel using depreciation functions such as SLN and DB? You can easily create depreciation calculator in excel. This is our online excel training Hindi video excel tutorial. You can learn Microsoft excel online. Watch to learn depreciation rate formula in excel. Learn all about reducing balance depreciation formula in excel. Watch to learn fixed assets management in excel.
We provide excel online classes, so you can learn and study Microsoft Excel online. It is Full Step by Step Excel Tutorial in Hindi. This Advance Excel Tutorial is a Part of Microsoft Office Training Course run by Career Planet.
👉Excel for Accountants-
• Excel for Accountants
👉MS EXCEL- ADVANCE SHORTCUT KEYS Part-2
• MS EXCEL- ADVANCE SHOR...
👉Watch all MS Office Tutorials- for RSCIT, CCC, O level and PGDCA Courses-
• RSCIT Computer Course|...
👉GST Accounting Entries in Tally Day by Day -
• GST Tally Hindi
👉Click to Watch Basic Tally Accounting Video Day By Day-
• Learn Tally Erp 9 Basi...
👉Watch Provision for Depreciation Entry in Tally ERP 9| Accumulated Depreciation in Tally
• Provision for Deprecia...
👉Watch-Depreciation Entry in Tally ERP 9 with GST SLM Method
• Depreciation Entry in ...
👉Visit Our Website:
cpitudaipur.com/
👉Visit Our Blog:
cpitudaipur.blogspot.in/
👉Like Our Facebook Page:
/ cpitudr
👉Please Subscribe to Our Channel
/ @careerp
Very nice explaination. It's helpful. Thanks a lot.
I love your teaching
Thanks sir..for better teaching method
Amazing man really nice explaination
Thanks a lot
Bohot acha samjhaya aapne. Great video!
Marksheet mai grade nikalne ke liye sabhi laptops ka alag formulas hote hai kya, mene youtube pr kaafi video par formula dekha but mere laptop mai lag hi nhi rha.
Very very thanks
Umeed se b ziyada sikhne mila is video me
Extremely thanks to u sir ur my great sirrrrŕrrrrr
Most welcome, keep learning👍
Namaskar Sir apkay saray video Accounting kay fild ma kafi use full ha thanksing u very much sir.
Explained very well 👏 👏
Thax sir...
Thanks... Your all uploaded videos are really helpful for us. And the way, you tell us about short tricks in excel is very important for us...
Most welcome, keep learning👍💐
sir, you r , excellent, superb, outstanding, extra ordinary person. thanks
Most welcome, keep learning👍💐
Love you sir❤️
thanks
Very good sir.
Many many thanks
Good formula of depreciation and very useful for everyone
Thanks
Need depreciation as per companies act in excel
Thank you soo much
Welcome 😊
Nice.Very Informative.
Bahoot bahoot shukriya Bhai for making this type videos
Most welcome👍
Sir apka sab video hit hay 👍
Thank you so much
Mast ta
Nice video thank you....
Thank you
You're welcome
Thankyou sir 🇮🇳❤️🇮🇳 it very helpful
Thank sir
Sir मैंने ये table बिलकुल perfect बनाई thank u so much
Good, ऐसे ही परफेक्ट हो जावोगे
Thanx a million dear
Welcome
Appreciated
Nice video sir but how can we make calculation of wdv method in main depreciation sheet, please make a short video on that too
Thanx,i need as per Co's Act
Nice one Thank you sir
Welcome
Thank you sir
Welcome
Make video on depreciation as per companies act
Thanks for onece again
Welcome
NICE
Thanks
nice concept sir thanks
Welcome
very nice & useful video sir
thanks a lot
Very helpful video
Glad it was helpful!
awesome video
Thanks
Please upload as per company act depreciation actual rates calculation with example
best video sir ❤....
Thanks a lot 😊
@@careerp 30+ students ko padha chuka hu me is video ki help se....or age bhi kam ayega..
thanks for the video.
Sir could u plz upload the video for accumulated depreciation methods
Very Nice Sir
Thanks
Hi sir, This ganesh i want learn how to finalised company balance sheet in tally as per scheduled and how to make finacial statement in one vedio
Very nice sir....
Thank you so much💐
Please upload as per companies act depreciation actual rates calculation with example
Nice
Thanks💐
Nice video sir
Thanks
Happy Republic Day Sir🌹🙏
Same to you
Sir pls make a video of depreciation calculation as per income tax act and company act.
Nice video content! Apologies for the intrusion, I would appreciate your opinion. Have you thought about - Taparton Body Saving Takeover (do a search on google)? It is an awesome exclusive guide for enjoying life and free yourself of any internal mind blocks minus the headache. Ive heard some super things about it and my BF finally got cool success with it.
Hello sir please upload how to depreciation in companies act and IT act sir
very nice
Thanks
Sir ek schedule ii ka banaye na plzzz.
Addition and disposal ek he line mai add kiye to first computer ki NBV kaise milengi. Koi manual formula ka idea day sakte ho sir. Jaise previous year depression plus current year and total. With four years life.. No salvage value
very nice v.. for calculate deprecetion in excel can I tell me sir how to create attendance list and salary sheet
Salary statement ,payroll video in Excel already uploaded, plz watch
Sir 1 request hain aap konsa software use krte ho
Sir very nice video ultimate but I can't understand one thing as we have calculate deprication,then we should subtract it from original value but last part in video we calculate depreciation by multiplying with rate.Can you please tell me what is meaning of gross block. Plz Sir Reply it's my humble request plz
please also share excel working file. it becomes easy for us to practice on that file while watching video.
If you do have added % column in working ,it would have been even better to understand.
Statement me tho formula ko lagaya hi nhi gya simply depreciation nikal liya gya
It would have been better if link olfor the excel sheet...
Sir sln or wdv method mai depreciation ki value अलग अलग kyo hai?
दूर ये table tally से export kiya hai kya?
Sir senario management bhi batana sir Excel Mee accounts kee bare mee
Ok
Career Planet Computer Education tnq sir
As per company act h ys income tax
Sir assets ko September ki baad purchase karenge us par is formula ko kaise put karenge??
Total depreciation value ko 2 se divide kar do
ITR k upar video baniya (Income Tax)
ITR 1
" 2
" 3
" 4
" 5 and so on
Ok
Excel full course 1 video me muko to achahota
Sir hum kisi product ki service ( repairing) par jaroori new items ki sale and service (repairing) entry sath me kese karege.
Sir please reply
Please make video on this.
Ok i do it👍
I have a doubt regarding this how to reach out to u
Sir agar Microsoft Excel me verify aur license ko control panel me Jake repair krne kaha jaye to usee kaise solved kre plz reply sirr
how to calculate salvage value?
Rate of depreciation tuu mention nhi hh
Thank you sir but बहुत अभ्यास करना है तभी दिमाग मे बैठेगा
Keep learning😊
Sir wo db formula se depreciation nikal liya to iss Excel me 60 percent fir depreciation kyu lagaya hai
Rupee simbol kese lay aal
First method me year tho change nhi hua uper se price bhi ek hi a rha tha
rate ka toh aaya ni isme excel me rate kya uthaye formule m
Not showing correct value
this isn't English video
Thanks sir
Welcome😊