Excel 2016: Setting Up a Database

Learn how to create a simple and effective database using Microsoft Excel.

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.

Introduction

• Welcome
• Using the exercise files

1. Database Design Concerns

• Designing for large lists and restructuring data
• Recognizing problems

2. Tables

• Converting data into tables
• Using the Design tab to control table formatting
• Expanding tables automatically and adding totals
• Working with formulas in tables
• Using slicers to facilitate table filtering

3. Controlling the Creation of New Data

• Using the Form tool to build and view data
• Using data validation to restrict data entries
• Use validation tools to check validity

Conclusion

• Next steps