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

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 storage devices

Topic: Explain different types of storage devices in Computer systems Storage Devices Storage devices are used to store data and instructions permanently. Storage devices are also called secondary storage devices / backing storage devices / external storage devices or auxiliary storage devices. Examples of storage devices include Hard Disk, CD and DVD etc. Why Secondary Storage Devices are Used? Secondary storage devices are used because: Primary memory(RAM) is volatile and temporary. When computer is switched off, all data in ram is erased. Storage devices can store large amounts of data and instructions permanently whereas Primary memory has less capacity of storing data. Types Of Storage Devices There are three main types of storage devices:  Magnetic Tape   Magnetic Disk   Optical Disk   Flash Memory storage devices 1. Magnetic Tape Magnetic tape is the oldest storage device. It is made of plastic coated with m...
3 comments
Read more

Explain Different Types Of Output Devices

Output devices Out put devices are used to display results of processing to the user. They perform the following functions:  Receive results from memory  Convert data into human readable form  Display results to the user Examples include: Monitor, printer, plotter, speaker, and multimedia projector. Different Types of Output Devices 1.    Monitor LCD Monitor CTR Monitor     Monitor is the most commonly used output device used to display results of processing. It has a TV like shape. Pictures on monitor are formed with picture elements called PIXEL. Monitors may be Monochrome that will display results in Black & White. Color Monitors are also available. They display results in multi colors. Monitor produces soft copy output. 2.    Printers Printers are used to produce hard copy out put. They print processing results on paper. Printers are divided into two main categories: · ...
1 comment
Read more

What are Different Types of Input Devices With Examples

Topic: Different types of input devices of a computer system with examples, pictures and explanation:  Topics Covered are: Definition of Input Devices Functions of Input Devices ( How input devices work? ) Examples of Input Devices Pictures / Images of different input devices Different Examples of Input Devices With Description Keybboard Mouse Trach Ball Trackpad Joy Stick Light Pen Microphone Scanner Graphic Tablet ( Digitizer ) Digital Camera Touch Screen ( I/O Device / Dual Device - Perform Both Functions input + Output ) INPUT DEVICES ( Definition ) Input devices are used to enter data and instructions into computer memory from external world. Input Device is a hardware part of the computer that is used to enter data and instructions into computer memory. The examples of input devices include: Keyboard, Mouse , Track ball, Track Pad, Joy stick, Touch Screen, Light pen,   Scanner , Digital Camera, Microphone, Graphics tablet e...
Post a Comment
Read more