First off, I apologise if this has been posted in the wrong sub-forum, or if it has been answered elsewhere and I have missed the thread in question.
Currently the department that I work for has 2 ways of monitoring annual leave and absences, one being an HR run system and the other being an Excel spreadsheet that is updated manually as needed. Lately there has been some concern regarding the feasibility of this spreadsheet in ensuring that no one is off without cover, primarily with regards to staff being on training courses (ie, at work as far as the record is concerned but not actually available).
Is there a simple way that we could monitor this (the annual leave and training data is currently kept in different spreadsheets)? I did consider pivot tables, but as I have used them rarely in the past I hoped that someone might be able to offer a suggestion before I muddle my way through to find I've misunderstood something and it's not a viable solution after all!
Thank you for your help in advance!
Bookmarks