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.