Knowledge Hub
Microsoft Excel
Practical Excel formulas, templates and dashboards for IE and production teams.
All204
Industrial Engineering27
Production Planning25
Lean & Six Sigma25
Microsoft Excel71
Quality12
Textile & Thread2
Sewing Machines19
Maintenance5
Utility5
Merchandising5
Store & Inventory5
Garments Industry3
Microsoft Excel
SUMPRODUCT Function in Excel
SUMPRODUCT multiplies arrays and sums the products.
Microsoft Excel
ROUNDDOWN Function in Excel
ROUNDDOWN rounds a number down to specified decimal places.
Microsoft Excel
ROUNDUP Function in Excel
ROUNDUP rounds a number up to specified decimal places.
Microsoft Excel
MOD Function in Excel
MOD returns the remainder after dividing one number by another.
Microsoft Excel
INT Function in Excel
INT rounds a number down to the nearest integer.
Microsoft Excel
ABS Function in Excel
ABS returns the positive value of any number, removing the negative sign.
Microsoft Excel
CHOOSE Function in Excel
CHOOSE returns a value from a list based on an index number you provide.
Microsoft Excel
OFFSET Function in Excel
OFFSET returns a reference shifted by rows and columns from a starting cell.
Microsoft Excel
INDIRECT Function in Excel
INDIRECT converts a text string into a valid cell reference.