Learn Industrial Engineering the practical way
Free articles, Excel templates and calculators on IE, Excel and the garments industry - written from real factory experience.
TEXT Function in Excel
TEXT converts a number or date into formatted text.
SUMIFS Function in Excel
SUMIFS adds values that meet multiple conditions at once.
SUMIF Function in Excel
SUMIF adds values that meet a single condition.
SUM Function in Excel
SUM adds all numbers in a range of cells.
SUBSTITUTE Function in Excel
SUBSTITUTE replaces specific text within a string with new text.
SEARCH Function in Excel
SEARCH returns the position of text inside another text, case-insensitive.
ROUND Function in Excel
ROUND rounds a number to a specified number of decimal places.
RIGHT Function in Excel
RIGHT returns the last N characters from a text string.
PMT Function in Excel
PMT calculates the fixed periodic loan payment amount.
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.