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

Комментарии • 118

  • @nithuverma6390
    @nithuverma6390 4 года назад +2

    Very nice explaination. It's helpful. Thanks a lot.

  • @chetanpandit3208
    @chetanpandit3208 5 лет назад +1

    I love your teaching

  • @MrHardeep63
    @MrHardeep63 4 года назад +1

    Thanks sir..for better teaching method

  • @vishalbajpayee8759
    @vishalbajpayee8759 4 года назад +1

    Amazing man really nice explaination
    Thanks a lot

  • @Manas_Choudhary
    @Manas_Choudhary 3 года назад +2

    Bohot acha samjhaya aapne. Great video!

    • @The_Land_of_kings2006
      @The_Land_of_kings2006 7 дней назад

      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.

  • @know4832
    @know4832 6 лет назад +3

    Very very thanks
    Umeed se b ziyada sikhne mila is video me
    Extremely thanks to u sir ur my great sirrrrŕrrrrr

    • @careerp
      @careerp  6 лет назад

      Most welcome, keep learning👍

  • @durgeshagrawalagrawal6963
    @durgeshagrawalagrawal6963 3 года назад

    Namaskar Sir apkay saray video Accounting kay fild ma kafi use full ha thanksing u very much sir.

  • @kirti108
    @kirti108 2 года назад +1

    Explained very well 👏 👏

  • @HEM3211
    @HEM3211 3 года назад +1

    Thax sir...

  • @saurabhsinghkharwar4206
    @saurabhsinghkharwar4206 6 лет назад +1

    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...

    • @careerp
      @careerp  6 лет назад

      Most welcome, keep learning👍💐

  • @nimayram6029
    @nimayram6029 6 лет назад +1

    sir, you r , excellent, superb, outstanding, extra ordinary person. thanks

    • @careerp
      @careerp  6 лет назад

      Most welcome, keep learning👍💐

  • @CASanjayMpr2398
    @CASanjayMpr2398 7 месяцев назад +1

    Love you sir❤️

    • @careerp
      @careerp  7 месяцев назад

      thanks

  • @skasrafulhaque3080
    @skasrafulhaque3080 3 года назад +1

    Very good sir.

    • @careerp
      @careerp  3 года назад

      Many many thanks

  • @mukeshvaishnav6056
    @mukeshvaishnav6056 6 лет назад +2

    Good formula of depreciation and very useful for everyone

  • @dilipinkar6919
    @dilipinkar6919 5 лет назад +8

    Need depreciation as per companies act in excel

  • @yasmeenyasmeen3883
    @yasmeenyasmeen3883 3 года назад +1

    Thank you soo much

    • @careerp
      @careerp  3 года назад

      Welcome 😊

  • @ShohidulIslam-md5rz
    @ShohidulIslam-md5rz Год назад

    Nice.Very Informative.

  • @Wasimsir7
    @Wasimsir7 6 лет назад +1

    Bahoot bahoot shukriya Bhai for making this type videos

    • @careerp
      @careerp  6 лет назад

      Most welcome👍

  • @gopalpaul3293
    @gopalpaul3293 6 лет назад +2

    Sir apka sab video hit hay 👍

    • @careerp
      @careerp  6 лет назад

      Thank you so much

  • @SunilKumawat06021
    @SunilKumawat06021 3 года назад +1

    Mast ta

  • @tripatigadaba6199
    @tripatigadaba6199 5 лет назад

    Nice video thank you....

  • @OO-ez9lg
    @OO-ez9lg 3 года назад +1

    Thank you

    • @careerp
      @careerp  3 года назад

      You're welcome

  • @shashankkhede475
    @shashankkhede475 Год назад

    Thankyou sir 🇮🇳❤️🇮🇳 it very helpful

  • @sumanparas5344
    @sumanparas5344 Год назад

    Thank sir

  • @sumitrachauhan6839
    @sumitrachauhan6839 6 лет назад +2

    Sir मैंने ये table बिलकुल perfect बनाई thank u so much

    • @careerp
      @careerp  6 лет назад +1

      Good, ऐसे ही परफेक्ट हो जावोगे

  • @chandraprakshjha5330
    @chandraprakshjha5330 6 лет назад +1

    Thanx a million dear

  • @sopumukherjee5648
    @sopumukherjee5648 Год назад

    Appreciated

  • @rahulmehra375
    @rahulmehra375 6 лет назад +2

    Nice video sir but how can we make calculation of wdv method in main depreciation sheet, please make a short video on that too

  • @gautamsarkar4978
    @gautamsarkar4978 4 года назад +1

    Thanx,i need as per Co's Act

  • @milind131
    @milind131 6 лет назад +1

    Nice one Thank you sir

  • @birjushaw3656
    @birjushaw3656 5 лет назад +1

    Thank you sir

  • @subhampaul9835
    @subhampaul9835 3 года назад +2

    Make video on depreciation as per companies act

  • @know4832
    @know4832 5 лет назад +1

    Thanks for onece again

  • @kinzangchhoden6954
    @kinzangchhoden6954 3 месяца назад +1

    NICE

  • @pawantally6226
    @pawantally6226 6 лет назад +1

    nice concept sir thanks

  • @himalayagoswami3409
    @himalayagoswami3409 6 лет назад +1

    very nice & useful video sir

    • @careerp
      @careerp  6 лет назад +1

      thanks a lot

  • @skhappylyrics3704
    @skhappylyrics3704 3 года назад +1

    Very helpful video

    • @careerp
      @careerp  3 года назад

      Glad it was helpful!

  • @mohammedhaq8415
    @mohammedhaq8415 6 лет назад +1

    awesome video

  • @OO-ez9lg
    @OO-ez9lg 3 года назад +1

    Please upload as per company act depreciation actual rates calculation with example

  • @jccofficial5684
    @jccofficial5684 3 года назад +2

    best video sir ❤....

    • @careerp
      @careerp  3 года назад +1

      Thanks a lot 😊

    • @jccofficial5684
      @jccofficial5684 3 года назад +1

      @@careerp 30+ students ko padha chuka hu me is video ki help se....or age bhi kam ayega..
      thanks for the video.

  • @79prasa
    @79prasa 2 года назад +1

    Sir could u plz upload the video for accumulated depreciation methods

  • @deepakkumar-kt4kg
    @deepakkumar-kt4kg 6 лет назад +1

    Very Nice Sir

  • @ganeshpatole2728
    @ganeshpatole2728 5 лет назад +1

    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

  • @lalitsurse144
    @lalitsurse144 5 лет назад +1

    Very nice sir....

    • @careerp
      @careerp  5 лет назад

      Thank you so much💐

  • @OO-ez9lg
    @OO-ez9lg 3 года назад

    Please upload as per companies act depreciation actual rates calculation with example

  • @indrajeetkumarsingh48048
    @indrajeetkumarsingh48048 4 года назад +1

    Nice

  • @riyanegi318
    @riyanegi318 5 лет назад +1

    Nice video sir

  • @balkanyapatil3834
    @balkanyapatil3834 3 года назад +1

    Happy Republic Day Sir🌹🙏

  • @mayamatikulkarni4389
    @mayamatikulkarni4389 4 года назад +1

    Sir pls make a video of depreciation calculation as per income tax act and company act.

    • @mariagomezlugo7774
      @mariagomezlugo7774 4 года назад

      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.

  • @Abdul-up3tl
    @Abdul-up3tl 3 года назад +1

    Hello sir please upload how to depreciation in companies act and IT act sir

  • @PROCHEM_HFEIndia
    @PROCHEM_HFEIndia 6 лет назад +1

    very nice

  • @rajadey1552
    @rajadey1552 3 года назад +1

    Sir ek schedule ii ka banaye na plzzz.

  • @sam6524
    @sam6524 2 года назад +1

    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

  • @amitabhyadav8299
    @amitabhyadav8299 6 лет назад +1

    very nice v.. for calculate deprecetion in excel can I tell me sir how to create attendance list and salary sheet

    • @careerp
      @careerp  6 лет назад +1

      Salary statement ,payroll video in Excel already uploaded, plz watch

  • @chetanpandit3208
    @chetanpandit3208 5 лет назад +1

    Sir 1 request hain aap konsa software use krte ho

  • @kirandeepchoudhry9232
    @kirandeepchoudhry9232 5 лет назад

    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

  • @FahmeDeen313
    @FahmeDeen313 2 года назад

    please also share excel working file. it becomes easy for us to practice on that file while watching video.

  • @Hindmahasagarthat
    @Hindmahasagarthat 3 года назад

    If you do have added % column in working ,it would have been even better to understand.

  • @DeepakSharma-sp7wh
    @DeepakSharma-sp7wh 3 года назад +1

    Statement me tho formula ko lagaya hi nhi gya simply depreciation nikal liya gya

  • @kunalnitin5229
    @kunalnitin5229 3 года назад

    It would have been better if link olfor the excel sheet...

  • @mayursaini27
    @mayursaini27 6 лет назад +1

    Sir sln or wdv method mai depreciation ki value अलग अलग kyo hai?

  • @mayursaini27
    @mayursaini27 5 лет назад +1

    दूर ये table tally से export kiya hai kya?

  • @laxmanreddy5331
    @laxmanreddy5331 6 лет назад +1

    Sir senario management bhi batana sir Excel Mee accounts kee bare mee

  • @SunilSingh-er2lo
    @SunilSingh-er2lo 2 года назад

    As per company act h ys income tax

  • @ashukumar881
    @ashukumar881 6 лет назад +2

    Sir assets ko September ki baad purchase karenge us par is formula ko kaise put karenge??

    • @careerp
      @careerp  6 лет назад

      Total depreciation value ko 2 se divide kar do

  • @gopalpaul3293
    @gopalpaul3293 6 лет назад +1

    ITR k upar video baniya (Income Tax)
    ITR 1
    " 2
    " 3
    " 4
    " 5 and so on

  • @chavadavijay3379
    @chavadavijay3379 6 лет назад +2

    Excel full course 1 video me muko to achahota

  • @harshitdhokiya3249
    @harshitdhokiya3249 6 лет назад +1

    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.

    • @careerp
      @careerp  6 лет назад

      Ok i do it👍

  • @fatemakapadia2176
    @fatemakapadia2176 2 года назад

    I have a doubt regarding this how to reach out to u

  • @somyamehra2239
    @somyamehra2239 6 лет назад

    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

  • @AshwinMJ
    @AshwinMJ 4 года назад

    how to calculate salvage value?

  • @Adityakumar-sr2ex
    @Adityakumar-sr2ex 4 года назад +1

    Rate of depreciation tuu mention nhi hh

  • @sumitrachauhan6839
    @sumitrachauhan6839 6 лет назад +1

    Thank you sir but बहुत अभ्यास करना है तभी दिमाग मे बैठेगा

    • @careerp
      @careerp  6 лет назад +1

      Keep learning😊

  • @earningwithvijay4773
    @earningwithvijay4773 Год назад

    Sir wo db formula se depreciation nikal liya to iss Excel me 60 percent fir depreciation kyu lagaya hai

  • @dkb1111
    @dkb1111 5 лет назад

    Rupee simbol kese lay aal

  • @DeepakSharma-sp7wh
    @DeepakSharma-sp7wh 3 года назад

    First method me year tho change nhi hua uper se price bhi ek hi a rha tha

  • @vipendrasinghnegi7352
    @vipendrasinghnegi7352 6 лет назад

    rate ka toh aaya ni isme excel me rate kya uthaye formule m

  • @sanajybishta
    @sanajybishta 3 года назад

    Not showing correct value

  • @metehan139
    @metehan139 4 года назад +1

    this isn't English video

  • @badalprajapati7
    @badalprajapati7 5 лет назад +1

    Thanks sir