A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report Options



 
 
Thread Tools Display Modes
  #1  
Old February 8th, 2010, 08:51 PM posted to microsoft.public.excel.newusers
Linda RQ[_2_]
external usenet poster
 
Posts: 76
Default 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  
Old February 8th, 2010, 09:54 PM posted to microsoft.public.excel.newusers
KC hotmail com>
external usenet poster
 
Posts: 57
Default 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  
Old February 9th, 2010, 07:01 AM posted to microsoft.public.excel.newusers
Ed Ferrero[_3_]
external usenet poster
 
Posts: 102
Default 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  
Old February 9th, 2010, 04:36 PM posted to microsoft.public.excel.newusers
Linda RQ[_2_]
external usenet poster
 
Posts: 76
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.