Are you good with excel?
826611
If the information in schools.xls is in more than one column (if the info includes the school name in one column, # of students in another, etc...) choose one value that doesn't have repeats.  School name would be a good choice.\n\nIsolate that information in one column, copy and paste if needed.\n\nIn the column directly to the right of your schools info, in the top cell, enter the follwing:\n\n=rand()\n\nThat will put a rand number between zero and one in that cell.  Double click on the box at the bottom right of the higlight to copy the formula down all of your data.  Then, choose the data menu, and sort...\n\nsort by the columnwith your rand om numbers, either ascending or descending.  Then take the first 30, 50, or 70.  In order to preserve randomness, after each set, hit f9 to refresh the random numbers and sort again.\n\nHope that's clear.\n\nTo be fair, the answer below this one is a bit simpler.  At the bottom of the tools menu, select Data Analysis.  Scroll down until you see sampling. Drag a box over the schools info, select random, and put n in for the number of samples.\n\nCan't win 'em all.  :)
868183
You don't need an expert to do this for you as someone has said. You do however need to steer away from Excel and start using a database. MySQL and PHP is probably the most user-friendly way of getting this done, but it will still require you to know a little of coding with MySQL and PHP...\n\nRawlyn.
103869
To be able to use a tool to accomplish a task, you need to know about the task.  Ignorance of the task is one fundamental problem that instructors trying to introduce the concept of functions have to face.\n\nA good way to do it is take up a task (say calculating interest), let them know the parameters involved (what we call variables in math).. and how the result is derived manually.  \n\nNow, if they are made to understand that excel/spreadsheet is a tool that would enable them to accomplish that same task .... may be they would be able to get along .....
855738
MS Excel has tons of great formulas.  Have you thought about using that.  Also, not sure what sort of database application you're using but formulas can usually be programmed into them.
1183061
If you're using Excel, Microsoft has tons on templates and one may work for you.
1032155
i am from www.excelgoodies.com. We do offer online excel training and consultancy.. if you are interested.. mail me at chennas@gmail.com
1020406
In Excel 2002, with the Analysis Toolpacks added, I come up with 423 functions. \n\nThere are as many formulas as you choose to write ;)
970192
I thought I was pretty handy with excel, but I have no idea what you're asking! Do you mean the options pop-up you get if you right-click on a cell? Or Insert > Function? (on the pull-down menu, or click on the 'fx' button just below your toolbar/s). Perhaps if you clarify your question you might get a more helpful answer than I feel I can give you.
167772
Please refre this page http://www.utexas.edu/its/training/handouts/excelgrade/\n\ngood luck..
86136
My first source has a walkthrough on how to use excel all though it lacks any screen shots. My second has some common and easy to use excel spreadsheets.
1182458
Are you asking for a cheat sheet?
739521
A fantastic place to look for excel answers is Google groups.\n\nFor programming you can follow this link:\n\nhttp://groups.google.com/group/microsoft.public.excel.programming\n\n\nYou can ask any question and within minutes to a couple hours your question will be answered.  If you have other questions on Excel just search for google groups excel and get tons of answers there on anything you EVER wanted to know about excel.  I had a problem I could not solve and asked my question. It was pretty complicated and withing 15 minutes I had my answer!!! I love that place for excel questions and answers!\n\nI guarantee you will be happy with the results
519316
i would say just practice up on using functions in columns and you will probably be fine
408909
Are you speaking of Microsoft Excel or just on paper or what?\n\nI can't answer again so E-MAIL me.\n\nnkpr25@yahoo.com\n\nor contact me through my site\n\nhttp://www.nkp25.co.nr
883420
=A1+B1 for cells \nand for columns you could do \n=SUM(A1:A10)\n\nrows could be \n=SUM(A1:f1)
366534
It completely depends on where you are using this formula, is it in Excel? A program? What language?\n\nWe need more info.
1064063
http://mrexcel.com/\n yep this the one only guy who knows how to make excel do anything he wants and you've dreamed of, as seen on G4/tech tv. he gves free info on site and free weekly email with tons of info. or go buy his many books they are easy to follow and wow never knew excel could do that will be said many times...