Included Exercise Files
Language : English
Released : 5/24/2018
Size : 180,15 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 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
