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 instructor Dennis Taylor and learn how to create a simple database. Dennis explains the key strengths of Excel as a data-management tool—and what it can and can't do—and spells out the design considerations you'll want to keep in mind as you create your database. Dennis also shows how to simplify database creation with tables and manage data with the built-in 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