Setting Up a Database in Excel 2013
Setting Up a Database in Excel 2013
MP4 | Video: 720p | Duration: 49:17 | English | Subtitles: VTT | 194.6 MB
MP4 | Video: 720p | Duration: 49:17 | English | Subtitles: VTT | 194.6 MB
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