Over time, I have seen a number of entries posing the question of how to use Microsoft Excel as an HRIS.
The short answer is that you shouldn't. While Excel is great for manipulating and rearranging data, it is not good at handling complex relational data.
What's That? Complex Relational Data. As an example, One employee may have had a history of many positions within an organization. One employee may have many entries related to leave and attendance. One employee may have many entries related to benefits. The list goes on and on. Tracking this in Excel without duplicating data and increasing your chances for error is a nightmare.
If you are a small or medium business and large solutions such as PeopleSoft and SAP are not in your budget, you can look to more appropriate tools than Microsoft Excel.
Microsoft Access is a relational database system capable of managing complex data and sharing within small workgroups. To see an HRIS created with Microsoft Access, see <link outdated-removed> ( Search On Cite | Search On Google ) . Full Source Code is available allowing you to expand upon what is there and create what you want.
Good Luck with your HRIS searches and just remember to use the right tool for the right job.
Thanks,
Mark
From United States, Sonora
The short answer is that you shouldn't. While Excel is great for manipulating and rearranging data, it is not good at handling complex relational data.
What's That? Complex Relational Data. As an example, One employee may have had a history of many positions within an organization. One employee may have many entries related to leave and attendance. One employee may have many entries related to benefits. The list goes on and on. Tracking this in Excel without duplicating data and increasing your chances for error is a nightmare.
If you are a small or medium business and large solutions such as PeopleSoft and SAP are not in your budget, you can look to more appropriate tools than Microsoft Excel.
Microsoft Access is a relational database system capable of managing complex data and sharing within small workgroups. To see an HRIS created with Microsoft Access, see <link outdated-removed> ( Search On Cite | Search On Google ) . Full Source Code is available allowing you to expand upon what is there and create what you want.
Good Luck with your HRIS searches and just remember to use the right tool for the right job.
Thanks,
Mark
From United States, Sonora
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls