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 Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard