I have a pretty sizable training log in excel, wherein we track mandated trainings and the completion dates for each employee. My manager would prefer not to have so many columns, so I created another log that lists the completions by subject so she doesn't have to filter the main sheet. At the bottom of this screen shot you get the idea of using tabs to organize task and training completions. (Note: I have a totally separate file for the completions by subject).
Is there any other way to have all of the information on one sheet without 30 columns? I am looking into what pivot tables can do for this situation. Any ideas? Perhaps there is a way to make it look aesthetically pleasing and less overwhelming to the eye?
