You can quickly calculate a formula based on a group cells without actually putting the formula into your spreadsheet.  You can quickly see the results of an Average, Count, Numerical Count, Min, Max, and Sum, etc. for a range of cells without writing the formula using a tool called AutoCalculate.

• 1. Select a range of cells with your mouse that you would like calculate – for example that you want to know the Sum (total) of.
• 2. Look down in the lower right hand corner of your screen on what is called the Status Bar. Notice that there are some calculates listed there based on your selected data.
• 3. To adjust what calculations appear, right-click on the status bar and then check the desired AutoCalculate choices to make them visible on the status bar.

 Click here to view our Training Calendar to see what other software tricks you can learn.

Tags: auto calculate, excel, Formulas

This entry was posted on Wednesday, September 3rd, 2008 at 11:11 am and is filed under Microsoft Excel. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.