# CP036: How to do trend analysis using Excel?

Posted on June 11th, 2015 in Chandoo.org Podcast Sessions , Charts and Graphs - 4 comments

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
• linear
• curve
• cyclical
• strange
• Doing trend analysis in Excel – the process
• How to use trend analysis results
• Conclusions

### Links & Resources mentioned in this podcast

Trend Analysis – formulas & chart techniques:

Calculating moving averages in Excel

Regression & complex trend analysis:

Reference book: Data smart by John Foreman

### How do you analyze trends?

For my work, I use both cyclical & linear trend analysis techniques. The insights from these help me to optimize my blog posts, understand best times to publish new articles & analyze how well various marketing initiatives are working out.

 What functions is Excel missing ? Use Paste Special to multiply (or add, divide etc.) a range with a variable [quick tip]
 Written by Chandoo Tags: advanced excel, charting, Forecast, Learn Excel, line charts, Linest, podcast, Trend, Trendline Home: Chandoo.org Main Page ? Doubt: Ask an Excel Question

### 4 Responses to “CP036: How to do trend analysis using Excel?”

1. Kris says:

Guru Chandooji,

You are awesome as a teacher and a nice speaker.

Thanks for educating the community and appreciate your volunteership.

Please let me know when you release a new PodCast/video/article. I would like to to read/listen and write feedback.

Please change the icon/picture next to Chandoo.org, it looks awful.

Thanks a bunch

2. Kris says:

I enjoyed listening the Podcast

Thanks a bunch

3. Kris says:

Do you have any videos?

 What functions is Excel missing ? Use Paste Special to multiply (or add, divide etc.) a range with a variable [quick tip]