**If you or your organization are interested in booking a seminar or ****class with ****Dr. Isaac Gottlieb please fill out the form with your info .**

**We will get back to you with availability**

—————————————————————————————

———————————————————————————————-

**Participants’ Testimonials**

———————————————————————————–

**“I was fortunate enough to take a class from Dr. Gottlieb a few years ago during the “crash math course” week while getting an MBA at Columbia University. I don’t want to offend any of my esteemed professors, but those few hours with Dr. Gottlieb were probably more useful than several of my semester-long courses to me. I currently use Excel for 3-4 hours per day to analyze stocks at my hedge fund and his tips have saved me hours and helped to make my graphical representation of data look top-notch.”****“I would like to take the opportunity to give credit where credit is due. The two semesters of Operations Management that I took with you in 2002-2003 at Rutgers had a profound impact on my career. Three out of four of my certifications pictured below stem from those courses, which ignited my curiosity about Excel and its possibilities.****Since then I’ve learned the full accounting trade – tax, accounting, auditing, payroll, etc. – but developed a specialty in complex financial models for clients looking for bank, angel, or venture capital to start or expand a business. I also teach courses and seminars on Excel and other business technologies. Whether I’m teaching or learning, I think of you every time I use or teach some really cool Excel tool.”****I have taken Isaac Gottlieb’s MBA Excel course twice. I didn’t / couldn’t get enough the first time; it was just too fast-paced to get it all in one two-day event. I enjoy Isaac’s Excel Tip-of-the-Month newsletters, but I rarely get time to regularly read them when they arrive. This new book is a very carefully organized, easy to read practice manual designed to get most mid-level Excel users to near-Wizard status.****I considered myself very good with Excel, then I took a course by Dr. Gottlieb at Temple and was proven wrong. This class was worth my entire MBA tuition. Since taking it, I have become significantly more productive at work by using his tips for efficiency. After the course, I bought this book to help remind myself of things I didn’t fully absorb in the class and it is equally helpful**

** **

**Over 25,000 students and professionals have taken this class with me over the last 15 years at Columbia, NYU and other universities as well as in other companies. I have written a book that covers this material.**

———————————————————————

**Typical Workshop Outline**

**PART 1 Introduction**

1.1 Excel Efficiency

1.1.1 Auto Fill

1.1.2 Selecting in Excel

1.1.3 Formulas, Functions and Addressing

1.2 Renaming Cells and Ranges

1.3 Simple & Quick Charts

1.3. Advanced Charting techniques

1.4. Sparklines

**PART 2 If functions Text & AutoFill**

2.1 IF Functions in Excel

2.2 Nested if– Payroll Example

2.3 Text manipulation

2.4 Auto-fill and simulations

** **

**PART 3 Statistics for non-statisticians **

3.1 Descriptive statistics

3.2 Frequency Distributions

3.3 Data Analysis.

3.4 Histograms

3.5 Regressions Using Excel and Excel Charts

** **

**PART 4 What IF Analysis & Sensitivity Analysis**

4.1 What-if Analysis

4.2 Goal Seek

4.3 Data Tables Sensitivity Analysis

4.4 Two Way Tables

4.5 Using Scroll Bars for Sensitivity Analysis

4.6 One More Example: Break-Even-Analysis and animating charts

** **

**PART 5 3D and Lookup**

5.1 Going the 3rd Dimension

5.1.1 A Payroll Example

5.1.2 A Second Example Inventory

5.2 Lookup Tables

5.2.1 Approximate Match Lookup

5.2.2 An Exact Match Lookup

** **

**PART 6 Data and Data Mining**

6.1 Sorting Data

6.2 Auto Filter

6.3 Data Forms

6.4 Grouping and Outlining Data

6.5 Subtotals

6.6 Pivot Tables and PivotTable Examples

6.6.1 Simple Pivot Tables

6.6.2 Advance Pivot Tables and Data Mining

6.6.3 Pivot Table Slicers

**PART **7 **Optional** Topics

7.1 Solver

7.2 Monte Carlos Simulation Risk

7.3 More Finance

7.3.1 Amortization tables

7.3.2 NPV and IRR, and advanced Excel financial function (XNPV, XIRR)

# Part 8 Summary Case Study

**Based on my book: Next Generation Excel +Website: Modeling In Excel For Analysts And MBAs (For MS Windows And Mac OS) (Wiley Finance)**

**(Hardcover)**, March 2013. Isaac Gottlieb. See Next Generation Excel

# Excel Financial Tools

** **

**Dr. Isaac Gottlieb**

*Author of Next Generation Excel: Modeling In Excel*

For Analysts And MBAs, 2nd Edition, March 2013

** **

This workshop is to give you a hands-on, practical experience

with Excel financial functions, modeling and capabilities.

**Understanding How Financial Functions work (1, time value of money, IRR & NPV, compare investments) **

PV- calculates the total amount that a future investment is worth currently

RATE- is used to calculate the interest applied on a loan or an investment.

NPV- uses a series of cash flows to calculate the present value of an investment

IRR – is used to calculate an internal rate of return based on a series of cash flows

**Sample Depreciation Functions (depreciation)**

SLN- Returns the straight-line depreciation of an asset for one period

SYD- Returns the sum-of-years’ digits depreciation of an asset for a specified period

**Loans and Amortization Tables (Amortization)**

PMT- is used to calculate the regular payment of loan or an investment

PPMT- calculates the actual amount that applies to the balance of the loan. This is referred to as the principal

IPMT- calculates the amount paid as interest for a period of a loan or an investment

Building Amortization Tables

**Using the Excel Data Table to Create Financial Tables and Charts (2, Data Table)**

** **Data Table

Goal Seek

Charts

*Apartment building Case study*

**Advanced Excel financial function (XIRR and XNPV)**

XNPV- Returns the net present value for a schedule of cash flows that is not necessarily periodic

XIRR- Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic

**Monte Carlos Simulations using Excel **

How to uses Monte Carlo simulation

RAND() and how to utilize it with different probability distribution functions:

Simulating discrete and normal random variables

*Simulation Risk Analysis Case study*

**Solver and Finance (intro solver, capital budget)**

** **Using the Solver to choose among capital investment projects

*Investment Case study*

* *

**Example of the Monte Carlo Simulation**

You will be able to simulate risk using Excel. Many corporations use Monte Carlo simulation as an important tool for decision-making. For examples read on the Microsoft site.

In this workshop you will learn how to assess the risk components to an uncertain investment. In the example below I took a four year project and simulated its uncertain ROI for 1,000 times (4x 1,000 years).

The basic model did not account for risk. Using the simulations – you can find the risk profile of you investment. You will generate statistics about the ROU and chart the risk profile. The expected value is $12,455 – but you can calculate that the probability of losing money to be about 26%.

The results of simulating the budget for 1,000 times