Excel: Setting Up a Database (Office 365/Microsoft 365)
Offered By: LinkedIn Learning
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
- Set up large lists and restructure downloaded data
- Recognize problems
- Use the Form tool to build and view data
- Use Data Validation to control data entry values
- 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
- Where to learn more
Taught by
Dennis Taylor
Related Courses
Introduction to DatabasesMeta 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