All articles with 'Forecast' Tag
How to add a lot of Goal Seeking to a model
Recently in the Chandoo.org Forums, MR06 asked the question, “I am trying to create a sensitivity table that tells me what amount of equity I need to include in a deal in order to get a fixed IRR as the year 3 sales price changes.” MR06 was using Goal Seek to change the equity input […]Continue »
CP036: How to do trend analysis using Excel?
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | RSS
In the 36th session of Chandoo.org podcast, Let’s follow the trend.
What is in this session?
In this podcast,
- A quick trip to down under
- What is trend analysis
- 4 types of common trends
- Doing trend analysis in Excel – the process
- How to use trend analysis results
Formula Forensics No. 033 – Interpolation
Today, Formula Forensics examines 3 techniques to determine an interpolated value along a curve.Continue »
Are You Trendy? (Part 2)
Does your data hold hidden secrets?
In Part 2 of Are You Trendy? we will examine the Excel functions that assist us in Trend Analysis.