How to Make the BCG Matrix in Excel 365
This is a detailed step-by-step walk-through of how to create the BCG matrix in Excel 365. It also includes an instructional video.
This is a detailed step-by-step walk-through of how to create the BCG matrix in Excel 365. It also includes an instructional video.
Using the Free BCG Matrix Excel Template This page contains instructions and a video on how to use the free BCG Matrix Excel template available for download on this website. Here is a how-to-use video for the free BCG Matrix, and please scroll down for the written step-by-step instructions. How to Use the BCG Matrix … Read more…
Need a list of Business Strength and Market Attractiveness Factors to use in the GE-McKinsey multi-factor matrix? To make it easy to design and produce the GE matrix, an Excel template is available for free download on this website. This Excel template has been pre-populated with the following list of possible BUSINESS STRENGTHS: Brand equity … Read more…
GE-McKinsey Matrix Excel Template The GE matrix is now officially known as the GE-McKinsey nine-box matrix. According to the McKinsey website, the framework “offers a systematic approach for the multibusiness corporation to prioritize its investments among its business units. It was developed in the 1970s, after the development of the Boston Consulting Group (BCG) matrix. … Read more…
About the Matrix Maker A matrix demonstrates the relationships between two attributes in a visual graph format, similar to a scatter-plot chart. However, it is often time-consuming for someone new to Excel to construct a matrix, as the chart needs a reasonable amount of formatting. That’s why have developed a free Excel matrix template for … Read more…
This article details the formulas and calculations required to construct the BCG matrix, namely Relative Market Share and Market Growth Rate.
Quick Overview of the BCG Matrix For those people familiar with the BCG matrix, you should recall that the horizontal axis measures relative market share. This is the more important of the two dimensions. A high or low relative market share makes the difference between a cash cow and a dog or a star and … Read more…
It should be remembered that the economic conditions and key business goals have changed substantially since the BCG matrix was initially developed in the late 1960s. As a result, a slight redesign of the matrix is probably required to make it more usable and logical to today’s business world. Design of the X axis/relative … Read more…
One of the challenges with the design of the BCG matrix is the decision of what values to place the axes in order to create the four quadrants. Unlike as suggested in other areas of the Internet, these four quadrants do not have to be equal in size. For example, there is one video online … Read more…
The details on the analysis approach to the BCG matrix have been expanded to the full menu – or use the search box.