YoVDO

Excel: Setting Up a Database (Office 365/Microsoft 365)

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 yet powerful database using Microsoft Excel. This course covers all the steps, from preparing data to using slicers to filter data.

Syllabus

Introduction
  • Managing data with Excel
1. Database Design Concerns
  • Set up large lists and restructure downloaded data
  • Recognize problems
2. Controlling the Creation of New Data
  • Use the Form tool to build and view data
  • Use Data Validation to control data entry values
3. Tables
  • Convert data into tables for enhanced visual and content control
  • Use the Design tab to control table formatting
  • Expand tables automatically and add totals
  • Work with formulas in tables
  • Use slicers to facilitate table filtering
Conclusion
  • Where to learn more

Taught by

Dennis Taylor

Related Courses

Introduction to Databases
Meta via Coursera
Datenmanagement mit SQL
openHPI
Intro to Relational Databases
Udacity
Using Databases with Python
University of Michigan via Coursera
.Net平台下的软件开发技术毕业项目
Xi'an Jiaotong University via Coursera