Perform Quick Calculations in Excel

0 Flares 0 Flares ×

It is possible to perform quick calculations in Excel without having to write any formulas. This technique is brilliant and provides the formula result you need quickly and easily.

You can count, sum, average and find the maximum or minimum number in a range simply by selecting the numbers you want to calculate.

Quickly Calculate Values in Excel

  1. Right click on the Status Bar at the bottom of the screen
  2. Select the type of calculations you want to perform.

Status Bar shortcut menu

In Excel 2007 and above you can display all five formula results if you wanted to. In Excel 2003 only one can be visible at any given time, but you just need to come to the Status Bar to switch formula when needed

  1. Select the cells that contain the numbers you want to calculate
  2. The formula results are displayed on the Status Bar

Formula results displayed on Status Bar

More Formula Tutorials

Use the MID and FIND functions to extract parts of text

Find how many months are between two dates

List of popular Excel functions

Leave a Reply

Your email address will not be published. Required fields are marked *