Excel Sales Forecasting for Dummies

ISBN-10: 0764575937

ISBN-13: 9780764575938

Edition: 2005

Authors: Conrad Carlberg
List price: $29.99 Buy it from $3.00
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.

Used Starting from $15.72
New Starting from $23.44
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

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.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $29.99
Copyright year: 2005
Publisher: John Wiley & Sons, Incorporated
Publication date: 3/25/2005
Binding: Paperback
Pages: 404
Size: 7.50" wide x 9.25" long x 0.75" tall
Weight: 1.298
Language: English

Introduction
Understanding Sales Forecasting and How Excel Can Help
A Forecasting Overview
Forecasting: The Basic Issues
Understanding Baselines
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
Managing Trends
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
Index
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×