Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Setting Up a Database in Excel 2013

via LinkedIn Learning

Overview

Syllabus

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

Taught by

Dennis Taylor

Reviews

Start your review of Setting Up a Database in Excel 2013

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.