How to Use a Payroll Calculator in an Excel Spreadsheet. For small business owners who prefer to do their own payroll, one option is to use a Microsoft Excel spreadsheet to keep track of employee pay.

For instance, the employer portion of the payroll tax is 6.2 percent, so the calculation would multiply the employee's gross pay by 6.2 percent. So if the gross pay was in cell D3, the formula ...