Speaker Profile
ISAAC GOTTLIEB
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU, Rutgers and others in the US and other countries. In addition, he taught courses of Management Science and Statistics for Managers (always) using Excel. Over 100,000 students have attended his workshops and courses over the past 25 years. He received the Microsoft MVP – Most Valuable Professional – award for the years 2014-6. “A Microsoft Most Valuable Professional (MVP) is an award for individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.” (From Microsoft’s site.) Isaac Gottlieb has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands corporate professionals from leading multinational companies as well as small private business corporations. Among them are Johnson & Johnson, Merck, Pfizer, Procter & Gamble, Caterpillar, Vornado, El-Al Airlines, Microsoft, Intel, Boeing, NCR, Chrysler, Sealed Air, JPMorgan, Morgan Stanley, 3M, H-P, and the New York City Economic Development Corporation. He has an Excel-Tip-Of-The-Month newsletter that goes to over 35,000 recipients. Dr. Gottlieb has earned his PhD and two Masters Degrees from Columbia University Department of Industrial Engineering and Operations Research. He has more than 20 years of business and industry experience as a CEO of manufacturing companies and as a senior consultant.
Isaac Gottlieb
June 25 2024
01 : 00 PM EST
60 Minutes
The Data Ribbon and PivotTables
The workshop is based on the instructor’s recent book. “Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards”The objective of this workshop is to use the features of the data ribbon and the Pivot Table of Excel for what we call data mining. Using the process of extracting and discovering patterns..
Isaac Gottlieb
July 31 2024
01 : 00 PM EST
60 Minutes
Lookup functions and 3-D Excel file
Lookup tables are a good way to search for information and to return specific data relating to the information you introduce or look for. The Lookup function is a quick way to find the information one needs, and is particularly efficient when dealing with large databases that would be extremely time-consuming to search manually. So far, most spreadsheets people deal with use models with rows and columns onl..
Isaac Gottlieb
November 13 2024
01 : 00 PM EST
90 Minutes
Introduction to Excel's Built-In Solver – Advanced Decision-Making Tools
“Solver is a Microsoft Excel add-in program you can use for what-if analysis. Use Solver to find an optimal (maximum or minimum) value for a formula in one cell — called the objective cell — subject to constraints, or limits, on the values of other formula cells on a worksheet. Solver works with a group of cells, called decision variables or simply variable cells that are used in computing the formulas in t..
Isaac Gottlieb
December 17 2024
01 : 00 PM EST
60 Minutes
The Monte Carlo Simulations in Excel for Risky Investments
This workshop is about understanding what is behind the Monte Carlo Simulation. First, you will find out who is using simulations and for what purposes (risk analysis, operations, investments.) The next part is about having fun applying simulations - rolling dice on a spreadsheet. Once you understand how it is done we can go into a couple of projects. One project is when we simulate a four years budget for ..