learn microsoft excel

Basic Calculations in Microsoft Excel

Home Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010


You use the cell address in Excel to do the calculations. For example, if you have a value '20' in cell A1 and a value 30 in 'B1', you can display the product of the 2 values in 'C1' by typing '=A1*B1' in cell 'C1'. In case you make a mistake in the entry of the numbers in the cells 'A1' or 'B1', you just retype the value and the new calculated value is immediately displayed in cell 'C1'. Of course, if you wish, you can change the formula in cell 'C1' to display, for example, the total or sum of the values in cell 'a1' and 'b1' by typing '=a1+b1' in cell 'c1'.
Watch the Excel training video below:

Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010