I am new to Excel. I have a spreadsheet someone set up. I have to enter a lot of info into it for a court hearing in 2 days time and need to get it right. (Am using Excel 2002).
This spreadsheet concerns parental visits and is to show the percentage of whether the driver was late, who the driver was, if alternate drivers were used, if drop off was on time, if drop off was late, etc etc. The first column is the date. It’s set up for Fridays, which I need, but I also need to add Weds in there too (every other Weds) with an option to change to Thurs sometimes. Am not sure how to do this so it’s formulated correctly for percentages.
Each of the other columns for that date will have something entered to show if late, on time, who was driving, etc. The period will go back 18 months from the current time. I need to show the percentage of how many times they were late, how many times the driver was the mother, how many times alternate drivers were used, etc over the total 18 month period. There is a percentages column to the right of the spreadsheet that automatically configures things to percentages.
I’ve entered more dates but am not sure if I still have the correct formatting in the date column. Also, I’ve added some rows, and need to find out if the formatting is still OK in those new rows. It all needs to be right so it automatically works out percentages.
I also need to produce pie charts to give the judge an immediate view of percentages, and am not sure how to do this. Once I know the spreadsheet is OK, I have a ton of information to enter, and not much time.
Am not sure how to upload the spreadsheet. If it's possible to, it would only take a quick lookover. Because I am a new Excel user everything seems difficult to me, but I think my questions are probably very basic for regular Excel users.
If anyone can help me, I would be really, really grateful.
Thanks, Amy
Bookmarks