• How to Make a BCG Matrix in Excel
  • How to Make a BCG Matrix in Excel
  • How to Make a BCG Matrix in Excel
  • How to Make a BCG Matrix in Excel
Originally published: 16/01/2018 16:00
Last version published: 02/03/2018 15:25
Publication number: ELQ-33571-2
View all versions & Certificate
certified

How to Make a BCG Matrix in Excel

Teaching you step-by-step how to create a BCG Matrix in Excel using a screen-sharing method.

bcg matrixexcelgrowthmake your ownmappingmarket growthmarket sharerevenue

Description
This video will teach you start to finish, step by step, how to create your BCG Matrix in Excel.

To start with you need some data. In this case, data has been made up for a hypothetical retailer which has 3 divisions. What's needed is their market share, their largest competitor's market share, the growth rate for each of the markets, and overall revenue. So in this case, as an example, the supermarket chain has 30% market share; it's the market leader. The next largest competitor is behind; it has 20% market share,. There is 5% growth in supermarkets across the industry, and other largest revenue in billions is worth 20 billion dollars in revenue. Relative market share must be calculated which is fairly straightforward.

Relative Market Share, Market Growth, and Firm's revenue are the 3 sections used to create the BCG Matrix.

Length: 7 minutes 47 seconds

This business tool includes
1 Video File

Add to bookmarks

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

Any questions on How To Make A BCG Matrix In Excel?

The user community and author are here to help. Go ahead!

please wait...