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.
- Trend analysis using Excel – an overview podcast
- Trend analysis using Excel – part 1, part 2 and part 3
- Show forecast values in Excel charts in another color
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 🙂
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.