Microsoft Excel VBA & Macro for Costing Automation

Languages
English
Duration
6 hours
Investment
$$$$$
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.

N/A

Instructor Profile

instructor_image

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

StepUpwards Training Requirement Form

Please complete this form so we can get back to you with a training proposal.

By clicking "Submit", you agree to our Terms of Use , Privacy Policy and Service Agreement

Individuals younger than 18 years of age, but of the required age for consent to use online services, as per applicable law in their country of residence may set up an account and enroll in appropriate courses through their parent or guardian. Individuals younger than the required age for consent to use online services may not use the Services offered by StepUpwards Platform. For more details, please refer to our Privacy Policy.

Related courses

course_image

Microsoft PowerPoint 2016

instructor_image

Ritu Arora

View Course
course_image

Advanced Excel

instructor_image

Ritu Arora

View Course
course_image

Master Excel - Beginner to Advanced

instructor_image

Ritu Agarwal

View Course