Posts Tagged ‘word’

Example SWOT analysis and follow up action sheet built using Word & Excel

As we said in our article on SWOT analysis – The SWOT is a great tool for capturing information and issues relating to your business (in particular it can be used during strategic planning) – we also think it makes a great addition to a standard monthly management reporting pack.

Luckily you don’t need any special tools or software to produce a SWOT and the simple 4 box template is easy to setup in MS Word.

Due to the nature of a SWOT analysis capturing pieces of information that often require follow up actions we like to pair our SWOT with a simple action list which you can build in Excel – this takes the items captured within your SWOT and turns them into a simple plan with owners and review dates. Why do this? Well all too often you’ll construct a SWOT analysis and use it in a presentation or report but there is a tendency to forget all about it and move on to the next business issue – this simple action plan allows you to record those issues you need to follow up on in a simple straightforward way.


SWOTS can be easily constructed using MS Word – go for a 4 box (one for each element) or as we like to do a 3 x 3 this enables you to articulate which elements are internal/external and which are positive/negative attributes – this may not mean much to you but if your going to be communicating your SWOT to anyone unfamiliar with the tool it can be really helpful. The other thing to remember is when you add your inputs into the SWOT remember to number them so that you can refer to the numbers in your action tracker.

The Action Plan

We like to couple our SWOT tool with a simple action plan tracker that captures the inputs from the SWOT and turns them into a list that can be used to track activity and attribute owners. We’ve chosen to do this in Excel (but you could easily create a list in MS Word to do it).

Example SWOT video