Viewers: in countries Watching now:
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.
Hi, I'm Dennis Taylor and welcome to Setting Up a Database in Excel 2013. In this course I'll show you the best techniques for structuring data efficiently and coherently, how to display your data as a table for enhanced visual and content control, and how to use the form feature for viewing data on a record by record basis. And I'll also show you the powerful data validation command, so you'll be assured that your data will be entered accurately and with speed, particularly with its powerful pick list technique.
So let's get started with Setting Up a Database in Excel 2013.
There are currently no FAQs about Setting Up a Database in Excel 2013.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.