5 Basic Excel Skills You Need to Pursue a Career in Supply Chain
Excel abilities are useful in many areas of business, and in the supply chain, excel is used for data evaluation, calculations, inventory tracking, demand planning, scheduling, and many other functions. For the supply chain professional, Excel abilities are a must-have for breaking down large or complex tasks into smaller bite-sized pieces. Below is a shortlist of six essential Excel skill types that supply chain professionals should have if they want to advance their careers. VLOOKUP Short for ‘vertical lookup,’ VLOOKUP is a function that enables the search of a column for a certain value so that a related value can be returned. To use VLOOKUP, select the cell for the formula output, enter the cell with the value you want to find, enter the range of columns and finally enter the number of the column where the related value is found. The formula should then output a result based on your search parameters. Relative Reference Cells Produced by default, relative references change their