How to Use Excel for GAAP Accounting. The generally accepted accounting principles give an accounting guideline that allows third parties to fairly evaluate account records.

The accounting format in Microsoft Excel 2010 is very similar to the currency format---both display the currency symbol next to every number. But the accounting format has a few differences that ...

Move Your Accounting Data into Excel Of course, your business data probably exists in your accounting software or your other small business software, so before you begin you need to get it into Excel.

Find out how to use Microsoft Excel to calculate the present value of a fixed annuity, including a calculation example. The calculation doesn't account for taxes.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

How to Calculate Variance in Excel To calculate variance in Excel, you will need to have your data set already entered into the software. Once you have your data, you can choose your formula based ...