Create a BCG Matrix

Подписаться 78 тыс.

Просмотров 397 тыс.

50% 1

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.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 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!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

Опубликовано:

14 фев 2014

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 132

@manojsom2834 9 лет назад

Thanks Doug....extremely helpful

@excelisfun 10 лет назад

Thanks!

@richardwilkinson7485 10 лет назад

Thank you! Massive help with my assignment

@PatrickBlom93 8 лет назад

Thanks, great memory refresher for my school project :)

@tivsmarty6016 9 лет назад

Thx Doug ! Clear and useful

@sebastianlechner6230 3 года назад

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

@DougHExcel 3 года назад

Glad it helped!

@garyguhman9042 9 лет назад

Thanks Doug..very helpful!!!

@eduardofolly8693 6 лет назад

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

@DougHExcel 6 лет назад

Thanks Eduardo Folly, glad it helped!

@Sobolev514 10 лет назад

Thank you very much for this great effort

@user-hd1wh3pz3c 8 лет назад

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

@realferny 10 лет назад

This is brilliant, thanks

@sunk.4740 9 лет назад

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

@omenukwa1 10 лет назад

Thank you so much

@SyedKollol 8 лет назад

Thanks for the video.. It's great!!

@junzhao4907 10 лет назад

Thank you so much!

@brittanybeaudoin4064 5 лет назад

Thanks so much for taking the time!

@DougHExcel 5 лет назад

Hi Brittany Beaudoin, glad you liked it, thanks for commenting!

@fakitahfcp8911 9 лет назад

Many thanks.. very useful :)

@sirmacred 2 года назад

Thanks for sharing! Very useful for my class!

@DougHExcel 2 года назад

Glad you liked!

@siszzo 4 года назад

This is so helpful. Thank you so much!

@DougHExcel 4 года назад

Hi Amirah Nirwan...you're welcome, glad you liked!

@verschalter 5 лет назад

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

@DougHExcel 5 лет назад

You’re welcome!

@albertovillanueva6800 9 лет назад

this saved me! thx

@dennisonyango2084 9 лет назад

Good stuff!

@shima586 8 лет назад

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

@rhakam91 8 лет назад

Thank you so much , it really helps me.

@DougHExcel 3 года назад

Hi radinal hakam, you're welcome!

@CREATACLASSES Год назад

Thank you. It helped a lot.

@DougHExcel Год назад

Thanks CREATA CLASSES, glad it helped!

@ArjunaAnjaniAdventure 10 лет назад

Big Thankss!

@batesmekanik 10 лет назад

thank you

@alghalebi 2 года назад

very helpful, many thanks!

@DougHExcel 2 года назад

Glad it was helpful!

@yoannanovak5945 4 года назад

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

@DougHExcel 4 года назад

Glad it was helpful!

@juliacampbell6135 2 года назад

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?

@krishant 2 года назад

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

@DougHExcel 2 года назад

Glad it helped!

@akhmadbakhtiar 10 лет назад

Thanks Doug

@IliasIronside 3 года назад

Great explication , Thank you ser

@DougHExcel 3 года назад

You are welcome

@rozianarifae5302 8 лет назад

thank you so much. It helps me! :)

@DougHExcel 3 года назад

Hi Roziana Rifa'e, you're welcome!

@user-ko1ej3tm7h 11 месяцев назад

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

@DougHExcel 11 месяцев назад

Glad it helped!

@jose98937 4 года назад

Good Job Doug!

@DougHExcel 4 года назад

Thanks!

@gabriellefeldhordt6060 4 года назад

Thank you very much!

@DougHExcel 4 года назад

You're welcome!

@mauricebaggen1547 6 лет назад

great help!!

@DougHExcel 6 лет назад

Thanks Maurice Baggen, glad it helped!

@jamesrosita3430 Год назад

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

@DougHExcel Год назад

Thanks james rosita, glad it helped!

@eliasaba2727 2 года назад

This helps me much. Thank you so very much

@DougHExcel 2 года назад

You’re very welcome!

@eliasaba2727 2 года назад

@@DougHExcel you kindly have helped many people concerning this. Thank you from Jakarta. 🙏🏽

@qatm585 5 лет назад

Thanks a lot!! This what a great help for my marketing courses!

@DougHExcel 5 лет назад

Hi Qat M, glad you liked it, thanks for commenting!

@personal1285 2 года назад

@@DougHExcel very good video 👍🏻thanks a lot

@abiolabose2483 3 года назад

Thank you so much, this as really helpful I don't know if you can do something like this for ADL MATRIX and SHELL/DPM MATRIX Thank you

@DougHExcel 3 года назад

Hi Abiola Bose, Great suggestion...thanks for the comment!

@Gen_Win_ 2 года назад

Is cool & elegantly :)

@DougHExcel 2 года назад

Hi Геннадий Афонин, thanks for the comment!

@akshaydewan5608 Год назад

thanks for this

@DougHExcel Год назад

Welcome!

@user-oi1zw4dv9k 3 года назад

Thanks a lot!

@DougHExcel 3 года назад

You're welcome! 别客气!

@ayushimahadik9814 Год назад

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

@shivasafari2640 3 года назад

thanks!

@DougHExcel 3 года назад

Welcome!

@gregorios_ferrari 2 года назад

Thanks

@DougHExcel 2 года назад

You’re welcome!

@saimaiqbal3471 7 лет назад

Amazing amazing. thumbs up!

@DougHExcel 7 лет назад

Hi Saima iqbal, glad you liked it, thanks for commenting!

@saimaiqbal3471 7 лет назад

do you have videos for creating Grand strategy, IE matrix as well?

@DougHExcel 7 лет назад

Nope, but maybe in the future...

@chloeramos3241 2 года назад

what is the equation to get the Relative Market Share?

@nika_lu 2 года назад

Hi everyone, I have some problems with this matrix, object at the intersection of the line. May be prefer assign this object to one sector? Who can help me?

@m.shuker5132 6 лет назад

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

@DougHExcel 6 лет назад

Find the company total sales(revenue) and divided by the industry's total sales. Usually organizations have this data somewhere in research reports.

@kissthesun30 8 лет назад

thanks ! i have a question, what to do if the product circle falls in the middle of the graphic? means that assumely the middle point of market share is 1.5 and the market growth is 10... if my product has the same amount, what shall i do? thankyou

@DougHExcel 3 года назад

Hi Cynthia Tirtani, thanks for the comment!

@nlsilkpfc102 8 лет назад

Thank you for your sharing but how to calculate the largest competitor market share?

@DougHExcel 3 года назад

Hi MC James LI, thanks for the comment! Hi MC James LI, you're welcome!

@dimitriparis8278 8 лет назад

Very usefull video ! Is there any way to automatize the label from each product ? Cause im working on 50 products in the same time so ...

@dimitriparis8278 8 лет назад

Thx for tips, i tryed with VBA but didn't work, I probably failed. Anyway thx for help

@LuisFernandoFranco 7 лет назад

I have exactly the same problem. Unbelievable MS doesn't have a way to change the labels automatically in a series formed by (label, x, y, size)

@DougHExcel 3 года назад

Hi Dimitri Paris, thanks for the comment!

@stephanycosta5920 9 лет назад

Hi Thanks Doug H. How do you calculate the market growth?

@stephanycosta5920 9 лет назад

***** Thanks. It really helps me.

@andygosu 5 лет назад

Thank you, i have a question, how do you calculated the Revenue ?

@DougHExcel 5 лет назад

Hi kai yutaka, thanks for the comment! For Revenue, depending on your data, you'll have to pull that from either public source of the companies filings (SEC 10K) in the US or for equivalent government documents for non US companies.

@MorriganQueenGaming 2 года назад

Is there a way to match the formatting colour of the sphere to the cell where we have the name, my spheres are vey close together and difficult to distinguish. if i could auto colour them to match my product name it may make the cell more easy but I'm concerned I'll mix it up if i do it by hand. can it be done automatically

@DougHExcel 2 года назад

Yes but prolly with VBA

@seenderr 4 года назад

THANK YOOOUUUUU omg

@DougHExcel 4 года назад

You're Welcome!

@jasriswan 5 месяцев назад

How to calculate market growth?

@faryalsiddi7875 4 года назад

it helped me but you didnt mentioned how to write low high in the corners???

@DougHExcel 4 года назад

those are text boxes that are added separately

@sagarvyas5259 4 года назад

From where did you find the market growth

@DougHExcel 4 года назад

one ways is to get historical numbers from govt statistics and take a % from a organization historical number or jus find data from some consulting companies

@iffi2526 2 года назад

How is it possible that your market share is larger than the largest market share of competitors...

@ihsanizwer 6 лет назад

How is the market growth calculated??

@DougHExcel 3 года назад

have to get the data of market share from period to period either the company or industry periodical that tracks it

@shailendrakumar7989 6 лет назад

Good Enough

@DougHExcel 6 лет назад

Hi Shailendra Kumar, thanks for the comment!

@nabilaaulia6006 2 года назад

how to get a mrket growth?

@DougHExcel 2 года назад

try to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here ru-vid.comsearch?query=forecast

@quameatu 2 года назад

How do we find the market growth

@DougHExcel 2 года назад

you'll have to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here ru-vid.comsearch?query=forecast

@quameatu 2 года назад

@@DougHExcel thanks for the response. I saw a video where the market share was used to determine the growth in the market. The current year over previous year -1 *100.

@arch3673 4 года назад

안동대학교 화이팅

@DougHExcel 4 года назад

Hi 민유, 코멘트 주셔서 감사합니다!

@andrewm.8109 Год назад

LOL, until recently I hadn't realized that Mario updated his favorite way to tackle ED and it's a relief! Although what he previously suggested was pretty good, it was a real pain to follow... I just go'ogled the latest in Volpstein’s Thunderous Erections, it's so much easier and potent now!

@isnanwijayakusuma2865 3 года назад

Ga paham

@DougHExcel 3 года назад

Sorry, don’t understand the comment/ question...

@isnanwijayakusuma2865 3 года назад

@@DougHExcel The meaning is Don't understand. Because english and I don't understand about economi management. That's my language "Ga paham":)🙏🏻

@LuisFernandoFranco 7 лет назад

Pfffffff... so adding the labels to each bubble is manual? Seriously? That's no problem when you have only 4 bubbles. I came to this video for a way to add labels to a chart with over 90 values. I really appreciate your tips, but I can't believe MS doesn't have a way to add labels directly to a bubble chart. Un-be-lie-va-ble

@DougHExcel 7 лет назад

in Excel 2013, MSFT finally let you do it. Right click Add Data Labels and find the option to choose Values from Cells. Then select your descriptions from a range that is associated with the series.

@LuisFernandoFranco 7 лет назад

That would be awesome... I'm using Excel 2016, I just don't find that option. Let me see if I understand, I click on "Add Data Labels", and it gives me what is in the Y axis as label. But then I don't find where can I tell Excel where to get the labels from

@LuisFernandoFranco 7 лет назад

You won't believe this. This. is. not. available. in. Excel 2016. Damn you Microsoft. In this article: peltiertech.com/apply-custom-data-labels-to-charted-points/ they explain what you said, but if I go to my Excel I see: * Series Name * X Value * Y Value * Show Leader Lines * Legend Key The "Value From Cells" is not an option in Excel 2016

@LuisFernandoFranco 7 лет назад

OK, it is now. I swear the option wasn't avilable, in fact I was copying the screen to send a report to the tech-support guys, but since I had deleted the chart, I recreated it with the total confidence it wasn't going to work, and then it appeared. Maybe sometimes ventilating in the Internet makes miracles???? Thank you, thank you very much

@DougHExcel 7 лет назад

:-D