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
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 listsConverting data into tablesWorking with formulasUsing slicers to facilitate table filteringUsing the Form tool to build and view dataUsing data validation to restrict data entries
(Buy premium account for maximum speed and resuming ability)
Посетители, находящиеся в группе Гости, не могут оставлять комментарии в данной новости.