Free Microsoft Excel Training Videos

Pay packet calculation macro in Excel

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







Formulas Overview

Pay packet calculation macro in Excel