最新消息:网盘下载利器JDownloader--|--发布资讯--|--站务--|--解压出错.密码问题--

Lynda – Setting Up a Database in Excel 2013

其他教程 007 0评论
Lynda - Setting Up a Database in Excel 2013

Lynda - Setting Up a Database in Excel 2013 | 304MB

Duration: 0h 49m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 44.1KHz 1chGenre: eLearning | Level: Intermediate | Language: English

Excel isn't just for flat files. You can use it to create a simple database and get even more insights into your data. Join author Dennis Taylor and learn how to create a simple database. The course explains the limits of Excel as a data-management tool and spells out the design considerations for creating a database with it. Dennis also shows how to simplify database creation with tables and manage data with the Form and Data Validation tools.

Topics include:

* Understanding database-design concerns like large lists
* Converting data into tables
* Working with formulas
* Using slicers to facilitate table filtering
* Using the Form tool to build and view data
* Using data validation to restrict data entries
Lynda - Setting Up a Database in Excel 2013
Download Firedrive and 百度云

以下隐藏内容只提供VIP赞助会员

sorry! The following hidden content sponsorship VIP members only.

您必须 登录 才能发表评论!

网友最新评论 (1)

  1. Excel的不只是用来创建平普通文件的。您可以使用它来创建一个简单的数据库,从而你可以对于数据处理有更多的了解。学习Dennis Taylor的课程,学习如何创建一个简单的数据库。课程解释excel成为一个数据管理工具的限制,阐述了创建一个数据库的设计考虑。丹尼斯还讲解了如何简化创建数据库表、管理数据和数据验证工具。
    sunsource(特殊组-翻译)2年前 (2014-07-04)