Close this search box.

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



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 🙂


Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Announcing Power BI Dashboard Contest 2024

Announcing Power BI Dashboard Contest (win $500 prizes!)

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC dashboard for the Awesome Chocolates CEO with sales & financial insights! Winners stand a chance to score up to $500 in Amazon Gift Cards, plus some serious bragging rights!

9 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.

  6. Rob says:

    Hi Chandoo! Awesome!!! one question.... same data set (1st row has dates and bottom row numbers) and if date and numbers are instead in a column, the data forecast is not the same? This is what I've notice. If horizontal configuration, it will drop one of my months but not if in columns.

    • Chandoo says:

      Thank you Rob and welcome to Chandoo.org.

      I think this is a limitation of using Forecast Sheet button. I have not tested it, but on the "Forecast" options screen, is there a way to tell Excel where your dates are?

      If not, one option is to use FORECAST.ETS() function directly. This gives you most flexibility.

      If you prefer to use the Forecast Sheet button, then use Power Query (or manual method) to transpose your table first.

Leave a Reply