Excel Sales Forecasting For Dummies by Conrad Carlberg

No critic rating

Waiting for minimum critic reviews

See Reader Rating


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 ethereal—numbers. 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, you’ll 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 what’s going onFind relationships in your dataUse Excel’s 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 sales

Written 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. You’ll 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. You’ll find your confidence in your ability to make sales predictions has soared right off the chart.


About Conrad Carlberg

See more books from this Author
Conrad Carlberg is president of Network Control Systems, Inc., a software-development and consulting firm that specializes in statistical and database applications, and Beyond the Ledgers, a joint venture that develops and markets software coupling Excel to QuickBooks™. He holds a Ph.D. in statistics and is a many-time recipient of Microsoft's Most Valuable Professional Award. He lives near San Diego.
Published April 8, 2011 by For Dummies. 404 pages
Genres: Business & Economics, Computers & Technology. Non-fiction

Reader Rating for Excel Sales Forecasting For Dummies

An aggregated and normalized score based on 14 user ratings from iDreamBooks & iTunes

Rate this book!

Add Review