Excel Workshops

These workshops are offered several times throughout the year, to provide MBA students with additional skills using the popular MS Excel program.

The instructor, Isaac Gottleib, has been teaching Excel workshops to MBA students at Stern and other top business schools for several years.  He also recently published a book designed for Analysts and MBAs on the use of Excel in Accounting and Financial Modeling.

Excel I Workshop

This workshop will be offered:

Saturday, October 3, 2009
Sunday, November 8, 2009
Saturday, February 6, 2010

Topics covered 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

This workshop will be offered:

Sunday, November 8, 2009

Topics covered 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