Microsoft Excel
Practical Excel formulas, templates and dashboards for IE and production teams.
HLOOKUP Function in Excel
HLOOKUP searches the first row of a table and returns a value from a specified row.
XLOOKUP Function in Excel
XLOOKUP is the modern replacement for VLOOKUP with more flexibility.
Production planning in Excel: Gantt chart, working calendar, job sequencing and set-up matrix
Build a real planning tool in Excel: a Gantt chart that flags late jobs, a Julian working calendar with breaks and shifts, cascading job times, re-sequencing, multiple work centres and a set-up matrix with INDIRECT.
Excel date, time and text formulas for planners
TODAY, NOW, DAY, MONTH, YEAR, WEEKDAY, date differences, TEXT for time formats, CEILING for rounding to cartons or bundles, and LEN, SUBSTITUTE, FIND, LEFT and RIGHT for cleaning text.
Excel logic and summaries: IF, SUMIF, COUNTIF, FREQUENCY and Pivot tables
Decide with IF, add and count with conditions using SUMIF and COUNTIF, group values with FREQUENCY, summarise thousands of rows with a Pivot table - and combine IF, CONCATENATE and SUMIF for a running balance.
Excel lookup formulas: VLOOKUP, HLOOKUP, INDEX, MATCH and CHOOSE
Find any value in a table: when to use VLOOKUP or HLOOKUP, why INDEX + MATCH is more flexible, and how CHOOSE switches between ranges - with simple examples you can copy.
Build an hourly production dashboard in Excel
One data sheet, one pivot table and two charts give management a clear view of target vs actual by hour.
10 Excel formulas every industrial engineer should know
XLOOKUP, SUMIFS, INDEX-MATCH and more - with examples from operation bulletins and production reports.