Introduction to Lookup Functions: Advanced Spreadsheets & Modeling | EdLight Code

Advanced Spreadsheets & ModelingIntroduction to Lookup Functions

9 / 12In progressIn progress

Advanced Spreadsheets & Modeling

Course Progress0/12

1

Multi-sheet Thinking

Understanding Multi-sheet Data
Explore a Multi-sheet Workbook

2

Data Modeling Basics

Keys and Relationships
Identify Keys in Data

3

Audit & Quality Checks

What Is a Data Audit?
Audit Data for Quality Issues

4

Executive Reporting

Building Executive Reports
Create Executive Report

5

Lookup Functions

Introduction to Lookup Functions
Use VLOOKUP to Find Values
Calculate Payroll with Lookups
Master INDEX + MATCH

Advanced Spreadsheets & Modeling

Course Progress0/12

1

Multi-sheet Thinking

Understanding Multi-sheet Data
Explore a Multi-sheet Workbook

2

Data Modeling Basics

Keys and Relationships
Identify Keys in Data

3

Audit & Quality Checks

What Is a Data Audit?
Audit Data for Quality Issues

4

Executive Reporting

Building Executive Reports
Create Executive Report

5

Lookup Functions

Introduction to Lookup Functions
Use VLOOKUP to Find Values
Calculate Payroll with Lookups
Master INDEX + MATCH

Loading lesson…

Loading lesson…