Excel Sales Forecasting For Dummies (ePub)

When they first told you that forecasting sales would be part ofyour job, did you feel just the tiniest bit of panic? Did youmomentarily consider consulting the Yellow Pages for listings of"Psychics" or "Tea Leaf Readers"? Well,fear not. Excel Sales Forecasting For Dummies can help youpredict the future without incense or a crystal ball.

Excel Sales Forecasting For Dummies shows you how to usethe number one workbook program, Microsoft Excel, to predict trendsand future sales based on something not quite soethereal--numbers. You use data about the past to forecast thefuture. Excel provides all sorts of tools to help you do that, andthis book shows you how to use them.

From recognizing why forecasting is a good idea to making senseof exponential smoothing, Excel Sales Forecasting ForDummies has you covered. If you have a basic grasp of how touse Excel, you'll be ready to discover how to
* Select and use the right forecasting method for yourbusiness
* Choose and arrange data in lists, then manage that data withpivot tables
* Filter lists and turn them into charts that illustratewhat's going on
* Find relationships in your data
* Use Excel's Analysis Toolpak feature to create forecastsautomatically, or venture into advanced forecasts using worksheetfunctions
* Gain more control over your forecasting and target specifictypes of predictions
* Use moving averages and predict seasonal sales

Written by Conrad Carlberg, a nationally recognized expert onExcel who also has experience in sales and marketing, this friendlyguide gets you up and running quickly and easily. You'll soonbe setting up a baseline you can chart and label, summarizing datawith pivot tables, making forecasts based on regression,understanding correlation, and discovering how smoothing lets usprofit from our mistakes. You'll find your confidence in yourability to make sales predictions has soared right off thechart.