USIU Challenge Yourself 9.4 Jordan Robertson
Challenge Yourself 9.4
In this project, you will use data validation to identify missing and incorrect data. You will create a summary worksheet to consolidate data about vaccine shipments, and then you will import data from the Vaccines Access database and manipulate the data.
Skills needed to complete this project:
- Adding Data Validation
- Working with Comments
- Protecting Worksheets and Workbooks from Changes
- Creating a Drop-Down List for Data Entry
- Inserting Hyperlinks
- Consolidating Data in a Summary Worksheet
- Converting Data to Columns
- Importing Data from Access
Checking for Compatibility with Previous