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:
Excel I: For PC and MAC
Excel II: For PC and MAC
Excel Financial Tools: For PC & MAC
Speed Excel: For PC
2012-2013 Excel Workshop Schedule: Please click on your preferred date to register
There is a limit of 70 seats for all workshops. Seats are available on a first come, first serve basis.
Please note: You must cancel 48 hours in advance of the workshop date to receive a refund, by contacting MBA Academic Affairs, at academicaffairs@stern.nyu.edu.
Saturday, August 25, 2012 - Excel I: PC USERS (10:00am-1:00pm) LAUNCH
Sunday, September 30, 2012 - Excel I: PC and MAC USERS (10:00am-1:00pm)
Sunday, September 30, 2012 - Excel I: PC and MAC USERS (2:00pm-5:00pm)
Sunday, November 11, 2012 - Excel II: PC and MAC USERS (10:00am-1:00pm)
Sunday, November 11, 2012 Excel II: PC and MAC USERS (2:00pm-5:00pm)
Sunday, February 3, 2013 - Excel I: PC and MAC USERS (10:00am-1:00pm)
Sunday, February 3, 2013 - Excel I: PC and MAC USERS (2:00pm-5:00pm)
Sunday, March 3, 2013 - Excel II: PC and MAC USERS (10:00am-1:00pm)
Sunday, March 3, 2013 - Excel II: PC and MAC USERS (2:00pm-5:00pm)
Saturday, May 4, 2013 - Speed Excel for PC USERS (10:00am-12:00pm)
Saturday, May 4, 2013 - Excel Financial Tools for PC and MAC USERS (1:00pm-4:00pm)
Excel I (for PC & Mac Users)
Instructor: Isaac Gottlieb
Cost: $50, which will be assessed to students' bursar bill after the workshop
The workshop covers Excel 2010 for Windows and Excel 2011 for Mac and makes reference to all previous versions of Excel. Students must bring a laptop with a mouse to the workshop.
Topics covered will include:
| Excel Efficiency | Auto Fill | Selecting in Excel | Selecting a section |
| Selection shortcuts | Formulas, Functions and Addressing | Renaming Cells and Ranges | Simple Charts |
| Quick Chart | Creating a Chart using the Wizard | More about the Chart Wizard | Three Dimensional Charts - Column and Pie |
| Pie Charts | Conditional Formatting | IF Functions in Excel | Next IF Functions |
| Text Manipulation | Parsing | Functions | Simulation |
| Descriptive Statistics | Frequency Distributions | Data Analysis | Descriptive Statistics |
| Histogram | Regressions using Excel | Using the Chart Wizard | Linear Regression - Using Excel Functions |
Excel II Workshop Topics (for PC& Mac Users)
Instructor: Isaac Gottlieb
Cost: $50, which will be assessed to students' bursar bill after the workshop
The workshop covers Excel 2010 for Windows and Excel 2011 for Mac and makes reference to all previous versions of Excel. Students must bring a laptop with a mouse to the workshop.
Note: It is recommended that you take Excel I before registering for Excel II.
Topics covered will include:
| What-if Analysis | Goal Seek | Data Tables Sensitivity Analysis | Two Way Table |
| Using Scroll Bars for Sensitivity Analysis | Break-Even Analysis | Using the Data Table for the Break-Even-Point | Solver |
| Going the 3rd Dimension | Lookup Tables | Approximate Match Lookup | Exact Match Lookup |
| Sorting Data | Auto Filter | Data Forms | Grouping and Outlining Data |
| Subtotals | Pivot Tables |
Excel Financial Tools (for PC & Mac Users)
Instructor: Isaac Gottlieb
Cost: $50, which will be assessed to students' bursar bill after the workshop
This is a hands-on workshop that will guide students to apply various analytic financial decision-making models and tools using Excel. Students will gain practical experience with Excel financial functions, modeling and capabilities.
Topics covered will include:
| How financial functions work | Financial Modeling and how to apply it with What-If Sensitivity Analysis techniques | Using the solver for capital investment budgeting decisions | Monte Carlo (risk analysis) simulations |
Speed Excel (for PC Users)
Instructor: Albert Chen
Cost: $30, which will be assessed to students' bursar bill after the workshop
The main purpose of this workshop is to help students become faster in using the most commonly used Excel operations so more time can be spent on real analysis and strategy.
Topics covered will include:
| Moving around efficiently in a workbook and on a worksheet | Selecting ranges faster | Utilizing the popular paste special menu | Creating filters and customizing links |