
All the plug ins and resources useful for analytics in excel
Essential concepts pertaining to time series and causal models that help apply in later sections
The Why and What of time-series forecasting
The basic concepts of time series
how to detect seasonality in excel
Why do we need decomposition - the business reasons behind change in behavior in each component
The implementation of breaking a time series dataset into trend, seasonality and irregularity.
Forecasting implementation in Excel
The Why of Causal models - quantifying cause effect relations in the business world
The problem statement for studying cause effect and then applying correlation
Implementing Regression
Interpreting Regression from an excel model
The Why of event impact and introduction to case study
Implementing the solution in the event impact case study
The Why of business simulations and how Monte Carlo fits
A sample implementation on deriving value of pi
The problem at hand a new business faces
How we take the decision to launch or to not launch through Monte Carlo Simulation
Welcome to Spreadsheet Modeling - the world where analytics meets our favorite tool, Microsoft Excel. Spreadsheets are used by executive and execution audience, they allow data storage, visualization, analysis as well as automations – and hence all aspects of modeling can be covered in MS Excel.
Whether you are an industry professional or student - this course is for you if want to make a mark in your field.
Business learning : Demonstration of effective decision like pricing, marketing spends, product launches using analytics. Whether we have enough or no data, established or new area – we have techniques to answer your questions.
Technically, you learn 4 predictive techniques : Time-series forecasting, Event impact analytics, Regression, Business simulations. We cover detailed theory, ponder over a case study and finally delve into the answers.
What you’ll learn
· Analytics and Data Science using Microsoft Excel
· Demonstration of effective decision making using analytics
· Predictive analytics and simulations
· Time-series forecasting, Event impact analytics, Regression, Business simulations
Are there any course requirements or prerequisites?
· Spreadsheet basics: Basic Excel concepts and formulae
· Basic logic aptitude
Who this course is for:
· Beginner to advanced in Analytics
· Beginner to advanced in Data Science
· Intermediate to advanced in Microsoft Excel
· Industry professionals looking to make effective business decisions