Overview
-
Learn how to build simple databases in Microsoft Excel, and format, validate, search, and analyze data with Excel's powerful data manipulation features.
Syllabus
-
Introduction
- Welcome
- The database clinic series
- What you should know
- Use the exercise files
- A brief overview of Excel
- Strengths and weaknesses of Excel
- Database creation
- An overview of database creation in Excel
- Create a database in Excel
- Insights on database creation in Excel
- Join datasets
- An overview of joining datasets in Excel
- Join two datasets in Excel
- Insights on joining datasets in Excel
- Search a database
- An overview of searching in Excel
- Search a database in Excel
- Insights on searching in Excel
- CRUD operations
- An overview of CRUD operations in Excel
- Import text into Excel
- Clean text in Excel
- Format text in Excel
- Insights on CRUD operations in Excel
- Calculations
- An overview of calculations in Excel
- Create a pivot table from two data sources
- Calculate cohort percentages in Excel
- Extrapolate population data in Excel
- Insights calculations in Excel
- Next steps
