Microsoft Excel Training Videos

Performing basic calculations in 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 above to understand the concept better.
More about Microsoft Excel calculations

Basic calculations in Excel