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.

Calculate the expected annual return of your portfolio in Microsoft Excel by using the value and expected rate of return of each investment.

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 ...

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 ...