How to create a calculation macro in Excel: Once you know how to access the Excel worksheet cells you can create a macro to perform many type of calculations including addition, multiplication, division, etc. You can also use in-built functions and customized functions like sum, sumif or perform compound interest calculations. Using the cells property we have demonstrated the calculation of various allowances based on the employeyee's basic salary and finally calculated the total remuneration. The training video highlights the complete process.