Overview

Full Product Details

Author:   Conrad Carlberg
Publisher:   John Wiley & Sons Inc
Imprint:   Hungry Minds Inc,U.S.
Dimensions:   Width: 18.80cm , Height: 2.20cm , Length: 23.20cm
Weight:   0.582kg
ISBN:  

9780764575938

ISBN 10:   0764575937
Pages:   404
Publication Date:   01 March 2005
Audience:   General/trade ,  Professional and scholarly ,  General ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Unknown
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

Introduction. Part I: Understanding Sales Forecasting and How Excel Can Help. Chapter 1: A Forecasting Overview. Chapter 2: Forecasting: The Basic Issues. Chapter 3: Understanding Baselines. Chapter 4: Predicting the Future: Why Forecasting Works. Part II: Organizing the Data. Chapter 5: Choosing Your Data: How to Get a Good Baseline. Chapter 6: Setting Up Lists in Excel. Chapter 7: Working with Lists in Excel. Part III: Making a Basic Forecast. Chapter 8: Summarizing Sales Data with Pivot Tables. Chapter 9: Charting Your Baseline: It?s a Good Idea. Chapter 10: Forecasting with Excel?s Analysis ToolPak. Chapter 11: Basing Forecasts on Regression. Part IV: Making Advanced Forecasts. Chapter 12: Entering the Formulas Yourself. Chapter 13: Using Moving Averages. Chapter 14: Evaluating a Moving Average. Chapter 15: Smoothing: How You Profit from Your Mistakes. Chapter 16: Fine-Tuning a Regression Forecast. Chapter 17: Managing Trends. Chapter 18: Same Time Last Year: Forecasting Seasonal Sales. Part V: The Part of Tens. Chapter 19: Ten Pivot Table Troubles ? and How to Overcome Them. Chapter 20: The Ten Best Excel Tools. Index.

Reviews

Author Information

Conrad Carlberg is the author of more than ten books about Microsoft Excel. As a multi-time recipient of Microsoft?s MVP designation for Excel, he is a nationally recognized expert on that application. Carlberg?s Ph.D. in statistics involves work in forecasting, as does his work in telecommunications and the health-care industry. He used the techniques in this book to reduce a crushing $24 million inventory owned by a Baby Bell to under $10 million in 18 months. The carrying costs for $24 million in equipment are significant. The point: This forecasting stuff works. As preparation for starting his consultancy, Carlberg spent two years as a sales engineer for a Fortune 500 company.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions