| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Monthly tracking log
I am a medium skilled user. I need to track several different training
courses for about 200 people. I currently have about 6 headings, entering the renewal training date due. Example: Name Course A Course B Course C Mickey 3/09 10/10 9/09 Joe D. 4/10 5/09 11/08 I could sort by date, but then I would be constantly sorting by course name. Is there a way to set this up so I can see each course with the closest date identified in some way? Such as by color, or some sort of reminder/tickler? Should I consider an Access program instead? Thanx in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Monthly tracking log
Look into using a Pivot Table
"Mudbug" wrote: I am a medium skilled user. I need to track several different training courses for about 200 people. I currently have about 6 headings, entering the renewal training date due. Example: Name Course A Course B Course C Mickey 3/09 10/10 9/09 Joe D. 4/10 5/09 11/08 I could sort by date, but then I would be constantly sorting by course name. Is there a way to set this up so I can see each course with the closest date identified in some way? Such as by color, or some sort of reminder/tickler? Should I consider an Access program instead? Thanx in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula for monthly tracking? | Excel Worksheet Functions | |||
| spreadsheet for tracking reports daily, monthly, yearly and graph | Excel Worksheet Functions | |||
| landlord monthly rent roll tracking? | Setting up and Configuration of Excel | |||
| Template for tracking monthly business expenses | New Users to Excel | |||
| Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) | |||
Linear Mode
