Our managers use a spreadsheet that lists some 100 skills across the top, with a side listing of employees, each with a checkmark, X, in the appropriate column according to the skills they know. To save space, the skill names are turned at steep diagonal in the spreadsheet.
The main purposes of the spreadsheet are:
1. To see how many are trained in a given skill, for workload and workforce planning
2. To see in which workloads a given employee is trained.
I could layout a report in landscape orientation that would give all that information, but how can I save space? To type out each skill horizontally would take a lot of room. Is it possible to turn the group headings diagonally in a report? That would allow me some space efficiency. I could export to Excel, but that seems like a lot of formatting each time. Possibly write a macro to automate the layout format after exporting.
Have any of you encountered a similar situation in which made a different layout but still had the information to meet the purposes of the report?
What are some options for meeting these report purposes?