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

How Do I Figure FICA for Payroll on an Excel Sheet?. Among the basic taxes that people need to pay, FICA is one of the most common.

To calculate this ratio in Excel, locate the total debt and total shareholder equity on the company's balance sheet. Input both figures into two adjacent cells, say B2 and B3.

If you need to perform an exponential calculation of numbers in a range of cells in Excel, this tutorial will show you how to do it in a few easy steps.

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

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

Freezing a row in Microsoft Excel or Google Sheets can organize your spreadsheet and make sorting through data a breeze. Here's how to do it.