Useful Excel Spreadsheets (97)

Topic

New Reply

Greetings!

Does anyone have any good resources for useful Excel Spreadsheets? Preferrably pre-created spreadsheets that I wouldn’t have to modify too much? I’m putting together a class, and would like to demonstrate first hand the types of things you can do with excel,

I’m looking for some budgeting spreadsheets, perhaps a grocery list, or mileage spreadsheet.. There has to be a site out there that has these en-masse, but I can’t seem to find it, any ideas?

Thanks!

Reply | Quote

Replies

Drk,

You might try the U. S. CENSUS. There is some data here on population growth that is recent but you would have to build up your own VLOOKUP, etc. functions.

http://www.census.gov/population/www/cen2000/respop.html

Hope this helps.

Reply | Quote

Do you have an old copy of the “underground guide to Excel”? No precreated spreadsheets – but a lot of excellent examples of what a spreadsheet could be used for. Um, maybe it is the same in Excel Annoyances but I never got around to picking up a copy….

Reply | Quote

Don’t have that..

Ideally, I’d find a site much like a shareware site, or otherwise, that lists excel spreadsheets in the same manner…

I’ve used Excel for many things, but just about found myself clueless when a user asked, “Just what in the world would I use Excel for?”

Thanks!

Reply | Quote

Why didn’t you give your use of Excel as examples? What about invoicing, financial modeling, forecasting, time sheets, etc., etc.???

Reply | Quote

Thank you all for the responses!

Thankfully, I was able to locate some very good resources, I thought it would be nice of me to share them with you all..

J-Walk Files & Links
Winsite Files

All of these are outlined on the attached spreadsheet, which I offered as a supplement to my course, I hope you find it helpful!

Reply | Quote

I had to design & implement a basic excel training course a few years ago. I’m in the reinsurance industry, so it’s a bit tailored for that, but it’s all quite basic. Unfortunately i couldn’t find the Word document that lists what to do in what order.

I’ve attached a ZIp file – hope this helps

PS

All figures are fictitious etc etc.

Reply | Quote

I’ve been teaching Excel recently and have quite a ‘fun’ idea. What about recording spot heights (contour heights) over and area then using the surface map to create a 3D relief map of your local area?

A bit different to the norm I think?

Bob

Reply | Quote

How about tax forms (e.g.,http://tax.state.nv.us/)
American Institute of Architects documents (e.g., http://depts.washington.edu/cmweb/cero/ — document G702 is interesting)
Forecasting (e.g.,http://lacher.com/examples/lacher44.htm)
Aaron’s Mindsweeper or Room Design programs? (e.g., http://geocities.com/aaronblood/pages/games.html)

and on and on and on…
Edited to add hyperlinks – WebGenii

Reply | Quote

Hi:

Unfortunately, I don’t have any spreadsheets I can send you – bcs the info is either work proprietary, personal, or not mine. But the kind of things I use Excel for are:
– analyze business cases for new products/services (clearly work). These usually involve 20-30 sheets but could, for a simple quick analysis, be 5 sheets.
– tax returns, with one sheet per schedule/form (US and state) – too cheap to buy the tax program every year, especially since it doesn’t change a lot
– teachers use for grade tracking (I had a post in early-mid Aug on charting for showing grades)
– analysis of potential divorce settlements (yuk)
– my daughter was using excel for tracking experimental observations
– a friend tracks software problems and resolutions

fred

Reply | Quote