Conrad Carlberg

Excel Sales Forecasting For Dummies (eBook, ePUB)

• Format: ePub

Produktbeschreibung

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.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 404
• Erscheinungstermin: 8. April 2011
• Englisch
• ISBN-13: 9781118079935
• Artikelnr.: 38462143

Autorenporträt

Conrad Carlberg is the author of more than ten books aboutMicrosoft Excel. As a multi-time recipient of Microsoft's MVPdesignation for Excel, he is a nationally recognized expert on thatapplication. Carlberg's Ph.D. in statistics involves work in forecasting,as does his work in telecommunications and the health-careindustry. He used the techniques in this book to reduce a crushing$24 million inventory owned by a Baby Bell to under $10 million in18 months. The carrying costs for $24 million in equipment aresignificant. The point: This forecasting stuff works. As preparation for starting his consultancy, Carlberg spent twoyears as a sales engineer for a Fortune 500 company.