Excel Sales Forecasting For Dummies

Product Description

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 & 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 & 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 to. This title helps to: select & use the right forecasting method for your business; choose & arrange data in lists then manage that data with pivot tables; filter lists & turn them into charts that illustrate whats going on; find relationships in your data; use Excels Analysis Toolpak feature to create forecasts automatically or venture into advanced forecasts using worksheet functions; gain more control over your forecasting & target specific types of predictions; & use moving averages & predict seasonal sales. Written by Conrad Carlberg a nationally recognized expert on Excel who also has experience in sales & marketing this friendly guide gets you up & running quickly & easily. Youll soon be setting up a baseline you can chart & label summarizing data with pivot tables making forecasts based on regression understanding correlation & 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."