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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,793
Office Version
  1. 2019
Platform
  1. Windows
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:

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,218
Office Version
  1. 365
Platform
  1. Windows
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.:)
 

Watch MrExcel Video

Forum statistics

Threads
1,122,710
Messages
5,597,702
Members
414,164
Latest member
ARTW

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
Top