Below are selected results of a search regarding changes in Excel 2007 versus previous versions:

• Changes in Excel 2007 from Microsoft Technet
• Microsoft Office Excel from Wikipedia
• A Short Explanation of the Office 2007 Ribbon from Wikipedia
• Support for Macros in Excel 2007 from Directions on Microsoft
• A Visual of the Excel 2007 Add-Ins Tab from Directions on Microsoft

Calculate percent change with ABS function.

In my opinion, the calculation of percent change is one of the most misunderstood calculations in finance.  Most of the time the calculation is correct if both of the numbers compared are positive.  The problem arises when one or both of the numbers is negative.  If the denominator happens to be negative the calculation will be incorrect.  Unfortunately the calculation is so widely used that most people don’t realize there’s an error until it’s too late.

To insure that the sign in the denominator is always positive, apply Excel’s “ABS” function to the denominator.  If you make this a habit, your calculation of percent change will always be correct.

For example, if the price of gas rises from $2.50 / gallon to $2.75 / gallon, the price has risen 10%.

Let’s assume there is a credit on the financial statement and the beginning balance of an account was -$5.  The next month the balance in the account is $10.  The percent change in the account between the two months is calculated as:

Thank you for visiting cellMatrix.net, a learning resource for Microsoft Excel. Launched in March 2007, the objective of the site is to provide a user-friendly Excel resource for beginning and intermediate Excel users.

Although this site is set up like a weblog it will probably operate more like a static website. That is, my goal is not to post daily or even regularly but only when I have original material.

I hope you'll find site useful.