Microsoft Excel Training- From Beginner to Expert in 6 Hours

Ozgrid, Experts in Microsoft Excel Spreadsheets

EXCEL AUTO CALCULATE

FREE EXCEL HELP

 

Lesson 20 - Excel Auto Calculate.  Calculate Without Formulas

<< PREVIOUS LESSON |NEXT LESSON>> | BACK TO EXCEL LEVEL 1 TRAINING INDEX

EXCEL AUTO CALCULATE

AutoCalculate

There might be times when you wish to find out the sum of a range of numbers quickly without having to add a formula to the Worksheet. For these instances, we can simply use the AutoCalculate feature of Excel.

To do this, select a range of cells containing the numbers you want to sum and look in the Status bar. If the Status bar is not visible go to View>Status bar. If the range of cells you wish to sum are non-adjoining, hold down the Ctrl key while selecting the ranges.

We are not restricted to only displaying the sum of our selected range! If you right click on the Status bar a shortcut menu will pop-up allowing us to choose one of six basic formulas. Have a look at each of these in turn and if you are unsure of what they do, please ask.

Go To Free Excel Training Lesson 21 .  Back to Previous Lesson

Go to Excel Basic/Level 1 Training Index

<< PREVIOUS LESSON |NEXT LESSON>> | BACK TO EXCEL LEVEL 1 TRAINING INDEX


Instant Download and Money Back Guarantee on Most Software

Microsoft Excel Training- From Beginner to Expert in 6 Hours

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates