The password spreadsheet isn't there because people can't remember. It's there because several people need the same login.
Better memory doesn't fix that. A shared vault does — and when someone leaves, you remove them instead of resetting everything.
List the accounts more than one person uses.