Excel instructor seeking good DEMO data sources

micklebt

New Member
Joined
Nov 25, 2009
Messages
6
Greetings all -

For some Excel courses I teach at the beginning and intermediate levels...

I am hoping to get some files with LARGE amounts of data to incorporate as teaching examples. Textbook data sets are usually woefully inadequate for instructing pivot table and database features in Excel (and Access).

Any help pointing me to online data sources, or if any of you folks are willing to share real data, would be greatly appreciated.

Regards,

Brian
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Well, the Northwinds database is part of Access installations, I thought ...
http://office.microsoft.com/en-us/access/HA010546951033.aspx

Other schemas are available but you might need sql server express to create the databases (not sure):
http://www.codeplex.com/MSFTDBProdSamples/
http://www.microsoft.com/sqlserver/2005/en/us/express-starter-schemas.aspx

I've not seen other sample databases - though sometimes they "come" with certain books.

I'm not sure I find you argument convincing as to the need for large amounts of data. The presence of 10 records or 1,000 records probably doesn't change the way you perform a function, or alter the fundamental concepts - except insofar as large datasets make some solutions impractical.

ξ
 
Last edited:
Upvote 0
Brian

Why not generate the data yourself?

It would probably only be a one time deal, mind you I've got to agree with xenou.

It's not the amount of data that's important it's how representative it is and how well it can be used to illustrate the functions/methods you want.:)
 
Upvote 0

Forum statistics

Threads
1,214,422
Messages
6,119,395
Members
448,891
Latest member
tpierce

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top