Lynda - Setting Up a Database in Excel 2013 | 304MB
Duration: 0h 49m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 44.1KHz 1ch
Genre: eLearning | Level: Intermediate | Language: English
Duration: 0h 49m | Video: AVC (.mp4) 1280x720 15fps | Audio: AAC 44.1KHz 1ch
Genre: 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.
* 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
* 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
No mirrors below please.