Overview
-
Learn how to create a simple database with Excel.
Syllabus
-
Introduction
- Welcome
- Using the exercise files
- Design concepts for setting up large lists and restructuring downloaded data
- Recognizing problems
- 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
- 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
- Next steps
