Employee Payslip in Ms-Excel

Employee Pay Slip ఎలా చెయ్యాలి Excel  లో 

Employees Payslip Table

steps :
1. create a new workbook in Excel
2. Create a new Table as per shown above
3. Basic Salary I entered Rs.12000 in C3.
4. Enter keep formulas at appropriate places. 
Formulas Rules :
Basic salary        : user Defined
HRA                   : 20% on Basic+DA
DA                       : 10% on Basic
TA and OT          : User Defined
PF                       : 12% on Basic 
Esi                       : User defined 
Leaves , Bank loans , Adv Salary : user Defined
Net Salary : total Earnings - Total deductions
(note : these amount values are not constant you can change as per your requirement) 

EMI Calculation in Excel

'EMI' Calculation ఎలా చెయ్యాలి MSEXCEL లో 

EMI Calculation Table

 





















Steps :
1. Create a new Excel Sheet
2. Create a Table shown above.
3. Enter a Formula at B5   ie: (=pmt(b3/12,b4,b2)) , like above shown. 
(note: b3 means  means Rate of int per year, b4 means  Terms of months, b2 means loan amount)
4. Now Press Enter Button 
5. You Will See EMI Value

How to Create Simple Intrest in Excel

SIMPLE INTEREST ఎలా చెయ్యాలి ఎక్సెల్ లో. 

steps 
1. Create a Table above shown.
2. Type your Formula at b5 (ie: =(b2*b3*b4)/12 
(note: b2 means Loan Amount, b3 means rate of interest, b4 means Time)
 3. Now Press 'Enter' 
4. It Will Show the Total interest for 12 Months.

Excel Sheet Protection (Hindi Tutorial)

Excel Sheet Data Protection कैसे कर सख्ते ?

Steps 
१.  पहले नया एक्सेल शीट बनाइये 
२. रिव्यु मेनू पर जाईये 
३. यहाँ पर "protect sheet" पर क्लिक करो 
४. आपने पासवर्ड टाइप करो. 
५. क्लिक ok 
६.  पासवर्ड दूसरा बार दीजिये 
७. OK मारिये 

अभी आपने एक्सेल SHEET  LOCK होजाएंगे.

 

How to Create Excel Chart

how to create a Excel Chart 

Steps :

1. select the above table
2. go to "insert" Menu -> Click Charts 
3. Select "column chart" -> select a Chart Model

.
4. Right click on  blue color poll  -> click on "Data lables"
5. values will be show on poll.

How to Show Or Hide Excel Cell Gridlines

Excel Cells Gridlines ఎలా  Hide చెయ్యాలి. ?

Steps :

1. Create a new Excel File 
2. Go to "View" Menu 
3. Disable "GRIDLINES" (Remove the Tick Mark)
4. Now See. your sheet becomes White page.

how to Set EXCEL FILE PASSWORD

Excel File Password ఎలా సెట్ చెయ్యాలి. ?

 

STEPS :

1. Create a New Excel File 

2. Click office Menu -> Go to "Prepare" 

3. Click on "Encrypt Document" .

 

4. Type your Password in Text Box ( ***)
5. Click Ok 
6. Re-Enter Password in Text Box (***)
7. Click Ok.
8. Press Ctrl+S to save File.

Allow Users to Edit Cells in Excel

Steps:

1. Prepare your table like above

2. Select Range(c2:c9) from the table

3. go to Review menu-> click "Allow user to Edit Ranges"

4. Click to Ok

5. Go to Review menu -> Click "Protect Sheet"

6. Enter Password -> Ok

7. Re Enter password -> Ok

8. Now enter phone numbers in phone column. other cells will be locked and can not able to edit.