Introduction to Forecasting in Excel 2016 [Charts & Visual Analysis]

Posted on July 27th, 2016 in Charts and Graphs - 5 comments

One of the coolest features of Excel 2016 is forecasting. Today, let’s understand how it works with a sample data set.

Introduction to forecasting in Excel 2016 – video

Watch below video to understand forecasting in Excel 2016.

You can also watch this video on our YouTube Channel.

Download Example Workbook – Forecasting in Excel 2016

Click here to download the example workbook for this lesson. Remember, this only works in Excel 2016 or above.

Learn more about Forecasting & Trend analysis in Excel

Check out below tutorials & podcasts to learn more about forecasting & trend analysis using Excel.

Have you tried Forecasting feature in Excel 2016?

I have played with the feature a few times and I like the simplicity. I think it would be great if Excel can deal with multiple series of data too, but I guess that is asking for too much in v1.0 of this feature.

What about you? Have you tried the forecasting feature of Excel 2016? What are your thoughts? Please share in the comments section.

PS: In the video you can see glimpses of our new life in Wellington, NZ 🙂

Written by Chandoo
Tags: , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

5 Responses to “Introduction to Forecasting in Excel 2016 [Charts & Visual Analysis]”

  1. Martin says:

    Great feature - Thanks for the overview 🙂

  2. Abhijeet says:

    Hi

    How is 2016 excel is this fast than 2010

  3. Pallavi says:

    hi Chandoo, hello from across the ditch. welcome to this side of the world neighbor. A big fan of your website all the way from Australia.

  4. Pillai says:

    Hi Chandoo

    It's good to see pictures of Wellington which brings back memories when my family used to live there. Welcome to NZ and I live in Auckland now.
    thanks for all your tips in Excel - really helpful.

    Regards

Leave a Reply