Achieve Innovative Process Improvement+Standardization by IT System with MS 365.

How to Make a SWOT Analysis and the Project Selection Matrix【Excel Template】

\ この記事を共有 /
How to Make a SWOT Analysis and the ...

You can use a SWOT analysis to analyze your company and yourself with indicators of strengths, weaknesses, opportunities, and threats, and then what to do next. It is important to find the task by answering the four questions in the template. Let’s do it immediately with the SWOT analysis template.

(Duration: 4:10)

DOWNLOAD  ← Click this to download the “SWOT Analysis and Project Selection Matrix” template file.

<< Related Videos >>

“SWOT Analysis and Project Selection Matrix” template

Hi, this is Mike Negami, Lean Sigma Black Belt.

I received a question from one of my viewers, “How should we select a project?”  Therefore we’ll discuss that today.  If you have any questions, please contact me from this contact form.

I’ve talked about this often, when you do something, it’s very important to understand the current and past situations, beforehand.  The same thing applies before project selection.  The popular SWOT Analysis is the perfect tool for that. And I made an Excel template for it.

DOWNLOAD  ← Click this to download the “SWOT Analysis and Project Selection Matrix” template file.

“SWOT Analysis”: Analyze your business environment.

This template’s special feature is that it has two SWOT tables.  With the first table, you can do an analysis for your entire Group or company.  With the second table, you can do an analysis for your company in the Group, your department or yourself.

Since our recent business environment is very complicated, with the dual SWOT analysis, you can understand the current situation well and deeply. Please start from the first table for better results.

SWOT Analysis

SWOT stands for Strength, Weakness, Opportunity and Threat. In each quadrant, write your company’s strong points and weak points, which are internal factors, opportunity points and threat points, which are external factors.  It’s a good idea to do this with your team.

What’s important here is to answer the next four questions: “How can you utilize your strengths?” “How can you convert your weaknesses to strengths?” “How can you convert your opportunities to strengths?” and “How can you convert your threats to opportunities?”  The instructions in the template shows these four questions too.

The 4 questions after conducting SWOT Analysis

Your answers will become project ideas and great hints for your project selection.  Let’s do the same analysis toward your department or yourself. At that time, refer to the first analysis results, then you should find new discoveries.

“Project Selection Matrix”

Scroll down a little more.  There is the Project Selection Matrix.  First, list up project candidates while considering the SWOT Analysis results above and fill out those names in the blue column.

Project Selection Matrix

Next, enter selection criteria in the green row. Common criteria: “Degree of Impact”, “How low is Cost” and “Degree of Feasibility” are there, but you can change them and/or add your company’s specifics.  Then, enter each selection criterion’s weight, 1 to 5, in the pink row.  (5 is highest.)

Lastly, compare all of your project candidates and score 1 to 5 in the yellow cells by each criterion. Please also consider the dual SWOT analysis’s results during this session.  Then, weighted total scores will be shown.  The higher the score, the higher priority the project becomes.

With the example above, Project A has the highest priority.  Of course, it’s not like you have to select the highest scored project, but since you can compare objectively with numbers, it’s very helpful for your decision.

Today, I talked about how to frame project ideas and select a project.

Thank you very much for viewing. Please click the ‘Subscribe’ button. Also click and watch my other related videos. Thanks.

Copyright©Process Improvement & IT Consulting |,2023All Rights Reserved.