Week 11: Nov 19-23
Modeling and databases - MS Excel 2019
Learning objectives:
- Understand the concept of a database in Excel: Explain what a database is and how it can be used to store and organize large amounts of data.
- Learn how to create a database in Excel: Demonstrate the process of setting up a database in Excel, including creating column headers and entering data in rows.
- Understand the Basic Structure of Excel Formulas.
- Create Basic Formulas.
Introduction to formulas
Classroom activity