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

Excel Skills for Business: Intermediate I
Macquarie University via Coursera
Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera
Access 2016: Building Dashboards for Excel
LinkedIn Learning
Excel 2016: Setting Up a Database
LinkedIn Learning
Excel PivotTables: Mastering PivotTables and PivotCharts
LinkedIn Learning