Learn Industrial Engineering the practical way
Free articles, Excel templates and calculators on IE, Excel and the garments industry - written from real factory experience.
FILTER Function in Excel
FILTER returns only the rows that meet a condition, as a dynamic array.
TEXTJOIN Function in Excel
TEXTJOIN joins text from multiple cells with a delimiter and can skip blanks.
REPLACE Function in Excel
REPLACE replaces characters at a specific position with new text.
PROPER Function in Excel
PROPER capitalizes the first letter of each word in a text string.
LOWER Function in Excel
LOWER converts all characters in a text string to lowercase.
UPPER Function in Excel
UPPER converts all characters in a text string to uppercase.
EDATE Function in Excel
EDATE returns the same day a number of months before or after a date.
YEARFRAC Function in Excel
YEARFRAC returns the fraction of a year between two dates.
WEEKDAY Function in Excel
WEEKDAY returns the day of the week as a number.
Calculators for everyday IE work
Target, efficiency, line balancing, man machine ratio, machine requirement and time study.
Templates & guides
Excel, PDF and Word files, ready to use. Files marked 🔒 are for members.
Get one practical IE tip every week
Join IE and production professionals learning with in2eff.