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.

Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.