Learn to create your own forecasts with Excel: trends, cyclic data, forecast intervals and more! The classic techniques to have for any analytics professional
Key Features
Use and apply all the Excel forecasting functions to real data to create forecasts Learn statistical tools to implement time-series methods using real life examples Develop models and find patterns to create visualizations using Excel
Book DescriptionThis book focuses on Time Series Analysis: forecasting future behavior of data based on historical numerical statistics. Historical data may take all kinds of patterns, like conventional straight-line data, cyclical, exponential, special events, or other trends. Professional analysts are usually looking for tools and techniques to be able to solve these problems, whether simple or complicated You will explore the basics of time-series analysis using Excel and learn the foundation you need to build forecasting models. You will learn how to preprocess raw time-series data, clean, manipulate, and prepare the data with Excels tools designated for it. You will analyze data using Excels designated forecasting function, the Analysis ToolPak for regression analysis and Forecast Sheet. You will be able to use the powerful data visualization tools of Excel including the PowerPivot Charts and dashboard. The book then utilizes classical forecasting models such as time-series regressions, exponential smoothing, and ARIMA models. You'll also utilize sophisticated tools like Monte Carlos simulations and Sensitivity Analysis By the end of this book, you will have acquired the skills necessary to explore data, identify its patterns, and build a forecasting model using the various traditional techniques and unique Excel forecasting featureWhat you will learn
Recognize data's trends and structure that will help you choose the right forecasting tools. Use charts for data visualization, trend and fitting mathematical function to data on a chart. Use Excel to analyze data and time series analysis to predict the future based on historical data. Apply Moving Averages and Exponential Smoothing for predicting the future with historical data. Use the Excel new Forecast Sheet feature. Use the Excel Regression Analysis in the Analysis ToolPak and single and multi-regressions. Apply PivotTables and PivotCharts to analyze data for forecasting and preparing Dashbords.
Who this book is forThis book is ideal for data analysts, business analysts, data scientists, and the professionals who are looking to perform time series analysis and forecasting using Microsoft Excel. A basic knowledge of statistics is required; some knowledge in Microsoft Excel is expected
