Setting Up a Database in Excel 2013
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 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
- [Voiceover] 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.
Excel 2013: Data Validation in Depth59,572 Views
Excel 2013: Managing Multiple Worksheets and Workbooks95,727 Views
Cleaning Up Your Excel 2013 Data132,896 Views
Up and Running with Excel Cluster Analysis47,524 Views
Creating Excel Power Pivot and Power View Dashboards104,095 Views
Illustrator CC 2013 One-on-One: Fundamentals1,677,913 Views
Excel 2013 Essential Training6,264,406 Views
Access 2013 Essential Training2,706,153 Views
Excel 2013: Pivot Tables in Depth1,331,864 Views
Illustrator CC 2013 One-on-One: Mastery302,307 Views