Description

Book Synopsis
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 excellenceeven if numbers aren''t your jam.

  • Choose the right forecasting method
  • Find relationships in your data

    Table of Contents

    Introduction 1

    Part 1: Understanding Sales Forecasting and How Excel Can Help 5

    Chapter 1: A Forecasting Overview 7

    Chapter 2: Forecasting: The Basic Issues 23

    Chapter 3: Understanding Baselines 41

    Chapter 4: Predicting the Future: Why Forecasting Works 53

    Part 2: Organizing the Data 69

    Chapter 5: Choosing Your Data: How to Get a Good Baseline 71

    Chapter 6: Setting Up Tables in Excel 87

    Chapter 7: Working with Tables in Excel 103

    Part 3: Making a Basic Forecast 119

    Chapter 8: Summarizing Sales Data with Pivot Tables 121

    Chapter 9: Charting Your Baseline: It’s a Good Idea 141

    Chapter 10: Forecasting with Excel’s Data Analysis Add-in 159

    Chapter 11: Basing Forecasts on Regression 173

    Part 4: Making Advanced Forecasts 189

    Chapter 12: Entering the Formulas Yourself 191

    Chapter 13: Using Moving Averages 219

    Chapter 14: Changing Horses: From Moving Averages to Smoothing 237

    Chapter 15: Smoothing: How You Profit from Your Mistakes 259

    Chapter 16: Fine-Tuning a Regression Forecast 285

    Chapter 17: Managing Trends 311

    Chapter 18: Same Time Last Year: Forecasting Seasonal Sales 329

    Part 5: The Part of Tens 349

    Chapter 19: Ten Fun Facts to Know and Tell about Array Formulas 351

    Chapter 20: The Ten Best Excel Tools 363

    Index 373

Excel Sales Forecasting For Dummies

    Product form

    A Paperback / softback by Conrad Carlberg

    £19.79

    Includes FREE delivery

    RRP £21.99 – you save £2.20 (10%)

    Order before 4pm tomorrow for delivery by Mon 21 Sep 2026.

      Trusted by thousands of customers. See 2,385+ Customer Reviews

      View other formats and editions of Excel Sales Forecasting For Dummies by Conrad Carlberg

      Book details

      Publisher John Wiley & Sons Inc
      Published 23 August 2016
      ISBN-13 9781119291428
      978-1119291428
      ISBN-10 1119291429
      Also in:
      Business applications

      Description

      Book Synopsis
      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 excellenceeven if numbers aren''t your jam.

      • Choose the right forecasting method
      • Find relationships in your data

        Table of Contents

        Introduction 1

        Part 1: Understanding Sales Forecasting and How Excel Can Help 5

        Chapter 1: A Forecasting Overview 7

        Chapter 2: Forecasting: The Basic Issues 23

        Chapter 3: Understanding Baselines 41

        Chapter 4: Predicting the Future: Why Forecasting Works 53

        Part 2: Organizing the Data 69

        Chapter 5: Choosing Your Data: How to Get a Good Baseline 71

        Chapter 6: Setting Up Tables in Excel 87

        Chapter 7: Working with Tables in Excel 103

        Part 3: Making a Basic Forecast 119

        Chapter 8: Summarizing Sales Data with Pivot Tables 121

        Chapter 9: Charting Your Baseline: It’s a Good Idea 141

        Chapter 10: Forecasting with Excel’s Data Analysis Add-in 159

        Chapter 11: Basing Forecasts on Regression 173

        Part 4: Making Advanced Forecasts 189

        Chapter 12: Entering the Formulas Yourself 191

        Chapter 13: Using Moving Averages 219

        Chapter 14: Changing Horses: From Moving Averages to Smoothing 237

        Chapter 15: Smoothing: How You Profit from Your Mistakes 259

        Chapter 16: Fine-Tuning a Regression Forecast 285

        Chapter 17: Managing Trends 311

        Chapter 18: Same Time Last Year: Forecasting Seasonal Sales 329

        Part 5: The Part of Tens 349

        Chapter 19: Ten Fun Facts to Know and Tell about Array Formulas 351

        Chapter 20: The Ten Best Excel Tools 363

        Index 373

      Recently viewed products

      © 2026 Book Curl

        • American Express
        • Apple Pay
        • Diners Club
        • Discover
        • Google Pay
        • Maestro
        • Mastercard
        • PayPal
        • Shop Pay
        • Union Pay
        • Visa

        Login

        Forgot your password?

        Don't have an account yet?
        Create account