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

Поделиться
HTML-код
  • Опубликовано: 19 авг 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 тыс.

  • @careerp
    @careerp  4 года назад +27

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

  • @roshanishiware3757
    @roshanishiware3757 3 года назад +5

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

  • @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 ❤

  • @t.p.aeverythinggaming4240
    @t.p.aeverythinggaming4240 Год назад +3

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

  • @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

  • @lachmilohar3775
    @lachmilohar3775 2 года назад +2

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

  • @aadityachaudhary0909
    @aadityachaudhary0909 Год назад +1

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

  • @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

  • @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👍

  • @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

  • @user-fz2yn5kw3b
    @user-fz2yn5kw3b Год назад +2

    very simply and neatly explained ,thank you people

  • @zuhaibsiddiqui5118
    @zuhaibsiddiqui5118 Год назад +3

    Simplest and easiest way to learn
    Amazing skills.

  • @anamika3008
    @anamika3008 4 года назад +6

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

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

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

  • @javidahmad2718
    @javidahmad2718 2 года назад +2

    Love u brother best explanation to the point
    No time waste

  • @crazzystuff7265
    @crazzystuff7265 4 года назад +4

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

  • @ombannasa398
    @ombannasa398 3 года назад +12

    Thanku very very much❤

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

      Most welcome 😊

  • @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 ,👍

  • @VivekGupta-uo7ix
    @VivekGupta-uo7ix Год назад +1

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

  • @emaan_choudhry
    @emaan_choudhry 3 года назад +3

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

  • @soumitramahapatra3752
    @soumitramahapatra3752 6 лет назад +12

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

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

      Most welcome, keep learning👍

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

    Very easily explained... thank u brother

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

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

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

    Very nice sirji

  • @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💐

  • @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?

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

  • @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

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

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

  • @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👍

  • @natashatimothy6638
    @natashatimothy6638 6 лет назад +5

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

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

      Most welcome

  • @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.👍

  • @surajitghatak9134
    @surajitghatak9134 7 лет назад +7

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

  • @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

  • @gududum.s7412
    @gududum.s7412 4 года назад +3

    Sir your presentation is excellent.

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

      Many many thanks

  • @VivekTheMesmerizer
    @VivekTheMesmerizer 6 лет назад +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? ☺

  • @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👍

  • @farhanansari9813
    @farhanansari9813 2 месяца назад +1

    Thank you so much sir for the amazing explanation.

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

      Happy to help

  • @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🙏🙏🙏

  • @akeelaanas7723
    @akeelaanas7723 5 лет назад +4

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

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

      Most welcome, keep learning👍

  • @subratasarkar9684
    @subratasarkar9684 5 лет назад +4

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

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

      Most welcome🙏🙏🙏

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

    So easy technic loved ur explanation keep it up

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

      Thanks a lot 😊

  • @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

  • @mahiuddin3963
    @mahiuddin3963 6 лет назад +4

    It's good to learn, thanks a lot

  • @saisaravanan234
    @saisaravanan234 5 лет назад +4

    I can understand, thank you.

  • @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💐💐

  • @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👍

  • @waseemakram2374
    @waseemakram2374 5 лет назад +4

    bro live long, & keep sharing

  • @ganeshdhakad7078
    @ganeshdhakad7078 5 лет назад +3

    Thanks you so much for making vedieo.

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

      Most welcome, keep learning🙏🙏🙏

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

    Thankuh sir such a good information 😀

  • @akkarthik2622
    @akkarthik2622 8 месяцев назад +1

    Very good sir it useful to freshers like me ❤

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

      Glad to hear that

  • @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

  • @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

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

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

    Your vide is really very helpful.Taught in a very quick and simple manner without wasting any time

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

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

  • @Anita-ew1ni
    @Anita-ew1ni 5 лет назад +3

    So useful 😃

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

      Thanks🙏🙏

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

    Bahut achha

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

    Sir kam samaye me aapne bahut achha samjhaya

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

    yeh video mere liye bohot hi useful hai.

  • @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

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

    Thanks sir, your teaching is very good...

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

      Always welcome

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

    It was nice learning from you sir

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

      Thank you so much🙏🙏

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

  • @swati1556
    @swati1556 6 лет назад +4

    Sir aap bahut achcha padate ho

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

      Thank you so much

  • @manishchouhan8266
    @manishchouhan8266 7 лет назад +1

    I like ur teaching methods..

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

      +Manish Chouhan , thank you so much keep learning

  • @Alliswell-we6xr
    @Alliswell-we6xr 4 года назад +1

    Superbbb explain sir..
    Thank you so much

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

      Always welcome

  • @sitakumari2926
    @sitakumari2926 7 лет назад +13

    l like this video

  • @minukumari863
    @minukumari863 6 лет назад +4

    waw thanks

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

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

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

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

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

      Happy to help

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

    Please provide above Excel sheet

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

    how to calculate double increment alongwith grade pay in ms excel

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

    Jbrdst video. Thank you sir 👍

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

    Very nice presentation .
    Very helpful to learn Advance Excel Payroll

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

      Many many thanks

  • @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

  • @Saifkhan-dz9ru
    @Saifkhan-dz9ru 7 лет назад +1

    What a termandous informative video about excel to make payrolls👌👌

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

      +Saif khan ,thank u so much

  • @danialmuzaffar7327
    @danialmuzaffar7327 Год назад +1

    So awesome ❤❤❤

  • @radhakrushnapanigrahy1703
    @radhakrushnapanigrahy1703 Год назад +1

    Very nice.
    I want much more excel formats

  • @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

  • @priyanka_79319
    @priyanka_79319 2 года назад +2

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

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

      Glad it was helpful!

  • @skkasemali9734
    @skkasemali9734 7 лет назад +1

    video is very use full my life

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

      +Sk Kasem Ali ,thanks

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

    It is very use full thank you so much sir

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

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

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

      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

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

    Bohot Accha laga thank you

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

    i like the way tutorials goes like....

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

      +manga othman ,Thank you so much

  • @DEEPAKKUMAR-os4dl
    @DEEPAKKUMAR-os4dl 3 года назад +1

    Apka video bahut achha lga sir

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

    Thanks sir for your wonderful explanation 👍👍👍👍👍👍

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

      Most welcome

  • @Nilesh...025
    @Nilesh...025 Год назад +2

    Sir thank u for this fluent explaination ❤️

  • @mohammadmeraj7219
    @mohammadmeraj7219 7 лет назад +1

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

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

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

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

      Most welcome💐

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

    Thank you carrer planet

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

      Most welcome, keep learning

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

    Thank you so much sir for this video.

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

    Bohot a66a sikhaya apne, thnk u 4 this vdo.

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

      Most welcome👍

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

    It made my work easy.... Thanks 👍