Excel Sales Forecasting For Dummies, 2e
Paperback Engels 2016 9781119291428Samenvatting
Excel at predicting sales and forecasting trends using Microsoft Excel!
If you′re a sales or marketing professional, you know that forecasting sales is one of the biggest challenges you face on the job. Unlike other books on the subject, Excel Sales Forecasting For Dummies, 2nd Edition leaves arcane business school terms and complex algebraic equations at the door, focusing instead on what you can do right now to utilize the world′s most popular spreadsheet program to produce forecasts you can rely on.
Loaded with confidence boosters for anyone who succumbs to sweaty palms when sales predictions are mentioned, this trusted guide show you how to use the many tools Excel provides to arrange your past data, set up lists and pivot tables, use moving averages, and so much more. Before you know it, you′ll become a forecaster par excellence even if numbers aren′t your jam.
Choose the right forecasting method
Find relationships in your data
Predict seasonal sales
Filter lists or turn them into charts
Consider this guide your crystal ball and start predicting the future with confidence and ease!
Specificaties
Lezersrecensies
Inhoudsopgave
<p>Part 1: Understanding Sales Forecasting and How Excel Can Help 5</p>
<p>CHAPTER 1: A Forecasting Overview 7</p>
<p>CHAPTER 2: Forecasting: The Basic Issues 23</p>
<p>CHAPTER 3: Understanding Baselines 41</p>
<p>CHAPTER 4: Predicting the Future: Why Forecasting Works 53</p>
<p>Part 2: Organizing the Data 69</p>
<p>CHAPTER 5: Choosing Your Data: How to Get a Good Baseline 71</p>
<p>CHAPTER 6: Setting Up Tables in Excel 87</p>
<p>CHAPTER 7: Working with Tables in Excel 103</p>
<p>Part 3: Making a Basic Forecast 119</p>
<p>CHAPTER 8: Summarizing Sales Data with Pivot Tables 121</p>
<p>CHAPTER 9: Charting Your Baseline: It s a Good Idea 141</p>
<p>CHAPTER 10: Forecasting with Excel s Data Analysis Add–in 159</p>
<p>CHAPTER 11: Basing Forecasts on Regression 173</p>
<p>Part 4: Making Advanced Forecasts 189</p>
<p>CHAPTER 12: Entering the Formulas Yourself 191</p>
<p>CHAPTER 13: Using Moving Averages 219</p>
<p>CHAPTER 14: Changing Horses: From Moving Averages to Smoothing 237</p>
<p>CHAPTER 15: Smoothing: How You Profit from Your Mistakes 259</p>
<p>CHAPTER 16: Fine–Tuning a Regression Forecast 285</p>
<p>CHAPTER 17: Managing Trends 311</p>
<p>CHAPTER 18: Same Time Last Year: Forecasting Seasonal Sales 329</p>
<p>Part 5: The Part of Tens 349</p>
<p>CHAPTER 19: Ten Fun Facts to Know and Tell about Array Formulas 351</p>
<p>CHAPTER 20: The Ten Best Excel Tools 363</p>
<p>Index 373</p>
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan
