Overview

Full Product Details

Author:   Conrad Carlberg ,  Mike Alexander
Publisher:   John Wiley & Sons Inc
Imprint:   For Dummies
Edition:   2nd edition
Dimensions:   Width: 18.80cm , Height: 2.00cm , Length: 23.60cm
Weight:   0.531kg
ISBN:  

9781119291428

ISBN 10:   1119291429
Pages:   416
Publication Date:   23 August 2016
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   In stock  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

Introduction 1 Part 1: Understanding Sales Forecasting and How Excel Can Help 5 CHAPTER 1: A Forecasting Overview 7 CHAPTER 2: Forecasting: The Basic Issues 23 CHAPTER 3: Understanding Baselines 41 CHAPTER 4: Predicting the Future: Why Forecasting Works 53 Part 2: Organizing the Data 69 CHAPTER 5: Choosing Your Data: How to Get a Good Baseline 71 CHAPTER 6: Setting Up Tables in Excel 87 CHAPTER 7: Working with Tables in Excel 103 Part 3: Making a Basic Forecast 119 CHAPTER 8: Summarizing Sales Data with Pivot Tables 121 CHAPTER 9: Charting Your Baseline: It’s a Good Idea 141 CHAPTER 10: Forecasting with Excel’s Data Analysis Add-in 159 CHAPTER 11: Basing Forecasts on Regression 173 Part 4: Making Advanced Forecasts 189 CHAPTER 12: Entering the Formulas Yourself 191 CHAPTER 13: Using Moving Averages 219 CHAPTER 14: Changing Horses: From Moving Averages to Smoothing 237 CHAPTER 15: Smoothing: How You Profit from Your Mistakes 259 CHAPTER 16: Fine-Tuning a Regression Forecast 285 CHAPTER 17: Managing Trends 311 CHAPTER 18: Same Time Last Year: Forecasting Seasonal Sales 329 Part 5: The Part of Tens 349 CHAPTER 19: Ten Fun Facts to Know and Tell about Array Formulas 351 CHAPTER 20: The Ten Best Excel Tools 363 Index 373

Reviews

Author Information

Conrad Carlberg is a nationally recognized expert in quantitative analysis, data analysis, and management applications such as Microsoft Excel, SAS, and Oracle. He has been a sales engineer and also worked in product marketing. Conrad has written numerous books on Excel and other Microsoft Office applications. He holds a PhD in statistics.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions