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

  Рет қаралды 27,132

Rows & Columns

Rows & Columns

Күн бұрын

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

Пікірлер: 220
@eldojoseph754
@eldojoseph754 2 жыл бұрын
Explained very simple, thanks
@dforyou-informativetipstra9012
@dforyou-informativetipstra9012 3 жыл бұрын
മികച്ച അവതരണം ... 👍🙏
@krschaithram
@krschaithram 4 жыл бұрын
Very useful thanks 😊
@subairt522
@subairt522 4 жыл бұрын
Very informative 👍
@sadqsha3630
@sadqsha3630 3 жыл бұрын
Informative ❤️❤️❤️
@amruthat8107
@amruthat8107 Жыл бұрын
It's very nice session,👏
@safariya4105
@safariya4105 4 жыл бұрын
Thank you, very useful method.
@rows_columns
@rows_columns 4 жыл бұрын
Glad it was helpful!😀
@silu1011
@silu1011 3 жыл бұрын
Bro very good information 👍
@mohamedsiddiq9419
@mohamedsiddiq9419 3 жыл бұрын
Useful information
@sirajutheenmohamedkunhi1738
@sirajutheenmohamedkunhi1738 2 жыл бұрын
Boss, Thank you very much for a wonderful video.
@rows_columns
@rows_columns 2 жыл бұрын
Thank you boss😊
@abdulgafoor6379
@abdulgafoor6379 4 жыл бұрын
Very useful. Good to know the tips
@rows_columns
@rows_columns 4 жыл бұрын
Tnx Brow☺️
@ajithtomk9nottom570
@ajithtomk9nottom570 10 ай бұрын
Thank you 🙏🙏🙏😊
@Sathishkumar-ni5co
@Sathishkumar-ni5co Жыл бұрын
excellent post..
@rashidarafeek6067
@rashidarafeek6067 3 жыл бұрын
It is more suitable to make Customer Balance Confirmation (for Accounts Receivable) also....
@vivekt41
@vivekt41 4 жыл бұрын
Superb...very informative 😊👍
@rows_columns
@rows_columns 4 жыл бұрын
☺️🙏
@youtubeismyguide1281
@youtubeismyguide1281 4 жыл бұрын
Very informative and useful brother
@rows_columns
@rows_columns 4 жыл бұрын
Glad you liked it😍
@RMHSALOOR-
@RMHSALOOR- 3 жыл бұрын
Super.🌹👍
@nitheesh4704
@nitheesh4704 2 жыл бұрын
കാര്യങ്ങൾ വലിച്ചു നീട്ടാതെ വളരെ എളുപ്പത്തിൽ മനസ്സിലാക്കി തന്നു, thanx..
@rows_columns
@rows_columns 2 жыл бұрын
🙏😊
@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
@jibudasan1598
@jibudasan1598 2 жыл бұрын
You are really a master in Excel ..
@rows_columns
@rows_columns 2 жыл бұрын
🙏😊Am still learner bro
@gk-forumkerala1421
@gk-forumkerala1421 4 жыл бұрын
താങ്ക്സ്
@mohammedshameelv74
@mohammedshameelv74 2 жыл бұрын
Thank you
@rows_columns
@rows_columns 2 жыл бұрын
😊
@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
@kettestpes
@kettestpes 3 жыл бұрын
super 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👍
@mohammadbasheer9185
@mohammadbasheer9185 3 жыл бұрын
Excel guru 😊
@HEAVENLYTRUMPETZ
@HEAVENLYTRUMPETZ 2 жыл бұрын
Veru informative
@rows_columns
@rows_columns 2 жыл бұрын
Thanks
@PTG8005
@PTG8005 Жыл бұрын
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.
@MrLinsad
@MrLinsad 4 жыл бұрын
Very informative and simple. Big time saver!
@rows_columns
@rows_columns 4 жыл бұрын
😊
@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,,
@ThajucochinThaju
@ThajucochinThaju Жыл бұрын
Sir.very useful video.but i have problems.how add opining balance.
@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
@Nishad2010
@Nishad2010 2 жыл бұрын
Super videos bro.
@rows_columns
@rows_columns 2 жыл бұрын
Tnx a ton Bro👍😊
@shithinpb6328
@shithinpb6328 2 жыл бұрын
Bro insert merge field click cheyumbo heading varunnilaa F2, f3 ingane anu varunneee
@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??
@sreenathpr4289
@sreenathpr4289 4 жыл бұрын
Veedum super
@rows_columns
@rows_columns 4 жыл бұрын
Srinath :)
@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
@mohammedhashim7994
@mohammedhashim7994 Жыл бұрын
Sir, Can you make a short class about Excel table and its important......Thanks
@asaruredz6776
@asaruredz6776 2 жыл бұрын
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..?
@askary007
@askary007 4 жыл бұрын
👍👍
@fazalrahman3757
@fazalrahman3757 3 жыл бұрын
But how to do it monthly. I mean how to include the month of salary and multiple months
@safeworld1798
@safeworld1798 3 жыл бұрын
Salary certificat illa സ്വന്തമായി ഒരു wrong certificate ഉണ്ടാക്കാമോ, for ലോണിന് വേണ്ടി? അങ്ങനെ ഉണ്ടാക്കിയാൽ എന്തെങ്കിലും pblm ഇണ്ടോ
@Vectorheel2910
@Vectorheel2910 9 ай бұрын
Could you send me this format send me , I could not prepare Salary Sheet as you created
@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😊
@aishwaryank2301
@aishwaryank2301 10 ай бұрын
Sir payroll oru video cheyyo
@landtech3069
@landtech3069 2 жыл бұрын
Pls send salary slip model
@mohammedsaheed1163
@mohammedsaheed1163 Жыл бұрын
Wow
@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😍
@sreejithsethu3109
@sreejithsethu3109 Жыл бұрын
👍👍👍
@sreeragaraj2580
@sreeragaraj2580 2 жыл бұрын
How to generate last six month salary slip automatically?
@nihalamunaver6224
@nihalamunaver6224 3 жыл бұрын
Bro💫💫🙏
@rows_columns
@rows_columns 3 жыл бұрын
😊
@santhoshbpillai6679
@santhoshbpillai6679 3 жыл бұрын
👍
@babukoshy9262
@babukoshy9262 3 жыл бұрын
hi sir, please send me the template.
@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🤝
@MrAbc523
@MrAbc523 4 жыл бұрын
Alfan is an expert in Excel ... keep up...
@rows_columns
@rows_columns 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👆
@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👍
@vineeshavineeshamani9793
@vineeshavineeshamani9793 4 жыл бұрын
Employ data base okke engane kanum systethil
@rows_columns
@rows_columns 4 жыл бұрын
Employee details u should insert first...
@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
@noushadali9924
@noushadali9924 5 ай бұрын
Are you provide excel training
@rows_columns
@rows_columns 5 ай бұрын
Yes, Kindly WhatsApp 8086 738 783
@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.
@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?
@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 жыл бұрын
🤔
@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
@user-xy6xp5xv8j
@user-xy6xp5xv8j 3 жыл бұрын
Very useful, can you provide the template?
@user-xy6xp5xv8j
@user-xy6xp5xv8j 3 жыл бұрын
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
@user-xy6xp5xv8j
@user-xy6xp5xv8j 3 жыл бұрын
@@rows_columns Thanks Bro...
@sharemalayali5212
@sharemalayali5212 3 жыл бұрын
If send to every employee mail id. Your efforts is super
@anasxmhmd
@anasxmhmd 2 жыл бұрын
Sir, ithinte templates onnu send cheyyamo
@rows_columns
@rows_columns 2 жыл бұрын
Kindly check my community tab bro😊
@rows_columns
@rows_columns 2 жыл бұрын
📌To Learn Microsoft Excel in English, Click on the Below Link: kzbin.info/www/bejne/eZ-WXpWCedB6g7s
@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 :)
@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😊
@Ansalmanzoor
@Ansalmanzoor 2 жыл бұрын
ഹി ബ്രോ
@rows_columns
@rows_columns 2 жыл бұрын
😊
@firocvdy
@firocvdy 4 жыл бұрын
ഇതിന്റെ templaetes ഒന്ന് send ചെയ്യാമോ
@rows_columns
@rows_columns 4 жыл бұрын
Sure👍
@arif786am
@arif786am 3 жыл бұрын
@@rows_columns Pls send the template s-arifkadavallur@gmail.com
@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 😊
@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 :)
@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
@jijojohn3180
@jijojohn3180 4 жыл бұрын
Need templates
@rows_columns
@rows_columns 4 жыл бұрын
Sure... ur mail id pls.. :)
@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😊
@Anime_magic1
@Anime_magic1 3 жыл бұрын
Watsup number teramo
@tobinjacob729
@tobinjacob729 2 жыл бұрын
how percentage to be merged to slip correctly. after merge 66% out put is 0.65991928768176289 Please replay
Stay on your way 🛤️✨
00:34
A4
Рет қаралды 15 МЛН
Inside Out 2: Who is the strongest? Joy vs Envy vs Anger #shorts #animation
00:22
ВОДА В СОЛО
00:20
⚡️КАН АНДРЕЙ⚡️
Рет қаралды 29 МЛН
A clash of kindness and indifference #shorts
00:17
Fabiosa Best Lifehacks
Рет қаралды 129 МЛН
Automatic Report Card in Excel | Student Result Card in Excel
27:05
PowerEx by Jitendra
Рет қаралды 719 М.
How to prepare a payroll in Excel
32:45
Omoabugan Emmanuel
Рет қаралды 21 М.
How to use Mail Merge in Microsoft Word - Malayalam Tutorial
16:37
XL n CAD Malayalam
Рет қаралды 72 М.
Salary Pay Slip | How To Make Salary Pay Slip In Excel | Payroll in Excel |
16:22
Master Guide 'മാസ്റ്റർ ഗൈഡ് '
Рет қаралды 20 М.
Top Excel Keyboard Shortcut Keys  ||  എക്സൽ മലയാളം
17:30
Stay on your way 🛤️✨
00:34
A4
Рет қаралды 15 МЛН