Description - Excel Sales Forecasting for Dummies by Conrad Carlberg
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 to
Select and use the right forecasting method for your
business
Choose and arrange data in lists, then manage that data with
pivot tables
Filter lists and turn them into charts that illustrate
what?s going on
Find relationships in your data
Use Excel?s Analysis Toolpak feature to create forecasts
automatically, or venture into advanced forecasts using worksheet
functions
Gain more control over your forecasting and target specific
types of predictions
Use 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.
Buy Excel Sales Forecasting for Dummies by Conrad Carlberg from Australia's Online Independent Bookstore, BooksDirect.
Other Editions - Excel Sales Forecasting for Dummies by Conrad Carlberg
A Preview for this title is currently not available.
Checking availability...
