Excel 2016: Setting Up a Database

Learn how to create a simple yet powerful database using Microsoft Excel. This course covers all the steps, from preparing data to using slicers to filter data.

Introduction

• Managing data with Excel

1. Database Design Concerns

• Set up large lists and restructure downloaded data
• Recognize problems

2. Controlling the Creation of New Data

• Use the Form tool to build and view data
• Use Data Validation to control data entry values

3. Tables

• Convert data into tables for enhanced visual and content control
• Use the Design tab to control table formatting
• Expand tables automatically and add totals
• Work with formulas in tables
• Use slicers to facilitate table filtering

Conclusion

• Where to learn more