February 4, 2014

Calculations MS Excel

Performing basic calculations in MS Excel using cell addresses
The importance of the ‘cell address’ cannot be stressed enough. In fact, you can access data in any worksheet or workbook if you know the cell address, and then performing calculations in Excel is really a breeze!.

  • Use the value at the cell address rather than the value itself to do calculations in Excel
  •     You can do the calculation by multiplying the value ‘99.9’ in Excel cell ‘b2’ with the value 12 in Excel cell ‘c2’
  •     You can also calculate the result using ‘=b2*c2’
  •     The latter gives you complete flexibility and power of Microsoft Excel
  •     You can copy the formulas
  •     You can make corrections quickly
  •     All the values connected with the corrected Excel cell get updated automatically

Refer to the Excel training video to understand the concept better.

Further reading