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

Uses Of Computer In Education Field

Computer can be used in education in the following ways:  Computers In Teaching and Learning Process ( Computer Aided Learning - CAL ) Computers are being used actively in educational institutes to improve the learning process. Teachers can use audio video aids through computer to prepare lesson plans. They can use Microsoft Power Point to prepare electronic presentations about their lectures. These electronic presentations will be displayed on multimedia projectors in class rooms. This will be interesting and easy to learn for students. Multimedia presentations are easy to deliver for teachers too, These presentations save a lot of effort and time. Moreover multimedia presentations are interesting to view and hear sound and visual  effects. Computers will be helpful for:                        Instructing the students using PowerPoint slides, Word documents or Web pages and using hyperlinks for be...
1 comment
Read more

Types Of e-Commerce

Types/Categories/Modes of e-commerce. There are three main types of e-commerce as follows: 1) Business To Consumer (B2C) B2C ecommerce consists of selling goods and services to individual consumers. In this type, consumers or customers can visit the website and purchase goods online. The website will have a StoreFront. This storefront will show product details, pictures and a shopping cart. Shopping cart is used to collect items to purchase. Advantages of B2C e-commerce B2C e-commerce has the following advantages: * Shopping can be faster and more convenient. * Offerings and prices can change instantaneously. * Broadband telecommunications will enhance the buying experience. 2) Business To Business (B2B) B2B e-commerce takes place between two businesses. One business provides services to other business. Examples of B2B include: Online Advertisement, recruiting, sales, marketing, technical support and training. For eample, some companies provide online purchasing...
5 comments
Read more

Types Of Network Topology

Today, we will types of network topology . What is a Network Topology? Definition of Network topology is the shape of the network . It is the physical layout of connected devices in a network. It tells us how a network will look like. Network Topology ( Definition 2) : The way in which the connections are made among all the network entities is called the topology of the network. Network Topology ( Definition 3) :Network topology specifically refers to the physical layout of the network, e.g., the location of the computers and how the cable is run between them. Network Topology ( Definition 4) :The physical topology of a network refers to the configuration of cables, computers, and other peripherals. The characteristics of a network depend upon the network topology selected. types of network topology Explain different types of network Topology Different network topologies are as follows: 1. Bus Topology 2. Ring Topology 3. Star Topology 4. Tree Topolo...
2 comments
Read more