I am stuck if I am on the right track or not. I want to track data from employee training. The worksheet I attached shows the employee and hours.
I would like to enter in data of employee, training, date, and hours. Then I would like it to auto fill here if possible, and be able to run report on training data.
I am not sure if I am on the right track and have over thought it to much and just need help to guide me. I am not real experienced with excel.
Hi crittergirl and welcome to the forum,
Excel works best when the data is in TABLES. Your data looks great, spread out over month sheets and separated by each person's name but Excel won't work with it well. See the attached where I've created some fake data of 10 employees and dates and hrs. When the data is stored like this, it can be used MUCH more effectively. I've done a Pivot Table for you to show how I'd do your problem.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thank you so much. I just have one more question just to verify.
I can add columns of data like provider, and this will also integrate into the pivot table?
I have never worked with a pivot table as you can see I do it the long hard way.
No Problem in adding more columns of data. You can't leave blank rows or columns and have it still be a TABLE.
When you get to Pivot Tables, you can sort and group and other calculations.
I see lots of people who start with "pretty". They want it to look like something but this makes things a lot harder for Excel to work with...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks