Skip to main content

Employee Pay sheet Formulas in Microsoft Excel

Today, we will discuss How to create an Employee Worksheet by using Employee Pay sheet formulas in Microsoft Excel. The following formulas will be used in Employee Pay sheet: Q: Prepare a worksheet according to the following instructions:
  1. Create a worksheet in MS Excel according to the requirements
  2. Enter sample data of employees in a college
  3. Apply formula to calculate Medical Allowance @ 40 % of Basic Pay
  4. Apply formula to calculate Conveyance Allowance @ 30 % of Basic Pay
  5. Apply formula to calculate House Rent @ 50 % of Basic Pay
  6. Add a column of Income Tax @ 7 % of Basic Pay
  7. Apply formula to calculate Net Pay = Medical Allowance + Conveyance Allowance + House Rent - Income Tax

Image for Employee Pay sheet Formulas in Microsoft Excel Software

Employee pay sheet Formulas in MS Excel

 Solution:How to Create Employee Pay Sheet in Excel With Formulas

  1. Create a new workbook in MS Excel and save as with the name Employee Pay sheet Formulas.
  2. Enter sample data for at least three employees.
  3. Enter formula for Medical Allowance = D5 * 40% in cell with cell reference E5.
  4. Enter formula for Conveyance Allowance = D5 * 30% in cell with cell reference F5.
  5. Enter formula for House Rent = D5 * 50% in cell with cell reference G5.
  6. Enter formula for Income Tax = D5 * 5% in cell with cell reference H5.
  7. Enter formula for Net Pay = D5 + E5 + F5 + G5 - H5 in cell with cell reference I5.
So, the worksheet with Employee Pay sheet Formulas has been prepared successfully.

Download the Original Worksheet Prepared For Employee Pay Sheet Formulas

Sponsored Links

Click to Download Excel Workbook For Employee Pay sheet Formulas

Employee Pay sheet is normally required and maintained in every small business organization. There are very simple formulas are used to calculate monthly pay of the employees working in a small business. There is no need to develop a software for this purpose in a small book shop. Because, Microsoft Excel can be very useful to prepare such employee pay sheet with formulas.

Employee Pay sheet Formulas in Microsoft Excel

Here is the
Picture of Complete MS Excel Worksheet on

Employee Pay sheet Formulas in Microsoft Excel

Employees Pay Sheet Formulas Complete MS Excel Worksheet

 

Labels:

Comments

jack said…
YOU HAVE MADE MY DAY
November 24, 2016 at 7:04 PM
Post a Comment

Popular posts from this blog

Explain Different Types Of Data

DATA Data is the collection of raw facts and figures. It is without any proper meaning. Data may be collection of words, numbers, graphics or sounds. What is data? Explain different types of data Examples of Data 1) Student Data on Admission Forms When students get admission in a college. They fill admission form. This form     contains raw facts (data of student) like name, father’s name, address of student etc. 2)    Data of Citizens During census, data of all citizens is collected. 3)    Survey Data Different companies collect data by survey to know the opinion of people about their product. 4)    Students Examination data In examination data about obtained marks of different subjects for all students is collected.    Different Types Of Data There are following main types of Data. 1)    NUMERIC DATA Numeric data consists of 0 to 9 digits, + and – sign and dec...
Post a Comment
Read more

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world.  For example, Dual devices include:  Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...
1 comment
Read more

Explain Different Types of Software

Topic:  Different Types of Software with Examples Types of Software Different Types of Software with Examples There are two  main types of software  -  system software and application software . Let us discuss these types of software in detail with examples of each. System Software System software is a set of programs used to implement certain functions in a computer system. System software  controls the overall operations and components of a computer system. We can say that system software is the base on which application programs are executed. System software provides an interface between user and computer. Users use this interface to interact with the computer and perform different jobs on computer. Operating systems like Windows, Linux and Unix are the main example of system software . Similarly device drivers software are also examples of system software. Examples of system software Examples of system software are as follows: •...
1 comment
Read more