Excel Sales Forecasting for Dummies
List price: $29.99
Buy it from $9.52
30 day, 100% satisfaction guarantee
If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.
Learn more about our returns policy
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 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.
Rush Rewards U
You have reached 400 XP and carrot coins. That is the daily max!
Limited time offer:
Get the first one free!
All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.
List price: $29.99
Copyright year: 2005
Publisher: John Wiley & Sons, Incorporated
Publication date: 3/25/2005
Size: 7.50" wide x 9.25" long x 0.75" tall
|Understanding Sales Forecasting and How Excel Can Help|
|A Forecasting Overview|
|Forecasting: The Basic Issues|
|Predicting the Future: Why Forecasting Works|
|Organizing the Data|
|Choosing Your Data: How to Get a Good Baseline|
|Setting Up Lists in Excel|
|Working with Lists in Excel|
|Making a Basic Forecast|
|Summarizing Sales Data with Pivot Tables|
|Charting Your Baseline: It's a Good Idea|
|Forecasting with Excel's Analysis ToolPak|
|Basing Forecasts on Regression|
|Making Advanced Forecasts|
|Entering the Formulas Yourself|
|Using Moving Averages|
|Evaluating a Moving Average|
|Smoothing: How You Profit from Your Mistakes|
|Fine-Tuning a Regression Forecast|
|Same Time Last Year: Forecasting Seasonal Sales|
|The Part of Tens|
|Ten Pivot Table Troubles - and How to Overcome Them|
|The Ten Best Excel Tools|