HOW TO CREATE PAYROLL|SALARY SHEET| PAYSLIP IN EXCEL(Hindi)

Поділитися
Вставка
  • Опубліковано 26 сер 2024
  • #MsExcelCourse #SalarySheet #PayslipExcel
    Learn How to Create Payroll, Payslip, or Salary Statement in MS-Excel. How to Calculate DA, HRA, PF, Gross Salary, EPF, LIC, Total Deductions, and Net Salary in Hindi. Also, learn how to format or Design a Salary Sheet for your employees. Learn Excel basic formulas for Sum, Percentage, Subtraction, etc. It is a complete Microsoft Excel training tutorial.
    Create Salary Statement in excel, create payroll in excel, create salary sheet in excel.
    Useful for the Rscit course and all computer courses such as ccc, bcc,o level, PGDCA students, also useful for students who are applying for govt job competition exams.
    👉 Learn Basic Computers in Hindi- • Learn Basic Computer i...
    👉 Watch - MS Excel Paste Special Advance in Hindi -
    • MS Excel Paste Special...
    👉 Watch-MS Excel Paste Special Advance in Hindi
    • MS Excel Paste Special...
    👉Watch- Sum, Multiplication, Subtraction & Division in Excel
    • MS Excel Sum,Multiplic...
    👉Visit Our Website:
    www.cpitudaipur...
    👉Visit Our Blog:
    cpitudaipur.blo...
    👉Like Our Facebook Page:
    / cpitudr

КОМЕНТАРІ • 1,5 тис.

  • @roshanishiware3757
    @roshanishiware3757 3 роки тому +5

    Bahut achcha h itna saf tarike se hamare teacher nhi smjhaye the

  • @siddharthsuman297
    @siddharthsuman297 4 місяці тому +4

    Sir thoda practical explanation dete to zyaada samajh me aata (example - attendance wise) like for how leaves are there, how many paid days etc. In a very concise manner

  • @Factisfact_883
    @Factisfact_883 9 місяців тому +2

    Its very helpful i have a offer from payroll company for payroll job but I don't have any experience but i have basic knowledge now bcoz of this video ❤

  • @Monukumar-ep6te
    @Monukumar-ep6te 4 роки тому +3

    Outstanding Sir ,,, Aap Bohoot acha Samjhaate hai Or Seekhne Ki Chahat bhi badh rahi h ,, pls Aise He Sikhana Complete course

  • @mohitbhardwaj5712
    @mohitbhardwaj5712 3 роки тому +10

    Sir , you are amazing , you method is very different from others , you explained this difficult topic in very essy to understand method ... Thanks

    • @masterjitoo
      @masterjitoo Рік тому

      Still facing payroll issue
      Reach out to us

  • @t.p.aeverythinggaming4240
    @t.p.aeverythinggaming4240 Рік тому +3

    Thanks sir 🙂 muje apka ye video bahut hi useful Raha. thanks sir 🙂
    Keep it up 👍👍👍

  • @aadityachaudhary0909
    @aadityachaudhary0909 Рік тому +1

    Sir aapka jawab nahi pure youtube pe etna achha video nahi hai

  • @lachmilohar3775
    @lachmilohar3775 2 роки тому +2

    Thank you very much sir app ka samnjhane ka tarika bohut acha laga.

  • @aartibisht5377
    @aartibisht5377 Рік тому +5

    Amazing video Sir you explain everything in a very easy and very simple language... Nice video sir Thank you so much sir

  • @mridulbarman959
    @mridulbarman959 6 років тому +5

    Your explanation is really very good. No time wasting. Going straight to the point.

    • @careerp
      @careerp  6 років тому

      Thank you so much👍

  • @dipakgawande6448
    @dipakgawande6448 4 роки тому +2

    Bahut khoob Bhai ... Sab kuch acche se dimag me fass gya ..

  • @user-fz2yn5kw3b
    @user-fz2yn5kw3b Рік тому +2

    very simply and neatly explained ,thank you people

  • @anamika3008
    @anamika3008 4 роки тому +6

    very simple and informative, please make advance payroll process in excel

  • @zuhaibsiddiqui5118
    @zuhaibsiddiqui5118 Рік тому +3

    Simplest and easiest way to learn
    Amazing skills.

  • @crazzystuff7265
    @crazzystuff7265 4 роки тому +4

    You got me job. Love from other corner of the world.

  • @javidahmad2718
    @javidahmad2718 2 роки тому +2

    Love u brother best explanation to the point
    No time waste

  • @ombannasa398
    @ombannasa398 3 роки тому +12

    Thanku very very much❤

    • @careerp
      @careerp  3 роки тому

      Most welcome 😊

  • @Akanksha_FDC999
    @Akanksha_FDC999 2 роки тому +4

    Very nice sirji

  • @rasheedsvlog9125
    @rasheedsvlog9125 4 роки тому +2

    Very easily explained... thank u brother

  • @kishuchauhan7748
    @kishuchauhan7748 3 роки тому +1

    Bhut hi achha sir, aapke es video ko dekhkr meri salary 30k ho gyi h Delhi me

    • @careerp
      @careerp  3 роки тому

      Great, keep learning💐💐

  • @soumitramahapatra3752
    @soumitramahapatra3752 6 років тому +11

    Sir your teaching style is outstanding, thank you so much.

    • @careerp
      @careerp  6 років тому

      Most welcome, keep learning👍

  • @allaboutanabia5283
    @allaboutanabia5283 6 років тому +4

    Thanks a lot....due to this video I've got the job🤗🤗🤗 .....liked and subscribed

    • @careerp
      @careerp  6 років тому

      Congratulations👍👍,keep learning💐

  • @DreamBoypune
    @DreamBoypune 2 роки тому +1

    Maui pagal ho gaya sir
    Kitna Aasanise padate ho yarrr..So big fan sir..Thankyou so much sir😊

  • @babar_shani91
    @babar_shani91 6 років тому +1

    This is a good Payroll. i am a Payroll my section. both of Payroll and Data Entry Operator. Thanks u

    • @careerp
      @careerp  6 років тому

      +Babar Shahzad Waseem ,👍

  • @VivekTheMesmerizer
    @VivekTheMesmerizer 7 років тому +5

    Thanks for this video Sir, found it useful. Immediately subscribed after watching.
    A small request , could u please upload a video on 'Arrear' , what it is & how to calculate it in excel like we did in this video? ☺

  • @emaan_choudhry
    @emaan_choudhry 3 роки тому +3

    It’s very helpful for me bc I am doing accounting

  • @Ajay-gx3dw
    @Ajay-gx3dw 5 років тому +1

    Yeh dislike krne waale kon h kaha se aate h
    Koi nhi h Jo apni knowledge itni jaldi share krde
    Kamse Kam pehle takleef toh batao Kya h?

  • @VivekGupta-uo7ix
    @VivekGupta-uo7ix Рік тому +1

    thank you so much sir and very usefull this video for fresher candidates

  • @priyankadey4957
    @priyankadey4957 6 років тому +14

    Thank you so much sir for this wonderful explanation of preparing Payroll..👍

  • @bibhutibhoi1
    @bibhutibhoi1 5 років тому +6

    this was very basic...
    I hope i wll learn a lot from you....

  • @gududum.s7412
    @gududum.s7412 4 роки тому +3

    Sir your presentation is excellent.

    • @careerp
      @careerp  4 роки тому

      Many many thanks

  • @mrktv2531
    @mrktv2531 6 років тому +1

    Masha Allah buhat acha tarika hai aap k samjhane ka Nice bro

    • @careerp
      @careerp  6 років тому

      +Mr k tv ,Thank you so much

  • @mummyskitchen748
    @mummyskitchen748 5 років тому +4

    Thank you so much sir for this video, I easily learn how to make salary, please can u share video how to work in PF, ESI and GST in online site and what kinds of documents are required for this.

    • @careerp
      @careerp  5 років тому

      Plz watch our payroll series in tally video👍

  • @natashatimothy6638
    @natashatimothy6638 6 років тому +5

    Superb sir you taught it in such an amazing way :)

    • @careerp
      @careerp  6 років тому +1

      Most welcome

  • @govindkushwaha5573
    @govindkushwaha5573 3 роки тому +1

    Sir kam samaye me aapne bahut achha samjhaya

  • @aktheraara244
    @aktheraara244 4 роки тому +2

    You teaching is amazing.... Thank you sir...

  • @surajitghatak9134
    @surajitghatak9134 7 років тому +7

    This is a time saving system. It's help to update data from excel to Tally.

  • @chaithraharshi2131
    @chaithraharshi2131 6 років тому +5

    Excellent one..Very useful for freshers . A simple one which can be easily understood and implemented within short span

    • @careerp
      @careerp  6 років тому +2

      Thank you so much👍

  • @RekhaKumari-de9xo
    @RekhaKumari-de9xo Рік тому

    Very good sir ap bahut achha se samjhte hai thank you so much sir

  • @mohdmohsin7048
    @mohdmohsin7048 5 років тому +5

    Thank you so much, sir, for this wonderful explanation of preparing Payroll.👍

  • @amitpattnayak890
    @amitpattnayak890 5 років тому +5

    How do you consider PF within gross salary !!? Please explain.
    also through some light on difference between PF & EPF.

    • @kaifshaikh6682
      @kaifshaikh6682 2 роки тому

      PF MEANS provident fund which is a contribution of employee means worker
      And one is employer pf deduction it means epf which is a contribution of employer the company

    • @masterjitoo
      @masterjitoo Рік тому

      Still facing payroll issue
      Reach out to us

  • @danialmuzaffar7327
    @danialmuzaffar7327 Рік тому +1

    So awesome ❤❤❤

  • @jagjitSingh-jj5ge
    @jagjitSingh-jj5ge 5 років тому +1

    thank u sir muje hra da formula samj ni aw raha tha PR aap ne boht hi asche tarike se samja a aw

    • @careerp
      @careerp  5 років тому

      Thank you so much🙏🙏🙏

  • @subratasarkar9684
    @subratasarkar9684 5 років тому +4

    Very very good Sir, ,
    Thank you soo much! ANd Most helpful a Video

    • @careerp
      @careerp  5 років тому +1

      Most welcome🙏🙏🙏

  • @akeelaanas7723
    @akeelaanas7723 5 років тому +4

    It was really helpful...thank u soo mch!!!!

    • @careerp
      @careerp  5 років тому

      Most welcome, keep learning👍

  • @manjitkakati1906
    @manjitkakati1906 6 років тому +1

    thnk u so much for your video. very easily and quickly u have taught me how to create payroll. thanks a lot

    • @careerp
      @careerp  6 років тому

      +Manjit Kakati ,most welcome, keep learning

  • @theoctopusbusinessservices668
    @theoctopusbusinessservices668 4 роки тому +2

    It was nice learning from you sir

    • @careerp
      @careerp  4 роки тому

      Thank you so much🙏🙏

  • @mahiuddin3963
    @mahiuddin3963 6 років тому +4

    It's good to learn, thanks a lot

    • @careerp
      @careerp  6 років тому

      Most welcome

  • @waseemakram2374
    @waseemakram2374 5 років тому +4

    bro live long, & keep sharing

  • @delilahfernandes7417
    @delilahfernandes7417 2 роки тому +1

    So easy technic loved ur explanation keep it up

    • @careerp
      @careerp  2 роки тому +1

      Thanks a lot 😊

  • @saisaravanan234
    @saisaravanan234 5 років тому +4

    I can understand, thank you.

  • @ganeshdhakad7078
    @ganeshdhakad7078 5 років тому +3

    Thanks you so much for making vedieo.

    • @careerp
      @careerp  5 років тому

      Most welcome, keep learning🙏🙏🙏

  • @akkarthik2622
    @akkarthik2622 8 місяців тому +1

    Very good sir it useful to freshers like me ❤

    • @careerp
      @careerp  8 місяців тому

      Glad to hear that

  • @gaganrajput1015
    @gaganrajput1015 7 років тому +1

    Just saw ur video.. ur way of teaching is superb. Thanks for such useful video.

    • @careerp
      @careerp  7 років тому +1

      +Gagan Soni , most welcome soni sb, keep learning.

  • @sonykumari6371
    @sonykumari6371 2 роки тому +4

    Bahut achha

  • @Anita-ew1ni
    @Anita-ew1ni 5 років тому +3

    So useful 😃

    • @careerp
      @careerp  5 років тому

      Thanks🙏🙏

  • @sumitpatil7445
    @sumitpatil7445 Рік тому

    Maja aaa gya bhai...
    Bhut Acha vedeo h...nice trick

  • @farhanansari9813
    @farhanansari9813 3 місяці тому +1

    Thank you so much sir for the amazing explanation.

    • @careerp
      @careerp  2 місяці тому

      Happy to help

  • @08jd
    @08jd 7 років тому +11

    very informative thank you so much for the video

    • @careerp
      @careerp  7 років тому

      +Janu Dj , most welcome..

    • @jawahirebashir6187
      @jawahirebashir6187 6 років тому

      Janu Dj
      ,,,

    • @mohansinghbais7447
      @mohansinghbais7447 6 років тому

      Cordenet calculation

    • @kumarujjwal4442
      @kumarujjwal4442 4 роки тому

      @@careerp what if there is conditon that salary below 20000 will get 20%hra and above that will get 30% but it will not exceed 4000

  • @heebakausar2178
    @heebakausar2178 6 років тому +22

    Why you have added pf in the gross salary and then deducted epf ..in my knowledge there is no difference in pf and epf..kindly make it clear

    • @bijendersingh4458
      @bijendersingh4458 5 років тому +4

      Pf is paid by employer and epf is contribution from employee

    • @deepakk4393
      @deepakk4393 5 років тому +1

      In pf , half of amount contribute by employee and half by employer

    • @dipakjha5546
      @dipakjha5546 5 років тому +1

      Pf v do Tarah ka hota hai
      1)professional tax-calculated on basic salary
      2)provident fund-calculated on gross salary

    • @mallikarjunmondi5616
      @mallikarjunmondi5616 4 роки тому

      @@bijendersingh4458 If PF paid by employer you credited into salary, then 50% deducted for tender epf, remaining 50% is employee account. actually that employer contribution amount also paid epf na. As sheet employ had a cash employer contribution amount.

  • @bahamonimurmu8620
    @bahamonimurmu8620 3 роки тому +2

    Thanks sir, your teaching is very good...

    • @careerp
      @careerp  3 роки тому

      Always welcome

  • @YoyoJkg
    @YoyoJkg 2 роки тому +1

    Boht boht acha tha✨✨✨✨✨✨✨✨

  • @faijanraza7205
    @faijanraza7205 6 років тому +4

    Nyccccccc.... video...
    Lekin is video me kuch kuch chor diye ho aap

  • @MegaUtkarshsharma
    @MegaUtkarshsharma 6 років тому +5

    Thanks for sharing this knowledge

  • @arshadkidwai2289
    @arshadkidwai2289 7 років тому

    VERY VERY THANKS SIR I AM ARSHAD SIR I AM FIRST TIME SEE YOUR VIDEOS

    • @careerp
      @careerp  7 років тому

      +ARSHAD KIDWAI ,most welcome and keep learning

  • @sdb5607
    @sdb5607 6 років тому

    yeh video mere liye bohot hi useful hai.

  • @swati1556
    @swati1556 6 років тому +4

    Sir aap bahut achcha padate ho

    • @careerp
      @careerp  6 років тому

      Thank you so much

  • @pariwartancomputersmkcl7926
    @pariwartancomputersmkcl7926 6 років тому +3

    Please provide above Excel sheet

  • @neelamyadav8075
    @neelamyadav8075 6 років тому +1

    Sir mujhe apke batane ka tarika accha laga. Discount sheet bhi sikh dijiye

    • @careerp
      @careerp  6 років тому

      +neelam yadav ,ok i try👍

  • @sumitkumar-ll2qi
    @sumitkumar-ll2qi 6 років тому +1

    very nice video I have learned many things from this video which is helpful in Data Entry Work

    • @careerp
      @careerp  6 років тому

      +sumit kumar ,Thank you so much

  • @minukumari863
    @minukumari863 6 років тому +4

    waw thanks

  • @sitakumari2926
    @sitakumari2926 7 років тому +13

    l like this video

  • @choudhary8574
    @choudhary8574 3 роки тому +1

    Sir bhut ache se samjaya

  • @mangaothman3350
    @mangaothman3350 6 років тому +2

    i like the way tutorials goes like....

    • @careerp
      @careerp  6 років тому

      +manga othman ,Thank you so much

  • @harsh4u11
    @harsh4u11 7 років тому +6

    where is professional tax

    • @TeachToEach
      @TeachToEach 7 років тому +3

      Professional tax is the tax which is levied on that income which earns by profession such as chartered accountant, company secretary, lawyer, doctor etc

  • @bipinkujur8985
    @bipinkujur8985 6 років тому +3

    how to calculate double increment alongwith grade pay in ms excel

  • @DEEPAKKUMAR-os4dl
    @DEEPAKKUMAR-os4dl 3 роки тому +1

    Apka video bahut achha lga sir

  • @manishchouhan8266
    @manishchouhan8266 7 років тому +1

    I like ur teaching methods..

    • @careerp
      @careerp  7 років тому

      +Manish Chouhan , thank you so much keep learning

  • @careerp
    @careerp  4 роки тому +27

    ______
    Learn A-to-Z of Payroll Processing & Labour Law Compliances, Visit: lpt.institute/courses/
    ______

  • @vipulnath6046
    @vipulnath6046 4 роки тому +1

    Bohot Accha laga thank you

  • @radhakrushnapanigrahy1703
    @radhakrushnapanigrahy1703 Рік тому +1

    Very nice.
    I want much more excel formats

  • @kishuchauhan7748
    @kishuchauhan7748 3 роки тому +1

    Bhut hi achha, clearly huaa

  • @barkathnishanisha9028
    @barkathnishanisha9028 2 роки тому +1

    Super bro ur taking the class very nicely I understood everything tq lot

  • @shizandawoodshaikh1289
    @shizandawoodshaikh1289 5 років тому +2

    You did a good work in short time, man. Its very helpful to learn and work with shortcuts in small amount of time. Great

    • @careerp
      @careerp  5 років тому

      Thank you so much💐

  • @vijaylaxmisharma6318
    @vijaylaxmisharma6318 6 років тому +1

    sir aapki jitni praise kro utni hi kam h.

  • @mohammadmeraj7219
    @mohammadmeraj7219 7 років тому +1

    I liked your video, because I got to learn a lot

  • @Alliswell-we6xr
    @Alliswell-we6xr 4 роки тому +1

    Superbbb explain sir..
    Thank you so much

    • @careerp
      @careerp  4 роки тому

      Always welcome

  • @ginnibhagat
    @ginnibhagat 5 років тому +1

    Bhut hi easy way se smjaya aapne🙏

    • @careerp
      @careerp  5 років тому

      Thank you so much💐

  • @lonesuhail5180
    @lonesuhail5180 21 день тому +1

    Bohat Acha method thanks sir

    • @careerp
      @careerp  20 днів тому +1

      Most Welcome, Keep Learning

  • @skkasemali9734
    @skkasemali9734 7 років тому +1

    video is very use full my life

    • @careerp
      @careerp  7 років тому

      +Sk Kasem Ali ,thanks

  • @priyanka_79319
    @priyanka_79319 2 роки тому +2

    Thank you so much, this video really very helpful. 🙌🏻😊

    • @careerp
      @careerp  2 роки тому

      Glad it was helpful!

  • @rabisankarnath3674
    @rabisankarnath3674 6 років тому +1

    Bohot kuch Sikhne ko Mila... Thanks...

    • @careerp
      @careerp  6 років тому

      Most welcome💐

  • @khursheedahmad5640
    @khursheedahmad5640 6 років тому +1

    Liked the video, as it helped to understand excel more clearly

    • @careerp
      @careerp  6 років тому

      +Khursheed Ahmad ,Thank you so much

  • @surajitchatterjee8010
    @surajitchatterjee8010 6 років тому +1

    Bohot a66a sikhaya apne, thnk u 4 this vdo.

    • @careerp
      @careerp  6 років тому

      Most welcome👍

  • @simapaul4124
    @simapaul4124 2 роки тому +1

    Impressive Sir...thanks for this type of video

    • @careerp
      @careerp  2 роки тому +1

      Glad you liked it

    • @simapaul4124
      @simapaul4124 2 роки тому

      @@careerp really you are perfect teacher...if any one want to learn then they can from your video.

  • @Nilesh...025
    @Nilesh...025 Рік тому +2

    Sir thank u for this fluent explaination ❤️

  • @mehakupadhyay5886
    @mehakupadhyay5886 2 роки тому +1

    Thankuh sir such a good information 😀

  • @maheshprasadgond9864
    @maheshprasadgond9864 9 місяців тому

    Great bhai....bohot ache...

  • @parthomittro9393
    @parthomittro9393 4 роки тому +1

    Very nice presentation .
    Very helpful to learn Advance Excel Payroll

    • @careerp
      @careerp  4 роки тому

      Many many thanks

  • @tanaysrivastav19
    @tanaysrivastav19 2 роки тому +1

    Thnq so much ...very helpful video ...☺️

    • @careerp
      @careerp  2 роки тому

      Most welcome 😊