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
Rails with Active Record and Action PackJohns Hopkins University via Coursera Excel Skills for Business: Intermediate II
Macquarie University via Coursera Programming 103: Saving and Structuring Data
Raspberry Pi Foundation via FutureLearn Everyday Excel, Part 1
University of Colorado Boulder via Coursera Creating Dashboards in Google Spreadsheets
Coursera Project Network via Coursera