Create a BCG Matrix

If you've taken business class or familiar with management consulting strategies, you've probably come across this tool called a BCG Matrix. Also known as a growth-share matrix, the BCG matrix was created by Bruce Hendersen in the 70s (founder of Boston Consulting Group). It's a tool that helps you analyze companies or products based on a quadrant that shows growth rate and relative market share. You can actually create this fairly easily on Excel, so check out the video to learn how.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[PatrickBlom]

Thanks, great memory refresher for my school project :)

[sebastianlechner]

That is massively helpful. I started using fancy bcg matrix, but what you are doing is way better.

[ayushimahadik]

Why did you reverse the values? Please clarify, thanks.

[yoannanovak]

Very Thank you so much! You save me on Marketing task!

[sirmacred]

Thanks for sharing! Very useful for my class!

[jamesrosita]

Wow this massively helpful, i have gotten more knowledge with your explanation..

[juliacampbell]

Hi Doug, super helpful, thanks! Just a technical question: @4:14 you’ve got relative market share along the x-axis. Then at 9:30 when you are assigning axis labels, you put relative market share as the y-axis label. Is that right?

[батхүрэлХүрэлбаатар]

thanks it's very useful for me.
How do you calculate relative market share and market share of largest competitor?

[krishant]

Yes yes, it indeed helped me real big time, thank you. cheers

[JagsonpalPharma]

Hi doug, you explained so well. I have done it...yahooo

[richardwilkinson]

Thank you! Massive help with my assignment

[eduardofolly]

Doug, thank you very much, your tutorial helps me a lot!

[eliasaba]

This helps me much. Thank you so very much

[siszzo]

This is so helpful. Thank you so much!

[sunk.]

very helpful, thanks. pls post more about EXCEL graphs :)

[Sobolev]

Thank you very much for this great effort

[shima]

thank you its a great help...but how to find revenue...is it from the industrial profitability >?

[chloeramos]

what is the equation to get the Relative Market Share?

[m.shuker]

thx for the video, but how can we calculate the market share of the largest competitor?

[verschalter]

You made my day.... Great help.. Thanks