在Excel中使用的样本数据

If you're doing Excel training, or writing blog posts, or creating sample files, you might need to find some public sample data to use in Excel files. Here are a few sources to check.

如果您正在进行Excel培训，撰写博客文章或创建示例文件，则可能需要查找一些公共示例数据以在Excel文件中使用。 这里有一些要检查的资源。

Google Public Data Explorer (Google Public Data Explorer)

Sometimes you need sample data, because you don't want to publish confidential client data, even if it's a bit disguised, or reveal your household finances to the world.

有时您需要样本数据，因为您不想发布机密的客户数据(即使有些伪装了)，也不想向全世界透露您的家庭财务状况。

Instead of creating sample data on your own, you can find datasets online.

您可以在线查找数据集，而不必自己创建样本数据。

Once source is Google Public Data Explorer (part of Google Labs), where you can access several large datasets, and use those in your Excel example files

来源是Google Public Data Explorer (属于Google Labs的一部分)，您可以在其中访问多个大型数据集，并在Excel示例文件中使用这些数据集

When you follow the links to the dataset pages, you'll find interactive charts and maps, and links to the source data websites.

当您点击到数据集页面的链接时，您将找到交互式图表和地图，以及到源数据网站的链接。

源数据页 (Source Data Pages)

Of course, each source data website is set up differently, but on some of the source data websites, you'll find more charts and interactive tables, and files that you can download.

当然，每个源数据网站的设置都不同，但是在某些源数据网站上，您会发现更多的图表和交互式表格以及可以下载的文件。

样本Excel数据下载 (Sample Excel Data for Download)

For example, you can download Excel files with economic, environmental and social statistics from the OECD Factbook 2010, published by the Organization for Economic Co-operation and Development.

例如，您可以从经济合作与发展组织( OECD)发布的OECD Factbook 2010中下载包含经济，环境和社会统计数据的Excel文件。

To see how it worked, I downloaded an Employment rates file with several years of data, for three age groupings. That would give you enough data to use for your own sample charts or training exercises.

为了了解它的工作原理，我下载了一个就业率文件，其中包含了三个年龄组的数年数据。 这将为您提供足够的数据以用于您自己的样本图或培训练习。

其他数据源 (Other Data Sources)

Are there other good sources of public data that you use? Please share them in the comments. Thanks!

您还有其他良好的公共数据来源吗？ 请在评论中分享。 谢谢！

Update: Check the comments below -- there are other excellent resources listed, where you can find sample data to use in Excel. ______

更新 ：检查下面的评论-列出了其他出色的资源，您可以在其中找到要在Excel中使用的示例数据。 ______

翻译自: https://contexturesblog.com/archives/2010/07/21/sample-data-to-use-in-excel/