Frequently Bought Together
Customers Who Bought This Item Also Bought
by Stephen L. Nelson
|
by Michael Alexander
|
by Spyros G. Makridakis
|
by Joseph Schmuller Ph.D.
|
by John Tom Mentzer
|
Product details
Would you like to update product info or give feedback on images?
|
Customers Viewing This Page May Be Interested in These Sponsored Links
(What is this?)Product Description
Product Description
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.
From the Back Cover
Organize sales data, chart a baseline, forecast trends, and more with Excel
Do you succumb to sweaty palms the moment someone mentions sales predictions? This book is loaded with confidence–boosters! It shows you how to use the many tools Excel provides to arrange your past data, set up lists and pivot tables, use Excel′s Analysis ToolPak, and become a forecaster par excellence — even if you′re math–challenged.
Discover how to
- Choose the right forecasting method
- Find relationships in your data
- Filter lists or turn them into charts
- Summarize data with pivot tables
- Use moving averages
- Predict seasonal sales
You wouldn't have pulled this book off the shelf it you didn't need to forecast sales. Read the first page
Concordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Do Customers Ultimately Buy After Viewing This Item?
 |
82% buy the item featured on this page: Excel Sales Forecasting for Dummies£8.89 |
 |
6% buy Excel 2007 Dashboards and Reports for Dummies£8.99 |
 |
5% buy Sales Forecasting Management: A Demand Management Approach£36.77 |
 |
4% buy Excel 2003 All-in-one Desk Reference for Dummies £13.42 |
Customer Reviews
|
There are no customer reviews yet.
|
|||
|
Video reviews
|
 |
Listmania!
Look for similar items by category
- Books > Business, Finance & Law > Management
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Introduction
- Books > Computing & Internet > New to Computing > Guidebook Series > Dummies > Microsoft Excel
- Books > Computing & Internet > New to Computing > Software Guides > Microsoft Excel
- Books > Computing & Internet > New to Computing > Word Processors, Spreadsheets & Databases > Spreadsheets
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
Your Recent History
(What's this?)|
After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in. |
