Excel Sales Forecasting For Dummies

0.0

When they first told you that forecasting sales would be part of your job, did you feel just the tiniest bit of panic? Did you momentarily consider consulting the Yellow Pages for listings of Psychics or Tea Leaf Readers? Well, fear not. Excel Sales Forecasting For Dummies can help you predict the future without incense or a crystal ball.Excel Sales Forecasting For Dummies shows you how to use the number one workbook program, Microsoft Excel, to predict trends and future sales based on something not quite so etherealnumbers. You use data about the past to forecast the future. Excel provides all sorts of tools to help you do that, and this book shows you how to use them.From recognizing why forecasting is a good idea to making sense of exponential smoothing, Excel Sales Forecasting For Dummies has you covered. If you have a basic grasp of how to use Excel, youll be ready to discover how toSelect and use the right forecasting method for your businessChoose and arrange data in lists, then manage that data with pivot tablesFilter lists and turn them into charts that illustrate whats going onFind relationships in your dataUse Excels Analysis Toolpak feature to create forecasts automatically, or venture into advanced forecasts using worksheet functionsGain more control over your forecasting and target specific types of predictionsUse moving averages and predict seasonal salesWritten by Conrad Carlberg, a nationally recognized expert on Excel who also has experience in sales and marketing, this friendly guide gets you up and running quickly and easily. Youll soon be setting up a baseline you can chart and label, summarizing data with pivot tables, making forecasts based on regression, understanding correlation, and discovering how smoothing lets us profit from our mistakes. Youll find your confidence in your ability to make sales predictions has soared right off the chart.

0.0

Conrad Carlberg is the author of more than ten books about Microsoft Excel. As a multi-time recipient of Microsofts MVP designation for Excel, he is a nationally recognized expert on that application.Carlbergs 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.