I know this is an old thread, but talking to some people today, the subject of tracking HRIS data in Excel came up again.
Is this a good idea?
The short answer is - NO. 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
<link outdated-removed> ( Search On Cite | Search On Google )
From United States, Sonora
Is this a good idea?
The short answer is - NO. 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
<link outdated-removed> ( Search On Cite | Search On Google )
From United States, Sonora
Please find HRIS developed in Excel any ... a true help for a freasher / Mgmt student to understand...
Check : Opex Solution • Index page
From India, Mumbai
3Check : Opex Solution • Index page
From India, Mumbai
We have developed this HRIS System in Excel and it is for free... post you custom needs and we would develop it accordingly .... check the link below
HRIS - Development
Hello Guys,
We have developed HRIS for one of the user with HRIS need... Its in EXCEL and does the basic job of tracking... as we have seen there are so many requirements here for HRIS we are planning to develop an excel based application but enabled aith macro (we hate tat macro msg)....
we need your help to formulate the requirement so that we can start development as per your requirement..
Also we are planning to add more analytics to that we can derive various MIS report which would tell diff story about the organization...( regarding strategy, payment, resource utilization, etc)... also KPIs could be developed..
We request you to post suggestions and reviews as we develop and share the HRIS with you all for FREE...
Basic HRIS can be found here--
Opex Solution • View topic - Need HRIS in Excel
at
Opex Solution - Excel Solutioning for Free
https://www.citehr.com/242825-hris-development.html
From India, Mumbai
HRIS - Development
Hello Guys,
We have developed HRIS for one of the user with HRIS need... Its in EXCEL and does the basic job of tracking... as we have seen there are so many requirements here for HRIS we are planning to develop an excel based application but enabled aith macro (we hate tat macro msg)....
we need your help to formulate the requirement so that we can start development as per your requirement..
Also we are planning to add more analytics to that we can derive various MIS report which would tell diff story about the organization...( regarding strategy, payment, resource utilization, etc)... also KPIs could be developed..
We request you to post suggestions and reviews as we develop and share the HRIS with you all for FREE...
Basic HRIS can be found here--
Opex Solution • View topic - Need HRIS in Excel
at
Opex Solution - Excel Solutioning for Free
https://www.citehr.com/242825-hris-development.html
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Mis.jpg
New MIS reports Master Data.xls
Mis-report_form _116.doc