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.

Learn how to calculate the beta of an investment using Microsoft Excel.

Whether you prefer Excel, Numbers, or Google Docs, here's what you, the savvy spreadsheet user, should know how to do.

How to Make an Excel Spreadsheet Roll Over to the Next Year for Calculations. Accounting for a small business using Microsoft's Excel often requires the use of figures from one year as part of the ...

To calculate the current yield of a bond in Microsoft Excel, enter the bond value, the coupon rate, and the bond price into adjacent cells (e.g., A1 through A3).

If you refer to the same value in an Excel sheet often, treat it as a constant. Anyone who uses Excel, even just a bit, knows how to name a cell or range and then use that name in formulas. It’s ...