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

LinkedIn Learning

Excel 2016: Setting Up a Database

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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.

Syllabus

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

Taught by

Dennis Taylor

Reviews

Start your review of Excel 2016: Setting Up a Database

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.