Instructor: Isaac Gottlieb

Designed in collaboration with the NYU Stern Faculty, this workshop directly supports the skills essential for completing your Stern Core courses. The following topics will be covered: 

General Topics:
Naming Cells and Ranges
Data Validation

Lookup and Reference: 
Vlookup
Hlookup
Offset
Index
Match

Financial Functions:
NPV
IRR
PMT
RATE

Decision Making Analysis:
Data Table
Goal Seek

Optimizations:
Sumproduct
Excel solver add-in

Statistics/Data Mining:
Rand()
Norminv()
Building a histogram using data analysis add-in
Pivot tables