Service level
There has been some problems with out of stock situations during last year.
Purchase spend
Management requires an overview report of purchase spend.
Missing deliveries
There are deliveries missing during a certain period and you suspect a pattern.
Delivery performance
The Supply Chain Manager would like you to present supplier delivery performance.
Formula Exercises
Realistic case studies which will train you in implementing your new Excel skills.
FIND Function
Returns the starting position of one text within another text.
CONCAT Function
Returns joined items as one text.
Text Functions
Unlike numbers, text usually comes in non-standard formats where a clean-up is needed.
COUNTIFS Function
Returns a count of the number of rows that matches the criteria in criteria ranges.