If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Options
Hi Everyone,
Using Excel 2003. I usually use excel to make forms (glorified word processing) I have recently started to paste data from an Access database tables, and queries into excel. I would like to know how I should set up my spreadsheet to show my data by month, quarter and then yearly. I want my report to show an average percent for the month of April, May, etc then other cells that show the percent per quarter. I don't necessarily need you to tell me how to do it step by step because I think it is going to be alot of steps. For right now, I have 2 sheets and on the one I have the data and the other is my report with the months listed and in the cell next to the month, I insert the average funciton then go back to my 1st sheet and manually select the dates for each month. I just need maybe some online examples of the reports excel can give and hopefully there will be tutorials to go with it that maybe automatically can select my months with one two swift clicks. I need basic excel info and not the visual basic or macro way to do it. Thanks, Linda |
#2
|
|||
|
|||
Report Options
I would suggest you create a pivot table. See this site for an overview and
even a video demonstration: http://www.contextures.com/CreatePivotTable.html Then see this site for help with arranging the pivot data grouped by months or quarters. http://www.contextures.com/xlPivot07.html -- Please remember to indicate when the post is answered so others can benefit from it later. "Linda RQ" wrote: Hi Everyone, Using Excel 2003. I usually use excel to make forms (glorified word processing) I have recently started to paste data from an Access database tables, and queries into excel. I would like to know how I should set up my spreadsheet to show my data by month, quarter and then yearly. I want my report to show an average percent for the month of April, May, etc then other cells that show the percent per quarter. I don't necessarily need you to tell me how to do it step by step because I think it is going to be alot of steps. For right now, I have 2 sheets and on the one I have the data and the other is my report with the months listed and in the cell next to the month, I insert the average funciton then go back to my 1st sheet and manually select the dates for each month. I just need maybe some online examples of the reports excel can give and hopefully there will be tutorials to go with it that maybe automatically can select my months with one two swift clicks. I need basic excel info and not the visual basic or macro way to do it. Thanks, Linda . |
#3
|
|||
|
|||
Report Options
Hi Linda,
....and you may benefit from my Excel Database Tutorial at http://edferrero.com/ExcelTutorials/...0/Default.aspx Ed Ferrero www.edferrero.com |
#4
|
|||
|
|||
Report Options
Thanks Ed and KC...It's snowin here so nobody came to work but me!....I
shoud have some "free" time later. Linda "Linda RQ" wrote in message ... Hi Everyone, Using Excel 2003. I usually use excel to make forms (glorified word processing) I have recently started to paste data from an Access database tables, and queries into excel. I would like to know how I should set up my spreadsheet to show my data by month, quarter and then yearly. I want my report to show an average percent for the month of April, May, etc then other cells that show the percent per quarter. I don't necessarily need you to tell me how to do it step by step because I think it is going to be alot of steps. For right now, I have 2 sheets and on the one I have the data and the other is my report with the months listed and in the cell next to the month, I insert the average funciton then go back to my 1st sheet and manually select the dates for each month. I just need maybe some online examples of the reports excel can give and hopefully there will be tutorials to go with it that maybe automatically can select my months with one two swift clicks. I need basic excel info and not the visual basic or macro way to do it. Thanks, Linda |
Thread Tools | |
Display Modes | |
|
|