Shift Log Redevelopment

One of the main objectives for Maria Lynch and Joe Barrigan from Prinovis Ltd having Excel training was to understand the power of Excel better and help to redesign their existing Spreadsheet to help it become easier to use and more dynamic.

The company runs its processes and shift logs using this data and I felt that a different design would help them:

The spreadsheet was transposed to allow the data to be viewed quicker and easier
Navigation buttons were incorporated
Conditional formatting and new formulae to calculate dates
Dropdown fields for validation
Additional sheets were incorporated to track letters and comments
Holidays were captured more easily
Reports were generated to capture trends and alerts
Macros were generated for movement of data for each shift at a click of a button

Back to Case Studies Back to top