Spreadsheets, and When to Leave Them
You sort sixty-one spreadsheets in one merchandising department rather than condemning them. You see the jobs a sheet really is better at, and the four failures it cannot warn you about. You see what the sheets that survive an audit are asking the system to build. And you do the arithmetic of when to leave.
Published by Merchandising Academy · First lesson free to read
Course value
What will you be able to do?
Work outcome
You can name the numbers you are accountable for and where each one comes from, run a critical path in a system rather than a file, and make the case for or against moving a process off a spreadsheet.
Who it is for
Factory, supplier, brand and buying-office teams.
What you will produce
You classify your own sheets with a reason written against each. You build a check for split files that takes ninety seconds a week. You run a named-range and formula census, priced against your own incident log. You rank the missing fields your sheets are asking for by payback. And you write a threshold in decisions a week.
Learning format
5 lessons · 0 templates · workplace calculations and decisions.