SOLVED

How to organize completed tasks in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2598097%22%20slang%3D%22en-US%22%3EHow%20to%20organize%20completed%20tasks%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2598097%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20pretty%20sizable%20training%20log%20in%20excel%2C%20wherein%20we%20track%20mandated%20trainings%20and%20the%20completion%20dates%20for%20each%20employee.%20My%20manager%20would%20prefer%20not%20to%20have%20so%20many%20columns%2C%20so%20I%20created%20another%20log%20that%20lists%20the%20completions%20by%20subject%20so%20she%20doesn't%20have%20to%20filter%20the%20main%20sheet.%20At%20the%20bottom%20of%20this%20screen%20shot%20you%20get%20the%20idea%20of%20using%20tabs%20to%20organize%20task%20and%20training%20completions.%20(Note%3A%20I%20have%20a%20totally%20separate%20file%20for%20the%20completions%20by%20subject).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20other%20way%20to%20have%20all%20of%20the%20information%20on%20one%20sheet%20without%2030%20columns%3F%20I%20am%20looking%20into%20what%20pivot%20tables%20can%20do%20for%20this%20situation.%20Any%20ideas%3F%20Perhaps%20there%20is%20a%20way%20to%20make%20it%20look%20aesthetically%20pleasing%20and%20less%20overwhelming%20to%20the%20eye%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2598097%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2647799%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20organize%20completed%20tasks%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2647799%22%20slang%3D%22en-US%22%3Eyes%20pivot%20table%20will%20do%20the%20job%3C%2FLINGO-BODY%3E
New Contributor

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?

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
yes pivot table will do the job
Thank you