## Academic Workshops

## Academic Workshops are offered several times throughout the year to provide MBA students with skills to complement their business education.

###
Fall 2016 Workshop Schedule

Please check back soon for our Fall 2016 offerings!

### Previous Workshops

- Financial Calculator Workshop
- Monday, February 1st 2016
- 12:00pm-1:30pm
- Location: KMC 3-65
- Monday, February 8th 2016
- 12:00pm-1:30pm
- Location: KMC 3-65
- PowerPoint Design Basics
- Monday, February 22nd, 2016
- 5:30PM - 6:30PM
- KMC 2-60
- Excel 1: Excel Basics for Business Applications
- Friday, February 26th, 2016 - Rescheduled
- 9:00 AM - 12:00 PM
- Location: KMC 2-60
- PowerPoint Design Basics
- Tuesday, March 1st, 2016
- 5:30PM - 6:30PM
- Location: 3-60
- Excel 2: Unleash the Power of Excel
- Sunday, April 17th, 2016
- 9:00 AM - 12:00PM
- Location: 2-60

Please note: You must cancel 48 hours in advance of the workshop date by contacting Academic Affairs and Advising (<academicaffairs@stern.nyu.edu>).

##  Recent Academic Workshop Topic Lists

Below, please find a list of the topics covered during each academic workshop session.

Show All | Hide All

Excel 1: Excel Basics for Business Applications  Instructor: Isaac Gottlieb

This workshop is designed to give students a strong foundation in the basics of Microsoft Excel for business applications. The following topics will be covered:

**Excel Basics and Efficiency:**- Auto Fill
- Selecting in Excel
- Formulas, Functions, and Addressing
- Renaming Cells and Ranges
- Conditional Formatting

**Charts:**- Simple &amp; Quick Charts
- Advanced Charting techniques
- Sparklines

**Text to Columns

Statistics Using Excel:**- Descriptive Statistics
- Frequency Distributions
- Data Analysis
- Histograms
- Regressing Using Excel and Excel Charts

**Data Menu:**- Sorting Data
- Auto Filter
- Grouping and Outlining Data
- Subtotals

**IF Functions in Excel**

Excel 2: Unleash the Power of Excel for Business Applications  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

PowerPoint Design Basics  ↵Instructor: Katelyn Lemay

Topics that will be covered in the workshop include: - How to plan an effective presentation with PowerPoint
- What makes a good presentation and some common pitfalls
- Organizing your content effectively in your PowerPoint presentation
- Design principles and best practices for PowerPoint
- Using images, charts, graphs, videos, and animation purposefully
- Create visually appealing, informative visuals to enhance your presentation
- Using background color, font size, and layout to make your slides more legible - and effective
- Additional resources and tutorials