{"product_id":"excel-sales-forecasting-for-dummies-isbn-9781119291428","title":"Excel Sales Forecasting For Dummies","description":"\u003cb\u003eExcel at predicting sales and forecasting trends using Microsoft Excel!\u003c\/b\u003e \u003cp\u003eIf 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, \u003ci\u003eExcel Sales Forecasting For Dummies, 2\u003csup\u003end\u003c\/sup\u003e Edition\u003c\/i\u003e 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. \u003c\/p\u003e\u003cp\u003eLoaded 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. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eChoose the right forecasting method\u003c\/li\u003e \u003cli\u003eFind relationships in your data\u003c\/li\u003e \u003cli\u003ePredict seasonal sales\u003c\/li\u003e \u003cli\u003eFilter lists or turn them into charts\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eConsider this guide your crystal ball—and start predicting the future with confidence and ease! \u003c\/p\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Understanding Sales Forecasting and How Excel Can Help 5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: A Forecasting Overview 7\u003c\/p\u003e \u003cp\u003eChapter 2: Forecasting: The Basic Issues 23\u003c\/p\u003e \u003cp\u003eChapter 3: Understanding Baselines 41\u003c\/p\u003e \u003cp\u003eChapter 4: Predicting the Future: Why Forecasting Works 53\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Organizing the Data 69\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 5: Choosing Your Data: How to Get a Good Baseline 71\u003c\/p\u003e \u003cp\u003eChapter 6: Setting Up Tables in Excel 87\u003c\/p\u003e \u003cp\u003eChapter 7: Working with Tables in Excel 103\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Making a Basic Forecast 119\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 8: Summarizing Sales Data with Pivot Tables 121\u003c\/p\u003e \u003cp\u003eChapter 9: Charting Your Baseline: It’s a Good Idea 141\u003c\/p\u003e \u003cp\u003eChapter 10: Forecasting with Excel’s Data Analysis Add-in 159\u003c\/p\u003e \u003cp\u003eChapter 11: Basing Forecasts on Regression 173\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: Making Advanced Forecasts 189\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 12: Entering the Formulas Yourself 191\u003c\/p\u003e \u003cp\u003eChapter 13: Using Moving Averages 219\u003c\/p\u003e \u003cp\u003eChapter 14: Changing Horses: From Moving Averages to Smoothing 237\u003c\/p\u003e \u003cp\u003eChapter 15: Smoothing: How You Profit from Your Mistakes 259\u003c\/p\u003e \u003cp\u003eChapter 16: Fine-Tuning a Regression Forecast 285\u003c\/p\u003e \u003cp\u003eChapter 17: Managing Trends 311\u003c\/p\u003e \u003cp\u003eChapter 18: Same Time Last Year: Forecasting Seasonal Sales 329\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5: The Part of Tens 349\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19: Ten Fun Facts to Know and Tell about Array Formulas 351\u003c\/p\u003e \u003cp\u003eChapter 20: The Ten Best Excel Tools 363\u003c\/p\u003e \u003cp\u003eIndex 373\u003c\/p\u003e \u003cp\u003e\u003cb\u003eConrad Carlberg \u003c\/b\u003eis a nationally recognized expert in quantitative analysis, data analysis, and management applications such as Microsoft Excel, SAS, and Oracle. He has been a sales engineer and also worked in product marketing. Conrad has written numerous books on Excel and other Microsoft Office applications. He holds a PhD in statistics.\u003c\/p\u003e  \u003cp\u003eChoose, manage, and present data\u003c\/p\u003e \u003cp\u003eSelect the right forecasting method for your business \u003c\/p\u003e\u003cp\u003eUse moving averages and predict seasonal sales \u003c\/p\u003e\u003cp\u003eCreate \u003cb\u003esales forecasts\u003c\/b\u003e you can trust \u003c\/p\u003e\u003cp\u003eYou don't need magic, luck, or an advanced math degree to develop reliable sales forecasts; you just need Excel and this book! This guide explains how forecasting works and how to use the tools built into Excel. You'll learn how to choose your data, set up tables, chart your baseline, to create both basic and advanced forecasts you can really use. \u003c\/p\u003e\u003cp\u003eInside... \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003ePrevent common issues\u003c\/li\u003e \u003cli\u003eWhy baselines matter\u003c\/li\u003e \u003cli\u003eHow to organize  your data\u003c\/li\u003e \u003cli\u003eTips on setting up tables\u003c\/li\u003e \u003cli\u003eWorking with pivot charts\u003c\/li\u003e \u003cli\u003eHow to forecast seasonal   sales revenue\u003c\/li\u003e \u003cli\u003eForecasting with  regression\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989182267621,"sku":"NP9781119291428","price":31.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119291428.jpg?v=1761783117","url":"https:\/\/k12savings.com\/es\/products\/excel-sales-forecasting-for-dummies-isbn-9781119291428","provider":"K12savings","version":"1.0","type":"link"}