Skip to content
DOWNWAY
All productsFiles in Portuguese (Brazil)

20 Excel formulas for the shop floor

20 formulas working on order data, with automatic checks, to copy and adapt.

20 Excel formulas for the shop floor

Look up by code, sum by period, count working days, sum with two conditions and other everyday tasks. Each formula is shown working on sample order data, with a column that checks the result.

What you get

  • 20 formulas on sample data
  • Lookup, sums, dates, text and ranges
  • Column that checks the result
  • Works in older Excel versions too

Product video (Portuguese narration)

Preview

Sample data used by the formulas
Sample data used by the formulas
The 20 formulas checked in Excel
The 20 formulas checked in Excel

Who it's for

  • You use Excel in production, purchasing or quoting
  • You know the basics and want the next step
  • You train colleagues

Send us one drawing

We return a review with issues found, suggested fixes and a fixed-price scope. Free, under NDA if you need one.