Excel Sales Forecast For Dummies - Couverture souple

Carlberg, Conrad

Couverture souple

ISBN 10 : 0764575937 ISBN 13 : 9780764575938

Editeur : For Dummies, 2005

Synopsis

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.

A propos du livre

Présentation de l'éditeur

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.

Quatrième de couverture

Here′s the fun and easy way® to predict the future!

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

Détails de l'édition

• Éditeur: For Dummies
• Date d'édition: 2005
• Langue: anglais
• ISBN 10: 0764575937
• ISBN 13: 9780764575938
• Reliure: Broché
• Nombre de pages: 386
• Coordonnées du fabricant: non disponible
• Personne responsable: non disponible