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

Charts and Graphs - 6 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 🙂


Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around.

Related articles:

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

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

  1. Martin says:

    Great feature - Thanks for the overview 🙂

  2. Abhijeet says:


    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.


  5. Hydrologica Review says:

    I'd like to find out more? I'd care to find out some additional information.

Leave a Reply

« »