Welcome Pages

Welcome to HR Training Payroll

Here you learn, HR Training, Payroll Management, and MS Office Hindi and English. 

Example:- 

Salary CTC Structure.
Salary Register
PF Challan
ESIC Challan
Labour Law
Attendance Management
Leave Management
Notepad
Wordpad
Paint
MS- Excel
MS- Word
MS- Power Point
MS- Outlook
PT-Slab
LWF- Slab

Comments

Post a Comment

Popular posts from this blog

How to Split Forename and Surname (LEFT, RIGHT, MIDDLE) formula in EXCEL

Image
 How to Split Forename and Surname (LEFT, RIGHT, MIDDLE) formula in EXCEL The following formula are useful when you have one cell containing text which needs to be split up. The formula use various text functions to accomplish the task. Each of the techniques uses the space between the names to identify where to split. Finding the Last name when a Middle name is present The formula above cannot handle any more than two names.If there is also a middle name, the last name formula will be incorrect.To solve the problem you have to use a much longer calculation.
Read more

How to Calculate TIME in EXCEL

Image
 How to Calculate TIME in EXCEL Excel can work with time very easily. Time can be entered in various different formats and calculations performed. See the Time sheet Example below:-  Typing Time When time is entered into worksheet it should be entered with a colon between the hour and the minutes, such as 12:30 , rather than 12.30 Excel can cope with either the 24 hours system or the am/pm system.To use the am/pm system you must enter the am or pm after the time. You must leave a space between the number and the text. Finding the difference between two times You can subtract two time values to find the length of time between. Note:- If the result is not shown correctly,You may need to reformat the answer.Look at the section about formatting further in this worksheet. How To Apply Custom Formatting 1. Click on the cell which needs the format.or Shortcut Key:-  CTRL+ 1 2. Choose the Format menu. 3. Choose Cells. 4. Click the Number tag at the top right. 5. Choose...
Read more

How to Calculation Age and Birth Day in Excel

Image
  How to Calculation Age and Birth Day in Excel You can calculate  a person age based on their birthday and todays date. The calculation uses the DATEDIF() function   =DATEDIF(C3,TODAY(),"y")  =DATEDIF(C3,TODAY(),"ym")   =DATEDIF(C3,TODAY(),"md") You can put this all together in one calculation, which creates a text version.  ="Age is "&DATEDIF(C3,TODAY(),"y")&" Years, "&DATEDIF(C3,TODAY(),"ym")&" Months and "&DATEDIF(C3,TODAY(),"md")&" Days"
Read more