Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Formulas Tab

EXCEL 2010 FORMULAS CALCULATION RIBBON

Calculation

EXCEL 2010 FORMULAS CALCULATION GROUP

The default setting is for formulas to automatically calculate in Microsoft Excel 2010. In case this setting ever becomes deactivated, we will show you how to make Excel formulas calculate automatically again.

EXCEL 2010 FORMULAS CALCULATION SUM


In our example to the right, the equation for cell B7 is shown at the top: =SUM(B3:B6).

Therefore, if calculations are set up automatically, the value will automatically change in B7 if any of the values change in B3 through B6. If this ever gets turned off, the value in B7 will not update if the values are changed in B3 through B6.

EXCEL 2010 FORMULAS CALCULATION OPTIONS

Select Calculation Options from the Calculation section of the Formulas tab. In the drop-down menu, Manual is selected. Click on Automatic to have your formulas update when associated cells are changed.

 

The Calculate Now command can be used when you want to calculate the entire workbook immediately. This is only necessary if automatic calculation has been turned off. Similarly, the Calculate Sheet command is used to calculate the current sheet you are working in instantly. Again, this is only necessary if the automatic calculation has been turned off.

Next Tutorial


This concludes the Calculation tutorial.
Click next to continue to the Excel 2010 Data Tab tutorial.