Time Series Analysis with Excel
-
Speaker : ISAAC GOTTLIEB
-
When : Monday, September 09, 2024
-
Time : 01 : 00 PM EST
-
Add To Calendar
Refer a Friend
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU 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.
He mails Excel-Tip-Of-The-Month 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.
His two recent books are:
- Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards. Nov 2022.
- Management Science using Excel: Harnessing Excel's advanced features for business optimization. Aug 2023.
For understanding the data, we will use charts. Once you understand the data - we will cover Excel’s basic forecasting functions. Among the functions used will be SLOPE, INTERCEPT and RSQ (R-Square) echoing the trendline functions obtained from the charts’ features.
From there we move to simple techniques like Moving Average and Exponential Smoothing.
You will receive all the Excel files before the workshop – so that you can practice all these techniques during the workshop and on you own.
Areas Covered
- Excel Charts for data visualization
- Basic Excel Functions for Time Series Analysis
- Moving Average
- Exponential Smoothing and advanced Excel for forecasting functions
- Excel’s Forecast Sheet
Course Level - All Excel users that have small and large databases and have to find relationships that will help them forecast using the data
Who Should Attend
Any person who needs to forecast the future based on historical data
Why Should You Attend
Professionals or students who are using Excel:
- Have extensive databases of data and need to find the relationship you wish to use for forecasting
- You do know all the forecasting functions in Excel and you do need to perform the regression without using sophisticated tool
Topic Background
We will cover a variety of techniques to master time series analysis. Microsoft Excel is going to be used throughout the workshop. We will examine simple, intermediate, and advanced Time Analysis Series topics. Every example will have an Excel worksheet – so that the readers can follow and practice the examples on their own. This is a summary of the techniques used in the book chapter by chapter.
-
$160.00
-
