Excel sales forecasting for dummies /
| Main Author: | |
|---|---|
| Corporate Author: | |
| Format: | eBook |
| Language: | English |
| Published: |
Hoboken, NJ :
John Wiley & Sons, Inc.,
[2016]
|
| Edition: | 2nd edition. |
| Series: | --For dummies.
|
| Subjects: | |
| Online Access: | Connect to the full text of this electronic book |
Table of Contents:
- ""Title""; ""Contents""; ""Introduction""; ""About This Book""; ""Foolish Assumptions""; ""How to Use This Book""; ""How This Book Is Organized""; ""Icons Used in This Book""; ""Where to Go from Here""; ""Part I : Understanding Sales Forecasting and How Excel Can Help""; ""Chapter 1: A Forecasting Overview""; ""Understanding Excel Forecasts""; ""Getting the Data Ready""; ""Making Basic Forecasts""; ""Charting Your Data""; ""Forecasting with Advanced Tools""; ""Chapter 2: Forecasting: The Basic Issues""; ""Why Forecast?""; ""Talking the Talk: Basic Forecasting Lingo""
- ""Understanding the Baseline""""Setting Up Your Forecast""; ""Using Your Revenue and Cost Data""; ""Chapter 3: Understanding Baselines""; ""Using Qualitative Data""; ""Recovering from Mistakes in Sales Forecasting""; ""Recognizing Trends and Seasons""; ""Chapter 4: Predicting the Future: Why Forecasting Works""; ""Understanding Trends""; ""Matchmaker, Matchmaker: Finding Relationships in the Data""; ""Part II : Organizing the Data""; ""Chapter 5: Choosing Your Data: How to Get a Good Baseline""; ""Early to Bed: Getting Your Figures in Order""
- ""Staying Inside the Lines: Why Time Periods Matter""""Spacing Time Periods Equally""; ""Chapter 6: Setting Up Lists in Excel""; ""Understanding List Structures""; ""The List Command""; ""Filtering Lists""; ""Importing Data from a Database to an Excel List""; ""Chapter 7: Working with Lists in Excel""; ""Turning Lists into Charts""; ""Using the Analysis ToolPak with Lists""; ""Avoiding the Analysis ToolPakâß"s Traps""; ""Part III : Making a Basic Forecast""; ""Chapter 8: Summarizing Sales Data with Pivot Tables""; ""Understanding Pivot Tables""; ""Building the Pivot Table""
- ""Grouping Records""""Avoiding Grief in Excel Pivot Tables""; ""Chapter 9: Charting Your Baseline: Itâß"s a Good Idea""; ""Digging Into a Baseline""; ""Making Your Data Dance with Pivot Charts""; ""Using Two Value Axes""; ""Chapter 10: Forecasting with Excelâß"s Analysis ToolPak""; ""Installing Add-Ins""; ""Using Moving Averages""; ""Using Exponential Smoothing""; ""Using the Regression Tool""; ""Chapter 11: Basing Forecasts on Regression""; ""Deciding to Use the Regression Tool""; ""Understanding the Analysis ToolPakâß"s Regression Tool""; ""Using Multiple Regression""
- ""Part IV : Making Advanced Forecasts""""Chapter 12: Entering the Formulas Yourself""; ""About Excel Formulas""; ""Using Insert Function""; ""Understanding Array Formulas""; ""Using the Regression Functions""; ""Chapter 13: Using Moving Averages""; ""Choosing the Length of the Moving Average""; ""Reacting Quickly versus Modeling Noise""; ""Using the Analysis ToolPak to Get Moving Averages""; ""Chapter 14: Evaluating a Moving Average""; ""Losing Early Averages""; ""Understanding Correlation""; ""Understanding Autocorrelation""; ""Chapter 15: Smoothing: How You Profit from Your Mistakes""