#1   Report Post  
Old July 26th 12, 07:09 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 4
Default Excel Noob

Hi all!

I'm very new to Excel and all it's possibilities. I'm comfortable with the Windows OS, Word and Outlook but quite clueless when it comes to Excel things. I've done most of the "Excel 2010 for dummies" book but it doesn't seem to go in depth enough for what I'm trying to do.

We have 30 employees and I have been given an Excel file to work with. It has the days of the month and the names of the employees on 12 sheets, then a summary page with Name, Dept, Hire date, Today's date, # of days employed, Vacation accrual hours/day, hours accrued, total hours taken as of Dec 31 09, Total hours taken in 2010, Total hours taken in 2011, total hours taken as of (today's date), hours balance, hourly rate, Value of Vacation and annual Salary.

I'm supposed to make a simpler easy to work with file and I'm quite overwhelmed with the whole thing. I can make a pivot table out of the summary page but not out of the monthly pages.

It's hard to picture, but does anyone know of ways I can make it more user-friendly? Also I'm not sure why I can't make the monthly pages in to pivot tables.

Thank you in advance!!

  #2   Report Post  
Old July 26th 12, 07:22 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by M.McD View Post
Hi all!

I'm very new to Excel and all it's possibilities. I'm comfortable with the Windows OS, Word and Outlook but quite clueless when it comes to Excel things. I've done most of the "Excel 2010 for dummies" book but it doesn't seem to go in depth enough for what I'm trying to do.

We have 30 employees and I have been given an Excel file to work with. It has the days of the month and the names of the employees on 12 sheets, then a summary page with Name, Dept, Hire date, Today's date, # of days employed, Vacation accrual hours/day, hours accrued, total hours taken as of Dec 31 09, Total hours taken in 2010, Total hours taken in 2011, total hours taken as of (today's date), hours balance, hourly rate, Value of Vacation and annual Salary.

I'm supposed to make a simpler easy to work with file and I'm quite overwhelmed with the whole thing. I can make a pivot table out of the summary page but not out of the monthly pages.

It's hard to picture, but does anyone know of ways I can make it more user-friendly? Also I'm not sure why I can't make the monthly pages in to pivot tables.

Thank you in advance!!
Hi,

Happy to help, but for this type of project you will have to supply some example data.

If you could post a "dummy" workbook, with no real names or anything else confidential attached that would be a great start.

If you're not happy posting it here, PM me and I'll give you an email address you can send it to.

S.
  #3   Report Post  
Old July 26th 12, 07:36 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 4
Default

I'll make a copy of the sheets with dummy info in them, thanks!
  #4   Report Post  
Old July 26th 12, 07:46 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 4
Default

Quote:
Originally Posted by M.McD View Post
I'll make a copy of the sheets with dummy info in them, thanks!
When I try to change the employee's names it messes up everything, and I can't risk my employment by giving out people's real names, even if it's just to you via email. Thank you for trying!!
  #5   Report Post  
Old July 26th 12, 08:19 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by M.McD View Post
When I try to change the employee's names it messes up everything, and I can't risk my employment by giving out people's real names, even if it's just to you via email. Thank you for trying!!
You could make a backup copy and use find and replace to change each name to something different... Change Spencer Davis to Name 1 and Sammy Davis to Name 2 etc.

Might take a while depending on how many names there are in your workbook, but might be the difference between you getting the help you need and not.


  #6   Report Post  
Old July 26th 12, 08:53 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 4
Default

Quote:
Originally Posted by Spencer101 View Post
You could make a backup copy and use find and replace to change each name to something different... Change Spencer Davis to Name 1 and Sammy Davis to Name 2 etc.

Might take a while depending on how many names there are in your workbook, but might be the difference between you getting the help you need and not.
I can't upload it to this site in the Excel format and it's too big when in PDF and in .txt I'd have to save and upload all 13 pages, too many for the site.

Holy CRAP this is frustrating. I PM'd you for that email address.
  #7   Report Post  
Old July 26th 12, 08:58 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by M.McD View Post
I can't upload it to this site in the Excel format and it's too big when in PDF and in .txt I'd have to save and upload all 13 pages, too many for the site.

Holy CRAP this is frustrating. I PM'd you for that email address.
Yeah this forum is frustrating when it comes to file restrictions.
But I'm sure there are reasons behind it.

Email address sent back to you by PM.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA Noob question: Read row data into VB6 Structure(UDT) Hal[_5_] Excel Programming 0 October 26th 07 05:38 PM
Not-so-noob Don[_22_] Excel Programming 3 October 4th 05 07:32 AM
exceL NOOB needs help w/sales tracking DIXIEDH Excel Discussion (Misc queries) 1 June 23rd 05 06:00 AM
Noob help Patrick Excel Worksheet Functions 3 March 6th 05 08:23 PM
VBA noob help with an IF duster Excel Programming 2 June 27th 04 10:21 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017