EXCEL...i am working on a survey....how can i create DYNAMIC TABLES for tabulating results?
953414
Pivot tables, then refresh the data when necessary. You may have the data automatically refresh upon entry. Rather than copy all of the EXCEL help files here, go there and type in "pivot tables".
2121
I haven't used SPSS in about 8 months, but from what I remember you simply need to label your variables along the top of the spreadsheet. You can define these variables by clicking on the other view (bottom left). Then you can state more clearly what each variable measures as well as get rid of obnoxious decimals if needed. You can also make it so that you can use "1" and "2" to mean things like male and female and have the words show up in the data list instead. Then, once you have it all set up, you simply need to enter the data you have collected into the right spot in the spreadsheet.
550410
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
1005550
Use excel, somewhat easy and really organized
747609
Ignore the Excel help; it's rubbish. Try this: http://www.cpearson.com/excel/pivots.htm
1097486
A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet.\n\n\nBelow is a webpage that has a great example...seems to make it easy to understand.
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
25554
I guess you wanted to say "how do you use..."\n\nAccess is better do design database interface with windows and buttons. Create a new database using one of templates and study it's setup.\n\nExcel is just a spreadsheet, but if your arrange your data in columns with a header row, you can use some Data menu to filter it, or such functions as VLOOKUP, MATCH, INDEX, COUNTIF, SUMIF to do some database-like things to the data.\n\nNow give me the best answer - you get points for that too.
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
182799
Sas will do it for you.\n\nHere is the article:\nhttp://support.sas.com/techsup/technote/ts498.html\n\nIf you know visual basic (and you can do this from excel using VBA) here is some code for generating combinations:\n\nhttp://www.codeguru.com/vb/gen/vb_misc/algorithms/article.php/c5607/
234098
NO! Not technically.\n\nA database has to have fixed number of named columns. Spreadsheet has a open stucture.
926728
First you would have to create an extra column to have the range in it:\n\nName IQ Range\n---------------------\nJohn 110 100-130 \nRick 120 100-130 \nMary 140 130-160 \nJean 170 160-220 \nToby 210 160-220 \n\nTo put the data in that new columns you can use UPDATE statements like this:\n\nUPDATE Table SET Range = '100-130' WHERE IQ >= 100 AND IQ < 130\n\nThen you can do a select statement with a group by to get the results you want:\n\nSELECT  Range, Count(*) FROM Table\nGROUP BY Range
957828
Just open it with Excel.  It will automatically populate the columns.\n-MM
659348
next to insert table button on the standard toolbar you have insert microsoft excel sheet button. click and drag the number of rows and columns you need.
791232
A Pivot Table is a flexible tool for displaying data; it allows the user to re-arrange the data in a variety of different ways. Instead of trying to anticipate every possible tabulation of the data which might be useful to any reader of a report and generating it for inclusion in a paper report, you can put a flexible summary of the data in a file and let the user decide what to look at from which perspective. If you want to look at a different tabulation a month after the initial analysis, you can just re-open the Pivot Table and drag variables around to create a new view. Since Pivot Tables are data structures in files, they are convenient to send as e-mail attachments to anyone who has a copy of Excel. \n\nhope that helps, management science :)
50467
Microsoft Excel should be sufficeint for a lab report.  Excel can also make graphs from the table data.
224631
By UI page i think you mean form?  Don't read on if not.\n\nRight you can either pull the data based on the results of a combobox (drop down menu) on a form, or have it load a report.\n\nCreate a blank form\nCreate a combobox(the drop down box) based on the table field you want to select data on. (you will need to use a query and use the 'Totals' option to specify 'group by')\nChange the 'afterupdate' event found in the properties to [event procedure], click on the button next to this to edit the event.  It should load up a code editor.  Type the following where the insertion point is: me.requery\n\nNext create a query that uses your forms combobox control as  criteria (in a where clause) to select the filtered data from your table (to refer to a form control-> FORMS!MYFORM!MYCOMBO)\nCreate a form or report based on this query.\n\nAdd the second form to your first form, or add a button that links to the report.\nWithout pictures that is the best i can do.  Ask if you want me to attempt to expand on anything.