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
- Monday, February 1st 2016
- PowerPoint Design Basics
- Monday, February 22nd, 2016
- 5:30PM - 6:30PM
- KMC 2-60
- Monday, February 22nd, 2016
- Excel 1: Excel Basics for Business Applications
- Friday, February 26th, 2016 - Rescheduled
- 9:00 AM - 12:00 PM
- Location: KMC 2-60
- Friday, February 26th, 2016 - Rescheduled
- PowerPoint Design Basics
- Tuesday, March 1st, 2016
- 5:30PM - 6:30PM
- Location: 3-60
- Tuesday, March 1st, 2016
- Excel 2: Unleash the Power of Excel
- Sunday, April 17th, 2016
- 9:00 AM - 12:00PM
- Location: 2-60
- Sunday, April 17th, 2016
Recent Academic Workshop Topic Lists
Below, please find a list of the topics covered during each academic workshop session.
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:
Statistics Using Excel:
Data Menu:
IF Functions in Excel
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
- Simple & Quick Charts
- Advanced Charting techniques
- Sparklines
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
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:
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
- Vlookup
- Hlookup
- Offset
- Index
- Match
- NPV
- IRR
- PMT
- RATE
- Data Table
- Goal Seek
- Sumproduct
- Excel solver add-in
- Rand()
- Norminv()
- Building a histogram using data analysis add-in
- Pivot tables
↵Instructor: Katelyn Lemay
Topics that will be covered in the workshop include:
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