What you'll learn:
Basic Microsoft Excel skills to help mill maintenance shifters and planners work more efficiently.
Requirements
Basic computer skills.
Description
Welcome to the Industrial Office, a classroom specifically tailored to the needs of those working in the mill. Our course aims to help professionals in the mining industry master the skills necessary to work faster and be more organized and efficient. This course is taught through a series of videos with industry specific examples to help mill maintenance shifters and planners learn basic Microsoft Excel skills that can be directly applied to their job on a daily basis. The course also includes Excel templates so students can follow along on the step-by-step examples and practice their skills immediately. Students can also edit the templates and used them on the job.
The introductory course is taught through a series of videos, each covering useful tools and skills to help mill maintenance shifters and planners in their everyday work. The mining industry is demanding more from mill maintenance shifters, supervisors and planners. Do not get left behind!. Follow this step-by-step excel course that guides you through real scenarios that a mill maintenance shifter, supervisor and/or planner may need to complete. Learn core functions of excel to increase office efficiency and better data management. Topics this course covers include:
Filtering for a shutdown meeting or safety records
Core functions (Average, min/max, count, sum) to calculate the cost of mill downtime and implement weekly maintenance schedules
Availability and utilization downtime calculations and yearly budgeting
Conditional formatting on training matrices to highlight when training is overdue or coming due shortly
Monthly budget accounting summary
Wear tracking of mill liners and using graphs/equations to predict failures
Workforce availability graphs
Weekly or Monthly Maintenance KPI report
Stop wasting time in the office, join the course now and become an Industrial Office Professional
Who this course is for
Mill maintenance shifters and planners.
Homepage

https://www.udemy.com/course/mill-maintenance-excel