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