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
EXACT Function in Excel
Compare text case-sensitively with EXACT.
Microsoft Excel
VLOOKUP Function in Excel
VLOOKUP searches the first column of a table and returns a value from another column.
Microsoft Excel
TRIM Function in Excel
TRIM removes extra spaces from text.
Microsoft Excel
TODAY Function in Excel
TODAY returns the current date, updating automatically.
Microsoft Excel
TEXT Function in Excel
TEXT converts a number or date into formatted text.
Microsoft Excel
SUMIFS Function in Excel
SUMIFS adds values that meet multiple conditions at once.
Microsoft Excel
SUMIF Function in Excel
SUMIF adds values that meet a single condition.
Microsoft Excel
SUM Function in Excel
SUM adds all numbers in a range of cells.
Microsoft Excel
SUBSTITUTE Function in Excel
SUBSTITUTE replaces specific text within a string with new text.