Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: A good example of how to summarize data in excel

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Benjamin
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have to summarize data by week from many users in a worksheet template. (Thanks to this list I now use a template to collect this data by month). What I need is a good example of how to compile this data to show each users progress toward their goal and how to show the groups progress towards its goals. Example: All four users have a goal of painting 120 widgets for the year. I want to have a column that has a plan of 120 widgets and each week a column tha the user will input how many widgets were painted for the week. I have many columns that track elements like this.
    Currently eash user has a sheet that uses 4 weekly rows and 1 totals row. There 44 columns that contain Plan/Actual data for each week.
    I take each users data and add it up by week to get a group total. Then I take all the group totals and add them together by week for a higer level view. Is there a good example of how to do this? Would someone please help me to learn how?
    Thank you

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    Benjamin
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Guess I did not ask this one correctly

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    benkong2
    it's not that you didn't ask it correctly, it's probably more because you're really asking a design question, which can be pretty tough because there are so many possibilities. remember that making sure your users can understand and will use the sheet is the most important thing.
    from your post it sounds like you have most of your data set up already, but as a start i'd suggest you consider using charts and pivot tables. chip pearson's site has a good section on pivot tables which may help. it's at http://www.cpearson.com/excel/pivots.htm.
    charts are pretty easy to create with the wizard and the help topic isn't bad. i know this is pretty general advice but it was a pretty general question you asked.


    On 2002-02-25 03:35, benkong2 wrote:
    Guess I did not ask this one correctly

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Benjamin
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the reply I will try.

    [quote]
    On 2002-02-25 16:00, anno wrote:
    benkong2
    it's not that you didn't ask it correctly, it's probably more because you're really asking a design question, which can be pretty tough because there are so many possibilities. remember that making sure your users can understand and will use the sheet is the most important thing.
    from your post it sounds like you have most of your data set up already, but as a start i'd suggest you consider using charts and pivot tables. chip pearson's site has a good section on pivot tables which may help. it's at http://www.cpearson.com/excel/pivots.htm.
    charts are pretty easy to create with the wizard and the help topic isn't bad. i know this is pretty general advice but it was a pretty general question you asked.


    On 2002-02-25 03:35, benkong2 wrote:
    Guess I did not ask this one correctly

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •