Тёмный

How to Generate Bulk Salary Slip in a Minute || MS Excel Malayalam 

Rows & Columns
Подписаться 64 тыс.
Просмотров 28 тыс.
50% 1

In this video, you will learn how to generate bulk payslip/salary slip in excel Malayalam || Make thousands Payslips just in a quick time- Yes , we can easily create/generate/make 10000+ payslips within short time, here in this video Skills to Succeed will show you the same. To perform this function we need to use other component of Microsoft; MS Word and moreover it will support in any version of Excel.
#SalarySlipGenerateinExcel #ExcelMalayalam #SkillsToSucceedByAlfan
Other Videos You Might Like:
• 10 Magical Time Saving Tips & Tricks To Make You Excel Expert : • 10 Magical Tricks in M...
• Learn Basic VLOOKUP Function in 5 Minutes : • Learn Basic VLOOKUP in...
• How to Use SUBTOTAL Function in MS Excel : • How to Use SUBTOTAL Fu...
• 5 Easy Method to Find & Remove Duplicate Data in Excel : • Find & Remove Duplicat...
• How to Create a Pivot Table in Excel : • Learn Pivot Table in 1...
• Excel IF Function | IF, SUMIF, COUNTIF, NESTED IF : • IF, SUMIF, COUNTIF, NE...
• 12 Functions in 12 Minutes || Excel Text Functions : • Data Cleaning Function...
• MIND-BLOWING Excel Trick | Auto Advanced Filter - • How do I use advanced ...
• Difference Between VLOOKUP vs HLOOKUP - • What is VLOOKUP vs HLO...
• How to Insert Blank Rows & Columns After Every Data in Excel : • How to Insert Blank Ro...
• 12 Coolest Shortcut Keys to Accelerate Your Work - • Top Excel Keyboard Sho...
• This Pivot Table Trick Will Blow Your Mind - • This Pivot Table Trick...
• How To Repeat Headings on Each Page - • How To Repeat Headings...
• How to build a SEARCH BOX in Excel without VBA - • How to build a SEARCH ...
• Stock Management System in Excel - • Stock Management in Ex...
Let’s connect on social:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan

Опубликовано:

 

15 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 222   
@nitheesh4704
@nitheesh4704 3 года назад
കാര്യങ്ങൾ വലിച്ചു നീട്ടാതെ വളരെ എളുപ്പത്തിൽ മനസ്സിലാക്കി തന്നു, thanx..
@rows_columns
@rows_columns 3 года назад
🙏😊
@SOAOLSRY
@SOAOLSRY 2 года назад
വളരെ ഉപകാരം ആയിട്ടുള്ള വീഡിയോ ആണ്. താങ്ക്സ്. ഈ 150 പേജും seperate ആയി അതായത് ഓരോരുത്തരുടെയും payslip ഒരു പേജ് ആയി ഒറ്റ അടിക്കു പ്രിൻ്റ് ചെയ്യാൻ പറ്റുമോ?
@rows_columns
@rows_columns 2 года назад
Yes, possible👍😊
@SOAOLSRY
@SOAOLSRY 2 года назад
@@rows_columns എങ്ങിനെ എന്ന് കൂടി പറയാമോ? 150 പേജും seprate ആയി എങ്ങിനെ ഒറ്റയടിക്ക് പ്രിൻ്റ് എടുക്കാം??
@rows_columns
@rows_columns 2 года назад
@@SOAOLSRY sure, will show it in select video👍
@arunksabu1446
@arunksabu1446 Месяц назад
Thank you, very useful
@raeeskp7094
@raeeskp7094 2 года назад
Very informative session. Could you please share the Data sheet for self learning/practice?
@rows_columns
@rows_columns 2 года назад
Excel Free Practical Worksheets ആവശ്യമുള്ളവർ താഴെയുള്ള ലിങ്കിൽ നിന്നും Download ചെയ്യാൻ സാധിക്കുന്നതാണ്😊 www.rowscolumns.com/free-excel-templates
@adminorange9520
@adminorange9520 2 года назад
@@rows_columns Thank you for your sincere support.. great😍
@jibudasan1598
@jibudasan1598 2 года назад
You are really a master in Excel ..
@rows_columns
@rows_columns 2 года назад
🙏😊Am still learner bro
@jinumathewjose2358
@jinumathewjose2358 4 года назад
Thank you sir ....... important and useful for office administration. Really HAPPY with your class
@rows_columns
@rows_columns 4 года назад
Thanks a ton Brother💙
@atmata465
@atmata465 4 года назад
Very useful, would you please send master files?. hpwsinfo@gmail.com
@rows_columns
@rows_columns 4 года назад
Sent Brother👍
@youtubeismyguide1281
@youtubeismyguide1281 4 года назад
Very informative and useful brother
@rows_columns
@rows_columns 4 года назад
Glad you liked it😍
@eldojoseph754
@eldojoseph754 3 года назад
Explained very simple, thanks
@sirajutheenmohamedkunhi1738
@sirajutheenmohamedkunhi1738 2 года назад
Boss, Thank you very much for a wonderful video.
@rows_columns
@rows_columns 2 года назад
Thank you boss😊
@mohammedhashim7994
@mohammedhashim7994 Год назад
Sir, Can you make a short class about Excel table and its important......Thanks
@dforyou-informativetipstra9012
@dforyou-informativetipstra9012 3 года назад
മികച്ച അവതരണം ... 👍🙏
@basilmuhammed9707
@basilmuhammed9707 4 года назад
Very useful video for make invoice in word👌👌👌 can we save the data in separate word file instead of single word file
@rows_columns
@rows_columns 4 года назад
Yes Bro we can 😎 Go to > 1) www.docsoso.com/word/word-split.aspx 2) Upload the Doc file 3) Opt 'single Page Word Document' 4) Click on 'Convert" & It will show you the result 😀
@basilmuhammed9707
@basilmuhammed9707 4 года назад
Thanks bro... Please try to create a Whatapp GRP if you don't mind.. that helps us to ask Doubts with screenshots.. and you can reply your convince and any other members who know the doubt can also reply #JustASuggestion
@rows_columns
@rows_columns 4 года назад
In sha allah..👍 Let me plan😊 Tnx for your suggestion🤝
@santhoshlal9230
@santhoshlal9230 4 года назад
Thanks. Nice your presentation is great. Is there any way to multiple search by using excel data base. some thing like Name, father name, place, etc. and want to show only the result raws in separate page
@rows_columns
@rows_columns 4 года назад
Yes we can😊 planning to upload separate playlist for HR payroll... under that I will include those topics👍Anyways thanks for watching and valuable feedback😊
@safariya4105
@safariya4105 4 года назад
Thank you, very useful method.
@rows_columns
@rows_columns 4 года назад
Glad it was helpful!😀
@amruthat8107
@amruthat8107 Год назад
It's very nice session,👏
@mohammedrefzalrefzal1592
@mohammedrefzalrefzal1592 2 года назад
Employee leave management data sheet any tips, need to know about how many leave has taken how many has left, total annual leave days for employee
@trickyguruji1240
@trickyguruji1240 Год назад
Bro njn work cheyiyunnadh oru dental labil aan...gst pay cheyiyanamayadhu kond owner lab registration cheydhittilla....so avidey work cheyiyunna enik salary slip illathadhu mulam credit card apply cheyiyan pattunnilla...so enik salary slip undakkan pattumo??? employee code okke??
@abdulgafoor6379
@abdulgafoor6379 4 года назад
Very useful. Good to know the tips
@rows_columns
@rows_columns 4 года назад
Tnx Brow☺️
@aishwaryank2301
@aishwaryank2301 Год назад
Sir payroll oru video cheyyo
@mohammedshameelv74
@mohammedshameelv74 2 года назад
Thank you
@rows_columns
@rows_columns 2 года назад
😊
@ThajucochinThaju
@ThajucochinThaju 2 года назад
Sir.very useful video.but i have problems.how add opining balance.
@rashidarafeek6067
@rashidarafeek6067 3 года назад
It is more suitable to make Customer Balance Confirmation (for Accounts Receivable) also....
@abhikottayil
@abhikottayil 16 дней назад
Sir how to save the excel payslips into PDF for a total of 500 employees? Also can I share the payslips via email to employees directly from excel as a pdf ?
@Nishad2010
@Nishad2010 2 года назад
Super videos bro.
@rows_columns
@rows_columns 2 года назад
Tnx a ton Bro👍😊
@krschaithram
@krschaithram 4 года назад
Very useful thanks 😊
@Sathishkumar-ni5co
@Sathishkumar-ni5co Год назад
excellent post..
@PTG8005
@PTG8005 2 года назад
Urgent.. Oru help venam.. Salary slip window'il month enna oru drop down list koode include cheyyan pattumo? Athil every month salary kaanan pattunna rerthiyil.. Like employee id and oru month select cheythal aa employeede oru particular month ulla salary kaanan pattunna reethiyil.
@HEAVENLYTRUMPETZ
@HEAVENLYTRUMPETZ 2 года назад
Veru informative
@rows_columns
@rows_columns 2 года назад
Thanks
@subairt522
@subairt522 4 года назад
Very informative 👍
@fasialbabump
@fasialbabump 3 года назад
Dear file location change ayal data results automatically change avumo or shall we keep both file in same location always,thanks for valuable info,,
@mohammadbasheer9185
@mohammadbasheer9185 4 года назад
Excel guru 😊
@vivekt41
@vivekt41 4 года назад
Superb...very informative 😊👍
@rows_columns
@rows_columns 4 года назад
☺️🙏
@ajithtomk9nottom570
@ajithtomk9nottom570 Год назад
Thank you 🙏🙏🙏😊
@silu1011
@silu1011 3 года назад
Bro very good information 👍
@sadqsha3630
@sadqsha3630 3 года назад
Informative ❤️❤️❤️
@safeworld1798
@safeworld1798 3 года назад
Salary certificat illa സ്വന്തമായി ഒരു wrong certificate ഉണ്ടാക്കാമോ, for ലോണിന് വേണ്ടി? അങ്ങനെ ഉണ്ടാക്കിയാൽ എന്തെങ്കിലും pblm ഇണ്ടോ
@MrLinsad
@MrLinsad 4 года назад
Very informative and simple. Big time saver!
@rows_columns
@rows_columns 4 года назад
😊
@josephmg8291
@josephmg8291 Год назад
Bro, njan kore try cheydhu, but insert merge enna optionnde avide datas varand F1, F2........ Etc ingane aan show aagunne.. Idhinoru solution ondo
@kettestpes
@kettestpes 3 года назад
super bro
@Vectorheel2910
@Vectorheel2910 11 месяцев назад
Could you send me this format send me , I could not prepare Salary Sheet as you created
@വിജ്ഞാനഗ്രാമം
Very useful, can you provide the template?
@വിജ്ഞാനഗ്രാമം
vinjanagramam@gmail.com
@rows_columns
@rows_columns 3 года назад
Hi Brother, Thanks for watching video and sorry for being delayed in response. You can download complete practical worksheets from the following link. Keep learning & Keep thriving 😊 drive.google.com/drive/folders/1lSfghLlLrmjmp18SfKKaQSSPPW5n6DrB?usp=sharing
@വിജ്ഞാനഗ്രാമം
@@rows_columns Thanks Bro...
@landtech3069
@landtech3069 2 года назад
Pls send salary slip model
@hasmtl2074
@hasmtl2074 4 года назад
നമ്മൾ എല്ലാവർക്കും hard copy ആണ് കൊടുക്കുന്നത് അത് കൊണ്ട് ഒരു A4 ഷീറ്റിൽ 4 എണ്ണം വീതം ചെയ്യാൻ പറ്റുമോ? അല്ലെങ്കിൽ പ്രിന്റ് ചെയ്യാൻ പറ്റുമോ?
@rows_columns
@rows_columns 4 года назад
100% ചെയ്യാൻ സാധിക്കും.. Printing Tips എന്ന Topic ഉടനെ തന്നെ Upload ചെയ്യുന്നതാണ്. അതിൽ വ്യക്‌തമായി Explain ചെയ്തു തരാം👍😊
@arunlal5791
@arunlal5791 3 года назад
സർ ഇത് A4 പേപ്പറിൽ കൂടുതൽ ആളുകളുടെ സ്ളിപ്പ് പ്രിന്റ് എടുക്കാൻ സാധിക്കുമോ
@rows_columns
@rows_columns 3 года назад
Yes!👍
@arunlal5791
@arunlal5791 3 года назад
@@rows_columns സർ എങ്ങനെ സാധിക്കും അതിന്റെ വീഡിയോ അയകുമോ
@rows_columns
@rows_columns 3 года назад
@@arunlal5791 sure bro.. Very soon😊
@asaruredz6776
@asaruredz6776 3 года назад
Njan oru agency staff aanu..TA,DA, Mattu allowence onnum illa..fixed aaya oru amount weekend il kittum..Eth salary slips aakkaan pattumo...oru bike loaninu aanu. Plz reply..?
@noushadali9924
@noushadali9924 7 месяцев назад
Are you provide excel training
@rows_columns
@rows_columns 7 месяцев назад
Yes, Kindly WhatsApp 8086 738 783
@shithinpb6328
@shithinpb6328 2 года назад
Bro insert merge field click cheyumbo heading varunnilaa F2, f3 ingane anu varunneee
@fazalrahman3757
@fazalrahman3757 3 года назад
But how to do it monthly. I mean how to include the month of salary and multiple months
@sreenathpr4289
@sreenathpr4289 4 года назад
Veedum super
@rows_columns
@rows_columns 4 года назад
Srinath :)
@anasxmhmd
@anasxmhmd 3 года назад
Sir, ithinte templates onnu send cheyyamo
@rows_columns
@rows_columns 3 года назад
Kindly check my community tab bro😊
@MrAbc523
@MrAbc523 4 года назад
Alfan is an expert in Excel ... keep up...
@rows_columns
@rows_columns 4 года назад
☺️
@vineeshavineeshamani9793
@vineeshavineeshamani9793 4 года назад
Gov.employees nte salary slip bulk ayittu kittan enganeyanu cheyyendath,lock down alle,department office long anu pokan vayyya..
@rows_columns
@rows_columns 4 года назад
ഈ Same method ഉപയോഗിക്കാമല്ലോ 😊
@vineeshavineeshamani9793
@vineeshavineeshamani9793 4 года назад
@@rows_columns enikkithonnum ariyille.....but salary slip venam.....6 month..
@rows_columns
@rows_columns 4 года назад
🤔
@gk-forumkerala1421
@gk-forumkerala1421 4 года назад
താങ്ക്സ്
@remo89sr
@remo89sr 4 года назад
Salary voucher engane eluppathil cheyyam? Vlookup upayogichu excelil njan oru A4 sheetil 4 employees nte pay details kittunna reethikku. Just employees ne kondu sign cheyyippichu sookshikkan vendi.
@rows_columns
@rows_columns 4 года назад
Give me your whatsapp no pls.. :)
@remo89sr
@remo89sr 4 года назад
@@rows_columns 8943121206
@sojijacob3836
@sojijacob3836 3 года назад
Sir can you contact this number. I need your help. ±968 97840074 wats up👆
@ambikamukundan7044
@ambikamukundan7044 2 года назад
Is there any facility to bulk mail the pay-slips to the individual employee in one mail?
@rows_columns
@rows_columns 2 года назад
Yes, but need to programmed (VBA)
@ambikamukundan7044
@ambikamukundan7044 2 года назад
@@rows_columns oh ok. Thank you
@ambikamukundan7044
@ambikamukundan7044 2 года назад
@@rows_columns When we copy only the subtotals from the subtotal formula to another sheet, is there any simple formula to remove the text “Total” from each cells easily?
@firocvdy
@firocvdy 4 года назад
Please share this format
@atmata465
@atmata465 4 года назад
ഇതിന്റെ template ഒന്ന് തരുമോ
@rows_columns
@rows_columns 4 года назад
Already sent complete worksheet.. Kindly check your email and confirm :)
@sreeragaraj2580
@sreeragaraj2580 3 года назад
How to generate last six month salary slip automatically?
@vineeshavineeshamani9793
@vineeshavineeshamani9793 4 года назад
Employ data base okke engane kanum systethil
@rows_columns
@rows_columns 4 года назад
Employee details u should insert first...
@Ansalmanzoor
@Ansalmanzoor 2 года назад
ഹി ബ്രോ
@rows_columns
@rows_columns 2 года назад
😊
@gafoorchinappa2654
@gafoorchinappa2654 2 года назад
How I can add more than item in one slip
@rows_columns
@rows_columns 2 года назад
Will show it in separate vid.
@suhailmsharief
@suhailmsharief 4 года назад
Output kittiyappol figures il decimals varunnu, but njan listil attach cheytha excel ile figures decimals ellam mattiyirunnu.. kindly help
@rows_columns
@rows_columns 4 года назад
Can u send me ur file to skills2succeed.alfan@gmail.com
@albertfrancis420
@albertfrancis420 2 года назад
Same problem here .engenya ready ayathu?
@suhailmsharief
@suhailmsharief 2 года назад
@@albertfrancis420 either send to the above mentioned mail id from the channel admin or do it again from the beginning ( create a new excel file and copy the data from your old excel then paste special into the new excel with values only format ) or (change the figures's number formats to text format) try with these 2 ways you'll get the numbers without decimals.
@syedismail9727
@syedismail9727 3 года назад
hello sir, Could you send me to excel master data for practising?
@syedismail9727
@syedismail9727 3 года назад
ismailkollam1@gmail.com
@rows_columns
@rows_columns 3 года назад
Hi Brother, Thanks for watching video and sorry for being delayed in response. You can download complete practical worksheets from the following link. Keep learning & Keep thriving 😊 drive.google.com/drive/folders/1lSfghLlLrmjmp18SfKKaQSSPPW5n6DrB?usp=sharing
@sharemalayali5212
@sharemalayali5212 3 года назад
If send to every employee mail id. Your efforts is super
@firocvdy
@firocvdy 4 года назад
ഇതിന്റെ templaetes ഒന്ന് send ചെയ്യാമോ
@rows_columns
@rows_columns 4 года назад
Sure👍
@arif786am
@arif786am 3 года назад
@@rows_columns Pls send the template s-arifkadavallur@gmail.com
@sreeragaraj2580
@sreeragaraj2580 4 года назад
Whne I copy the payslip to word, that time it's shows a pop up notification like " To do this al the merged cells need to be the same"? What will do
@rows_columns
@rows_columns 4 года назад
May formatting issue... Can u recheck the step one again and try....
@sreeragaraj2580
@sreeragaraj2580 4 года назад
@@rows_columns problem sorted
@libinbigland1013
@libinbigland1013 4 года назад
templaetes ഒന്ന് send ചെയ്യാമോ
@rows_columns
@rows_columns 4 года назад
Sure.. ur mail id pls :)
@libinbigland1013
@libinbigland1013 4 года назад
@@rows_columns lvaliyaparambil@gmail.com
@rows_columns
@rows_columns 4 года назад
Kindly check your inbox (If not found request you to check in Junk/Spam folder too)😊
@sojijacob3836
@sojijacob3836 3 года назад
template onnu send cheyamo. soji. mlpy@gmail.com
@nihalamunaver6224
@nihalamunaver6224 3 года назад
Bro💫💫🙏
@rows_columns
@rows_columns 3 года назад
😊
@mohammedsaheed1163
@mohammedsaheed1163 2 года назад
Wow
@sreejithsethu3109
@sreejithsethu3109 2 года назад
👍👍👍
@santhoshlal9230
@santhoshlal9230 4 года назад
how to include photo in this
@rows_columns
@rows_columns 4 года назад
Where you want to include the photo? In payslip?
@santhoshlal9230
@santhoshlal9230 4 года назад
@@rows_columns yes
@rows_columns
@rows_columns 4 года назад
Planning to upload separate playlist for 'HR Payroll'.. On that I will cover up the same👍 Anyway thanks for ur suggestion :)
@arif786am
@arif786am 3 года назад
Please send the copy of this ?
@rows_columns
@rows_columns 3 года назад
Thanks for watching it Brother 😊 You can download complete worksheets from the google drive link which I recently provided in my community tab. Happy Learning 😊
@babukoshy9262
@babukoshy9262 3 года назад
hi sir, please send me the template.
@rows_columns
@rows_columns 3 года назад
📌To Learn Microsoft Excel in English, Click on the Below Link: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Cn3-bLDkGMY.html
@rajguhanand6758
@rajguhanand6758 3 года назад
How to set quarter type slips"….
@rows_columns
@rows_columns 3 года назад
Sorry. Didn't get
@rajguhanand6758
@rajguhanand6758 3 года назад
How can I set the billing page on half of an A4 page (Orginal for customer & Duplicate for office copy in one A4 paper).
@rajguhanand6758
@rajguhanand6758 3 года назад
Please make a video for VBA Coding.
@rajguhanand6758
@rajguhanand6758 3 года назад
Thanks for your kind reply.
@rows_columns
@rows_columns 3 года назад
Sure 👍👍 Will upload it near future😊
@santhoshbpillai6679
@santhoshbpillai6679 3 года назад
👍
@jijojohn3180
@jijojohn3180 4 года назад
Need templates
@rows_columns
@rows_columns 4 года назад
Sure... ur mail id pls.. :)
@Anime_magic1
@Anime_magic1 4 года назад
Watsup number teramo
@tobinjacob729
@tobinjacob729 2 года назад
how percentage to be merged to slip correctly. after merge 66% out put is 0.65991928768176289 Please replay
@mohamedsiddiq9419
@mohamedsiddiq9419 3 года назад
Useful information
@fayazyousef3528
@fayazyousef3528 3 года назад
Thank you ❤️
@rows_columns
@rows_columns 2 года назад
Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates
@RMHSALOOR-
@RMHSALOOR- 3 года назад
Super.🌹👍
@askary007
@askary007 4 года назад
👍👍
@jijeeshpadmanabhan350
@jijeeshpadmanabhan350 3 года назад
Very useful. Thanks
@rows_columns
@rows_columns 2 года назад
Thanks for your feedback and I'm glad it helped 😊 You can download file used in the video : www.rowscolumns.com/free-excel-templates
Далее
Excel Template to print Payslips - Malayalam Tutorial
34:37
How to Use SUBTOTAL Function | MS Excel Malayalam
9:40
Excel 2019 Basic to Advanced in Malayalam : Part 1
25:15