Meryl's Notes Blog

I’ve literally been buried in Excel trying to create tracking metrics for a training program. The problem is that there are too many variables to create a pivot table or other automated function to provide meaningful information. The key is to show how much training has been completed and not completed by month so the bigwigs know when we have to pull their employees for training and for how long.

I provided an example, but the real thing is more complex as there are 10 classes, 11 departments, and 300 names. I searched the Internet for Excel ideas and tutorials, but most are focused on financials or creating forms. Nothing like this. We do not have a training program in place that would make it worth it to invest in software or create an Access database to give us what we need.

Any geniuses out there with a few hints to help a poor crossed-eyed girl?

<edit>Finally making headway, but it is a long, slow method. It will be easy to maintain once I get all the formulas set up.</edit>