Salary Slip Limited Company For Microsoft excel Advance Formula
Salary Slip Limited Company For Microsoft excel Advance Formula
Learn:- Salary Slip Limited Company For Microsoft excel Advance Formula
With the help of this video, you will learn how to make salary slip of limited company. It is very easy to make salary slip in this video. It has been told about applying formula and applying automatic formula. If you like the video, do like it, thank you
Friends on this channel you are given absolutely original information about Microsoft Word Microsoft Excel Power Point Video Mixing Computer Hardware Laptop Hardware Online Information.
Friends, before uploading videos on this channel, it is kept in mind that this video should benefit you and you can learn a lot from one video.
Where does the friend go, no one has any work
My instagram Link : https://www.instagram.com/ctechindia/
My Instagram Personal Link : https://www.instagram.com/chandan.ctech/
Facebook Page Link: https://www.facebook.com/ctechindia/
My Other Hindi Channels:
Real Tutorial : ✅
/ @designapna
My Website: https://www.designapna.com/
#excel #salaryslip #ctech
Content
0.185 -> Welcome to C tech channel
3.315 -> Today I have brought you a video of Microsoft Excel
6.175 -> In this, I will tell you how to design monthly salary slip.
9.22 -> Learn to design salary slip
12.24 -> Then it will be easy for you to get a job.
17.7 ->
18.32 -> It is told in a very easy way.
21.3 -> That too full automatic
23.98 -> You can see how easily the data is coming automatically.
26.96 -> So let me tell you how to make
29.56 -> Like video then like
32.48 ->
35.12 -> Continue to video
37.8 -> Excel is open and click the view.
40.7 -> We will do our page from normal to page layout.
43.685 -> So that the page comes in A4 size.
46.72 -> First we will set up rows
51.82 -> Before that we set the margin.
55.34 ->
56.06 ->
57.755 ->
60.48 ->
63.18 -> They reduce it according to the need.
65.72 -> And do more than this
74.68 -> We will set this in 4 parts.
77.42 -> one to three four , Will skip the first column
80.48 -> Because we have to draw borders all around.
82.42 -> Select it and merge it all.
84.86 ->
87.6 -> Let's type the company name for the exam.
90.94 ->
94.02 ->
97 -> Have typed the name of the company.
100.04 -> And will increase its size, You can enlarge according to your need. and bold
106.28 -> Now we will also merge this line.
110.72 -> In this, let's type the address of the company.
119.72 -> You can also give the font size according to it.
122.64 ->
125.62 -> Also merge it
128.48 -> And I type in the monthly salary slip.
135.12 ->
137.92 -> and bold , and font size 14
141.24 -> And underline it.
144.36 -> Select it and go to the border option.
147.24 ->
149.2 ->
152.24 -> and select bottom border
155.2 -> Under it came the under line.
157.32 ->
159.265 ->
161.975 ->
163.64 ->
166 -> So friend, we have designed the company's headings
169.24 -> Employee details will be typed here
172.46 -> Employee ID will be typed first and type employee name
176.24 -> Type designation
180.32 -> Will type month and year here
183.48 -> Give it an all border
189.68 -> Fonts size is 14
191.58 -> Fonts size is 14
194.56 -> Fonts size is 14
197.72 -> Fonts size is 14
200.82 -> Select both and make it bold.
203.14 -> Select both and make it bold.
205.26 ->
207.22 -> All cells are selected and bold.
210.24 ->
212.86 -> Leave a rowa blank here
217.5 -> And start typing from this place.
221.18 -> Here we will type earnings source
225.22 -> Font size 14 and bold
229.68 -> Will type detection here
236.12 ->
238.56 -> Basic salary will be typed here
244.24 ->
247.16 -> Bold to normal
250.52 -> Keep the font size to 14
253.38 -> Type overtime
254.62 -> will put the work done overtime from basic time to overtime
263.68 -> We will type the convention here
274.24 -> We will type the extra income that we will get from the company.
280.1 -> Here we will type the total edition
283.36 -> All of them are earning sources
290.46 -> In this side all the detachments will be there.
294.92 -> Basic salary cuts many things like pf fund etc.
300.6 -> They will type all the details in this line.
303.52 -> Let's type PF funds here.
306.38 -> Type ESI which is for medical treatment.
314.4 -> Here, type the loan, which may have been taken from the company in advance.
321.38 -> We will type the tax here
327 -> And here we will type total detection.
332.22 -> And here, let's type Net Salary.
336.52 -> We unbold all of them.
339.52 -> We unbold all of them.
343.16 ->
344.775 ->
346.885 ->
349.925 ->
352.48 -> And all of me put a border.
355.48 -> Fill it with light color
361.44 ->
366.02 -> Most offices have black and white printers, so we will feel black light color
374.96 ->
378.12 ->
380.44 -> Now a little more design has to be done.
383.38 -> After that the details will be added with the formula.
386.46 -> Let's type signature here?
389.3 ->
392.325 ->
395.245 ->
396.64 ->
398.66 -> Let's add signature here?
401.54 ->
404.9 -> Manager type here
409.18 ->
412.215 ->
415.295 ->
417.665 ->
420.665 ->
423.145 ->
426.3 ->
429.32 -> Select all and fill withe Colour
434.44 ->
436.3 -> And put an all border on it?
439.4 ->
442.725 ->
448.08 ->
451.1 -> The salary slip design is complete.
457.02 ->
459.775 ->
462.82 ->
465.88 -> Here we apply the formula of total
470.56 -> With the formula of Total, all our income will be plus.
474.4 ->
477.625 ->
480.875 ->
483.895 ->
486.78 ->
489.9 -> In this side all the detection will be plus.
493.14 ->
495.295 ->
498.215 ->
501.355 ->
504.58 ->
507.58 -> For net salary, we have to reduce the total Deduction from total income.
512.88 ->
519.5 -> Will apply formula for this
521.42 ->
523.32 -> Select total Addition cell
526.42 ->
530.425 ->
533.58 ->
536.34 -> Our net salary will come here in cell
539.18 -> You have two ways
542.26 -> Type manually the Employee ID, etc.
545.3 -> Type the name
548.34 ->
552.425 ->
555.105 ->
558.12 ->
560.76 -> You can manually type whatever data you have to type.
565.08 ->
566.52 ->
569.175 ->
571.975 ->
575.015 ->
578.005 ->
580.505 ->
583.605 ->
585.5 -> Total Salary: ₹ 15250
588.8 -> But we want to just type the Employee ID here and the data will come automatically.
597.4 -> We do not have to type the data to be automatically typed.
602.08 -> First told you to make manually
606.58 -> If you want
609.2 -> You can select only Employee ID automatically.
613.38 -> Let me tell you how it is done.
616.1 -> The last typed data is deleted.
620.5 -> Friends, you can see that I have typed some data on the first seat.
625.52 -> Employee ID Employee Name
629.6 -> Designation
631.06 -> Month and year Basic
634.085 -> Overtime amount , conveyance
637.36 -> Provident Fund , Esi
641.5 -> Loan
642.98 -> Tax and net salary
646 -> In this way we have all the data
647.92 -> You must have the data now or you have to type
651.76 -> With this, you can check the details of all at once and also print a separate salary slip.
656.66 -> Let me tell you how to make it automatic?
660.68 -> First, select the Employee ID cell and go to the data.
664.18 -> Data validation
667.06 -> Here we have to make a list.
669.76 -> In this, we will select the list instead of any value.
674.32 -> And clicking on the Source
675.66 -> Click on first seat
678.04 -> And we will select all Employee IDs.
681.26 -> And will you see here here?
684.74 -> Everyone's id number will show
689.1 -> You do not necessarily select from the list.
691.4 -> You can type the id number here in a normal way.
694.38 ->
696.98 ->
700.12 -> Now we have to bring Employee Name.
702.86 -> We also have to apply Vlookup formula to get the Employee name.
706.7 -> We will apply the formula once and copy paste it into everything else.
709.7 -> So let's click here and equal.
713.62 -> VLOOKUP
716.62 ->
717.84 -> Here is the hookup
720.66 -> Who will come through
723.48 -> If we change, will our detail change?
726.84 -> We will fetch all the data through Employee ID.
730.14 -> ,
733.84 -> After that we have to set the table array
736.16 -> For Table array, we have to do the entire tablet from where the data will come.
739.6 -> and select all data
741.86 ->
744.825 ->
747.82 ->
750.88 -> ,
752.52 -> Now we have to type the column index number.
755.2 -> Which column you want to pick up data from
758.28 -> Name will be on our second column
761.2 -> If we select from here, our second column will be here.
764.14 -> This means that you count from where you select
767.12 -> Do not count columns above
770.2 ->
773.28 -> We will type 2 here.
778.52 -> For the match, we will use zero
782.02 ->
785.2 -> So see, Shyam Singh has come here.
788.24 -> So let's see Shyam Singh is absolutely right here.
791.24 ->
794.98 ->
796.78 -> We will copy this formula.
799.84 ->
801.34 -> Esc And pest in cell
803.74 ->
806.7 -> The name is coming because here.
808.6 -> Because the column here is index number 2, we have to change it.
811.56 -> We make it 3.
813.08 -> As we type 3, see the correct data, the grinder operator.
816.28 -> To bring the month and year data, we only have to do 4 here.
819.26 -> Because
820.78 -> Copy paste
823.04 -> Changing the column index number will be enough.
826.08 -> You can check the data from here, we used 1 for this, the rest can be seen from you.
828.9 ->
831.82 ->
834.78 -> Paste the same formula here.
837.74 -> And this will make it 5 instead of 2.
842.68 -> What is overtime after that?
845.42 -> Overtime will come at number 6
849.44 -> Ctrl + V and type 6
855.5 ->
857.14 -> conveyance in Number seven
861.02 -> Paste the formula to make the column index number 7.
863.9 -> You can apply a tax formula I am doing to make copy paste easier.
868.82 ->
869.92 ->
872.725 ->
875.585 ->
878.625 ->
881.42 -> Totaling formula, we have already applied automatic, then total will come
884.26 -> So here PF check how much is the number?
886.5 ->
889.7 -> 9 Number
892.34 -> Pest Formula And Change Column index number
895.38 ->
897.16 -> Whom to number 9
899.26 -> ESI may be number 10.
902.74 -> You will also check once.
906.56 -> We also check once.
909.58 -> ok
910.82 -> If the loan column is at index number 11, number 11 will come in the formula.
913.84 ->
915.36 -> Let's paste the formula and type 11 numbers.
919.36 -> If all the formulas are the same then copy paste is done quickly.
922.4 -> Tax on number 12
925.12 -> Let the net salary come from automatic + formula
930.24 -> Total salary arrived and additional salary together
933.16 -> What is Total Addition 17500?
936.24 -> Will detect detection from Total Addition.
941.62 -> Total became net salary
945.72 -> Now we will just change the ID number from here.
949.06 -> And see, the net salary has arrived.
950.88 -> Now change the ID number and see that all the data will come correctly.
954.34 ->
957.32 -> Along with this, the name is also changing.
960.36 -> If you want to bring the month air to full, select it.
963.54 -> Going to home tab
966.72 -> And you can set long date and short date in the list according to yourself.
969.72 ->
974.095 ->
977.065 ->
979.775 ->
983.34 ->
987.94 -> Now friends talk about setting print area
990.98 ->
994.2 ->
997.12 -> Click on the Page Layout tab.
1000.1 -> Select all of the design area.
1003.2 -> After selecting, click Print Area Tools.
1006.24 -> And click on the Seth print area.
1009.14 -> Now we do control + P from here.
1012.18 -> So you can see a beautiful print preview.
1017.3 -> That way you can print
1021.9 ->
1025.08 ->
1028.16 -> So tried to tell you very easily in friends
1031.06 ->
1034.04 -> Which you can easily understand.
1037.02 -> I have used the advance formula and also the basic formula.
1040.86 ->
1042.18 ->
1045.08 -> You can download this seat from the video description
1048.18 -> Tell me how you liked this video
1052.32 -> If you like it, please LIKE the video.
1056.52 ->
1059.855 ->
Source: https://www.youtube.com/watch?v=iYyPF4-cdBw