|
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
|
|