YoVDO

Setting Up a Database in Excel 2013

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Database Design Courses Data Management Courses Data Validation Courses Slicers Courses

Course Description

Overview

Learn how to create a simple database with Excel.

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

Related Courses

Rails with Active Record and Action Pack
Johns Hopkins University via Coursera
Excel Skills for Business: Intermediate II
Macquarie University via Coursera
Programming 103: Saving and Structuring Data
Raspberry Pi Foundation via FutureLearn
Everyday Excel, Part 1
University of Colorado Boulder via Coursera
Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera