Microsoft Excel VBA & Macro for Costing Automation

6 hours
Request Training Proposal

Course Contents

Excel Based Automation. The user has to select the necessary drop-down list on the user forms and needs to specify the desired ingredients with spec details. The cost per unit of each excipients will be filled by the owner and the output will be forwarded to the Production unit with the format of either a PDF or Excel.

  1. Create a Master Data taking all the maximum combinations of excipients with Spec / Unit / Color / etc. The same will be retained at the backend and can be opened for necessary append of records in columns / rows as well as and when on need basis. Create an SKU based on Master Data using a form for adding components. Designing form controls with necessary drop downs. Dynamic dependency list for options to select necessary variables. > 6 hours
  2. After completion of stage 1, the output format will be declared with all the necessary validation controls or measures.
  3. The minor changes if anything required to refine the project and support till it is Go Live.


Instructor Profile


Microsoft Office Specialist, has a wide experience in Hardware as well as Software. He has been conducting corporate trainings for the last 15 years on National & International Level. Has given consistent performance and is adaptable to new technologies.

This course includes:

  • 100% Online Sessions
  • Instructor led
  • Customizable Syllabus
  • Customizable Schedule
  • Certificate of Completion
  • Training Recordings
  • Training Resources
  • Learner Assessment
Request Training Proposal

Related courses