Although a running balance is commonly maintained on the same Excel worksheet as the debits or credits, you can also keep a running balance with figures that reside on different Excel sheets.

How to Do Single-Variable Algebra in Excel. Microsoft Excel allows you to perform equations in individual cells in your worksheet.

Microsoft Excel has so many user-friendly and automated tools that most people with even a basic understanding of math can begin, create, and save even a relatively complex worksheet.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.