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
COUNTIF Function in Excel
COUNTIF counts cells that meet a single condition.
Microsoft Excel
COUNTA Function in Excel
COUNTA counts all non-empty cells, including text, numbers, and symbols.
Microsoft Excel
COUNT Function in Excel
COUNT counts the number of cells containing numbers in a range.
Microsoft Excel
CONCATENATE Function in Excel
CONCATENATE joins two or more text strings into one single string.
Microsoft Excel
AVERAGEIF Function in Excel
AVERAGEIF returns the average of values that meet a specific condition.
Microsoft Excel
AVERAGE Function in Excel
AVERAGE calculates the arithmetic mean of a range of numbers, ignoring blanks and text.
Microsoft Excel
AND Function in Excel
AND returns TRUE only when all conditions are true, useful for combined eligibility checks.
Microsoft Excel
MEDIAN Function in Excel
MEDIAN returns the middle value of a dataset.
Microsoft Excel
SMALL Function in Excel
SMALL returns the nth smallest value in a range.