Excel II: Unleash the Power of Excel

Event Information

Share this event

Date and Time

Location

Location

44 West 4th Street

KMC 2-60

New York, NY 10012

View Map

Event description

Description

Instructor: Isaac Gottlieb

Designed in collaboration with NYU Stern Faculty, this workshop directly supports the skills needed in your NYU Stern classes. 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

Date and Time

Location

44 West 4th Street

KMC 2-60

New York, NY 10012

View Map

Save This Event

Event Saved