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:

Unleash the Power of Excel for Business Applications
 

2014 Excel Workshop Schedule:  
 

There is a limit of 70 seats for all workshops. 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:

Thursday, December 4, 2014 - Unleash the Power of Excel for Business Applications (2:00 - 4:00pm)


 

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