Setting Up a Database in Excel 2013
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to create a simple database with Excel.
Syllabus
Introduction
- Welcome
- Using the exercise files
- Design concepts for setting up large lists and restructuring downloaded data
- Recognizing problems
- 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
- 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
- Next steps
Taught by
Dennis Taylor
Related Courses
Excel Skills for Business: Intermediate IMacquarie 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