NYU Stern Logo
Academic Affairs
NYU Stern

Excel Workshops

Workshops are offered several times throughout the year to provide MBA students with additional skills using the popular MS Excel program.
 

Workshops currently offered:

The Power of Excel for Business Applications
 

2015 Excel Workshop Schedule:  
 

There is a limit of 70 seats for each workshop session. Seats are available on a first come, first served basis.
Please note: You must cancel 48 hours in advance of the workshop date by contacting Academic Affairs and Advising (academicaffairs@stern.nyu.edu).

Select a date from the list below in order to register a workshop:

There are currently no Excel Workshops scheduled for Spring 2015. Please check back in the future for an updated Excel Workshop schedule.

 

Unleash the Power of Excel for Business Applications

Instructor: Isaac Gottlieb
Cost: Free

In collaboration with the NYU Stern Faculty, we have designed an Intermediate Excel Workshop directly supports the skills essential for completing your Stern Core courses. The following topics will be discussed: 

General Topics:
- Naming Cells and Ranges
- Conditional Formatting
- Data Validation

Lookup and Reference: 
- Vlookup
- Hlookup
- Offset
- Index
- Match

Financial Functions:
- NPV
- IRR
- PMT
- RATE

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