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.
|
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 & 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
 
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
↵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