Ett Excel-baserat informationssystem för IKEAs personalavdelningar

Sammanfattning: IKEA HaparandaTornio employ some two-hundred people in its furniture retail store. Keeping track of staff statistics and employee information has previously been achieved through the use of a basic Microsoft Office Excel spreadsheet. The store’s human resources department requested an upgrade to this system with the hope of speeding up and simplifying the administrative process, as well as to make it easier to monitor HR-related target statistics. The following report documents the development process of that upgrade as carried out by the author. The project draws on research in usability design and cognitive psychology to develop a user-friendly interface. Particular focus has been put on features related to the administration of employee information, including adding, editing and deleting personnel entries, as well as a clean and informative statistical interface. The result is an Excel-based information system that uses VBA programming to achieve said goals. The vast majority of planned features were implemented, although some were revised or scaled-down due to limitations in Excel. Overall the project goal was reached, but work will continue in order to enhance the final result.