Excel Sales Forecasting For Dummies(r)

  Author:    Conrad Carlberg, Conrad Carlberg
  ISBN:    0764575937
  Sales Rank:    227500
  Published:    2005-03-14
  Publisher:    Wiley
  # Pages:    408
  Binding:    Paperback
  Avg. Rating:    4.0 based on 5 reviews
  Used Offers:    13 from $7.39
  Amazon Price:    $22.49
  (Data above last updated:  2008-09-29 06:34:43 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Excel Sales Forecasting For Dummies(r)
  
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.

                  Reader Reviews 1 - 7 of 7                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
02-03-07 4 (NA)
(Hide Review...)  I was impressed with what tis book could offer
Reviewer Permalink
If you are new to forecasting and want to learn forecasting in a breeze, this is the book for you. If you like to use excel spreadsheets and want to play with data, this book gets you started in the right path. The book teaches you 3 types of forecasting techniques ( moving average, exponential smoothing and regression forecasts) and explains how to use excel functions to use these techniques.



In fact I have used the concepts like exponential smoothing and regression analysis on spreadsheets based on the book at work and at school.



You will like this book if



1. You are new to forecasting and want to learn in less than 24 hrs.

2. Like using excel formula functions.

3. Like to analyze statistical data

4. Want to develop simple to use forecasting models for your work or for your school project.
(Review Data Last Updated: 2007-09-07 06:52:12 EST)
02-03-07 4 1\1
(Hide Review...)  I was impressed with what tis book could offer
Reviewer Permalink
If you are new to forecasting and want to learn forecasting in a breeze, this is the book for you. If you like to use excel spreadsheets and want to play with data, this book gets you started in the right path. The book teaches you 3 types of forecasting techniques ( moving average, exponential smoothing and regression forecasts) and explains how to use excel functions to use these techniques.

In fact I have used the concepts like exponential smoothing and regression analysis on spreadsheets based on the book at work and at school.

You will like this book if

1. You are new to forecasting and want to learn in less than 24 hrs.
2. Like using excel formula functions.
3. Like to analyze statistical data
4. Want to develop simple to use forecasting models for your work or for your school project.
(Review Data Last Updated: 2008-09-29 06:37:49 EST)
02-02-07 4 (NA)
(Hide Review...)  I was impressed with what tis book could offer
Reviewer Permalink
If you are new to forecasting and want to learn forecasting in a breeze, this is the book for you. If you like to use excel spreadsheets and want to play with data, this book gets you started in the right path. The book teaches you 3 types of forecasting techniques ( moving average, exponential smoothing and regression forecasts) and explains how to use excel functions to use these techniques.

In fact I have used the concepts like exponential smoothing and regression analysis on spreadsheets based on the book at work and at school.

You will like this book if

1. You are new to forecasting and want to learn in less than 24 hrs.
2. Like using excel formula functions.
3. Like to analyze statistical data
4. Want to develop simple to use forecasting models for your work or for your school project.
(Review Data Last Updated: 2007-04-11 07:41:12 EST)
08-31-05 2 1\3
(Hide Review...)  Average Information with Zero "WOW" Factor
Reviewer Permalink
I was expecting new and interesting ideas from this book, but was disappointed. If you truly have no idea how to find a sales baseline for your business or don't know how to track trends, this book is for you. If you are like me (you know the basics but were trying to find a more thorough approach), I wouldn't buy the book.
(Review Data Last Updated: 2006-06-22 11:15:03 EST)
08-29-05 5 1\1
(Hide Review...)  A Unique and Valuable Book
Reviewer Permalink
I read the book from cover to cover and was thoroughly enlightened. From a content perspective, the book is first rate. Carlberg not only explains how to forecast, but he also clarifies the pros and cons of the various methods, explains how to reduce forecasting error, and offers excellent insight into regression and the other statistics involved in making and evaluating a forecast.

Carlberg also masterfully integrates theory with practice by clearly explaining how to best utilize Excel for forecasting. I consider myself a very advanced user of Excel, but nevertheless benefited from Carlberg's sophisticated understanding of Excel. He provides an excellent overview of the pros, cons, and pitfalls of using the Analysis Toolpak vs. spreadsheet modeling, and offers a number of arcane Excel tips that I haven't found elsewhere. For example, despite years of Excel experience, I never understood (or, more accurately, noticed) the difference between a `Category Axis' and a `Value Axis' in an Excel chart.

I almost gave Excel Sales Forecasting four stars, for one important reason: The book was poorly organized. The main topics in the book - moving averages, exponential smoothing, and regression - were broken up into too many pieces, such that each topic was covered multiple times with a lot of unnecessary repetition. I realize this is, to some extent, the nature of Dummies books, which are not necessarily meant to be read cover-to-cover. But as a result, I often found myself needlessly re-reading material several times and, conversely, often had to flip back several chapters because I had forgotten some of the nuances of one of the methods by the time I got to a more advanced section. Having just finished the book, I still feel like I need to review it one more time, by topic, to put all the `pieces' back together in my mind.

With the exception of the final rant above, the book is outstanding and provides an insightful introduction to someone like myself who knew nothing of forecasting.

I'm not one to normally quote old sayings, but this book brought to mind the Chinese (Confucius) proverb: "I hear, I forget. I see, I remember. I do, I understand." Learning forecasting via Excel helped strengthen my understanding. The author and Wiley (the publisher) deserve a lot of credit for producing this unique and valuable book.
(Review Data Last Updated: 2006-06-22 11:15:03 EST)
05-14-05 5 2\2
(Hide Review...)  If "For Dummies" Means Comprehensible...
Reviewer Permalink
If "For Dummies" means, clear, comprehensible, well illustrated, and fun to read to boot, then "Excel Sales Forecasting for Dummies" is true to its name. When you put together a guide to one of the most powerful and useful pieces of software in any company's arsenal with the genius of Conrad Carlberg to lead even the neophyte through the intracacies of sales forecasting, the combination is downright unbeatable. Carlberg has won awards for a string of some of the best "how-to" books on EXCEL and Microsoft Office. This new one gets my personal award for "best EXCEL guide of the year."
(Review Data Last Updated: 2006-06-22 11:15:03 EST)
05-06-05 5 2\2
(Hide Review...)  A book I've needed for a long time
Reviewer Permalink
I know that Dummies books are supposed to be easygoing and offer a lighter tone than most, so I was surprised to see this topic getting the Dummies treatment. I'm glad to report that it works. Excel Sales Forecasting is very reader-friendly, and it demystifies intimidating concepts like "exponential smoothing" and "mutiple regression." I've done a lot of numeric analysis but not much forecasting, mainly because the available texts are so dense and inpenetrable. No more! This book provides the material I need to understand, clearly and with useful detail and examples. It covers the basics and also dips into some more advanced topics. It considers not just the number crunching aspects, but also the business context that you're forecasting into. And it's fun to read! We dummies have a secret: we're smart enough to get books written for us that don't make our eyes glaze over. This one makes the grade.
(Review Data Last Updated: 2006-06-22 11:15:03 EST)
  
                  Reader Reviews 1 - 7 of 7                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)