Pay packet calculation macro in Excel:
- First you see a worksheet with the legend
- The macro code is then displayed as a text file
- The code is shown in the Visual Basic Editor
- In the Visual Basic Editor click on the run button and follow the data input instructions
- You can then see the input and calculated data under the respective column cells
- Two methods of accessing cells have been demonstrated - 'Range' and 'Cells'
- A 'do while' loop and an 'if' use has been effectively shown
- The Microsoft Excel macro calculates the 'perks' and the total 'package'.
- Now you can extend this program for your practice
- Later on we'll see how to optimize such a macro
- Remember you can 'pause' the Microsoft Excel training video to take a closer look at the code
|