Setting Up a Database in Excel 2013

Learn how to create a simple database with Excel.

Introduction

• Welcome
• Using the exercise files

1. Database Design Concerns

• Design concepts for setting up large lists and restructuring downloaded data
• Recognizing problems

2. Tables

• Converting data into tables for enhanced visual appeal and content control
• 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 the validity of existing data

Conclusion

• Next steps