Lessons Learned Template Excel Download

by Elina D

What is lessons learned in project management?

Lessons learned (LL) is a term in project management that aims to analyze a process/task that was previously done in an organization and yielded a positive or negative outcome. Learning from one’s past mistakes is a great way to improve the next project/task/ assignment outcome.

lessons-learned-template-excel,Lessons Learned Template
Lessons Learned Template Excel

When should you have the lessons learnt meeting?

It is important to have this meeting as soon as possible to not forget about the issues faced. The best time is to have it within the first two weeks of project completion or max a month after completing the project. Everyone who had worked on the project, including the sponsor, should be included in the meeting.

Why is it necessary to conduct a Lessons learnt meeting?

To analyze a certain situation and help the organization improve, lessons learned process should be conducted periodically during the projects’ life cycle. It is good practice to conduct a more detailed, in-depth lessons learnt meeting at the beginning and conclusion of a project.

The purpose of a Lessons Learned Meeting is for the project team to discuss different challenges that the team faced during the project. After the meeting is complete, the Project Manager should capture all the lessons learned in a document and publish it to a wide audience.

project-closure-agenda,Project Closure Agenda, lessons learned, lessons learned project management

Project Closure Agenda

The process to conduct an effective lesson learnt meeting -

Step 1: Setting the standard

This is the setup phase that will cover how the process will work for all future projects. his step includes the following tasks – Agreeing on the criteria: Agree with all key stakeholders of the delivery division what the standards of a successful project are, and when an outcome is deemed positive or negative. Templates and Tools: Set up a template used to analyze the outcome and record the LL’s. Purchase / develop tools that will assist in the retrieval of LL’s for future projects. Questionnaire: Write the questions that will be asked before and after each project to allow the team to avoid making previous mistakes.

Step 2: Working on the process

After all the preliminary steps have been completed, now the actual analysis is done. This step includes the following tasks – PVA (Planned vs. Actual): Compare what actually happened in a project instead of what was planned. This should be done regarding the budget, timeline, milestones, quality, workload, and sourcing. Conduct research interviews with the project manager, team, key stakeholders, and vendors. In the interviews, the below questions should be asked.
A similar process can be conducted with the client.


Step 3: Analyze the answers, and compile the conclusions.

After all the information is gathered and analyzed, clear, concise LL’s need to be reached and made readily accessible to all.

Lessons Learnt Questions Examples

  1. What was your understanding of the customers’ needs?
  2. When the project started, what was your expectation of the outcome?
  3. Would this outcome have solved the problem that the customer was facing back then?
  4. Did the final product/service solve the problem?
  5. What was your understanding of the promised outcome made to the customer (formally and informally)?
  6. Did you have all the required tools and knowledge for undertaking this venture?
  7. Were the entry and exit criteria of each phase of the plan clear and correct?
  8. What did you focus on during the project (quality, timeline, income, etc.)?
  9. Were the internal enabling divisions (sourcing, management, admin, IT helpdesk, etc.) helpful during the lifecycles?
  10. Was the communication (internal and external) sufficient? This question can cover both status updates and knowledge sharing.
  11. Was the workload balanced between the teams, and was the allocation of resources adequate?
  12. Which risks were you aware of during the projects’ lifecycle?
  13. Which risks weren’t you aware of during the projects’ lifecycle?
  14. Was the documentation sufficient?
  15. When facing a problem: did you review the LL’s from previous projects?
  16. In hindsight, what would you have done differently?
  17. Was the business case for the project shared with the key stakeholders and approvers?
  18. Did the business case capture all the project benefits?
  19. Was the team informed about the importance of this project from a business perspective?
  20. Was the team made aware of the key project dates?
  21. Were there any obstacles in getting funding approved for the project?
  22. Was the project team aware of the key milestones?
  23. Did the project team have access to project plans?
  24. Was a detailed WBS created for the project?
  25. Did the project have adequate resources allocated?
  26. Was there a detailed risk assessment conducted for the project?
  27. Did the project tasks start on time?
  28. Why did we have so many defects in the QA cycle?
  29. Did the change management plan cover all the aspects of change this project would bring out?
  30. Was adequate time given to complete all the tasks?
  31. Did the team complete all the tasks on time?
  32. Did we have any issues with the project go live?
  33. Were all the proper handover procedures followed?
  34. Did we see any issues after the business started using the system?
  35. Was the project report issued?
  36. What was the root cause behind the performance issue?
lessons-learned-meeting-agenda

Lessons Learned Meeting Agenda Template

Lessons learned meeting best practices -

  1. Ensure the meeting starts on time and finishes on time.
  2. Someone needs to take notes. It is recommended that the person taking notes is different from the person hosting the meeting.
  3. The motivation behind having this meeting is to improve, and we are humans. We do make mistakes – so no personal remarks.
  4. The decisions should always be focused on how we can improve – so keep it positive.
  5. No talking over when others are talking. Everyone needs to be given a chance to speak.
  6. The host of the meeting should be asking all the questions and write the responses on the whiteboard as the team gives their feedback.
  7. If you have anyone very senior joining, then make sure you understand their expectation.
  8. Timebox questions and ensure that discussions do not go on a different tangent.
  9. Ask everyone to come prepared to the meeting with points they want to discuss. It is worth publishing the agenda beforehand.
  10. Phones, tablets, and laptops on silent.
  11. Always publish the agenda at least 3 days before the meeting.
  12. You may be interested in checking out other meeting templates like MOM formats.
lessons-learned-examples,lessons learnt examples, lessons learned example, lessons learned template

Lessons Learnt Examples

Examples Of Lessons Learnt

  1. The projects' actual budget exceeded the planned figure - Utilize a project management method that measures the workload on the team and ascertains whether it's balanced and the deadline can be achieved. This will minimize the delays and reduce costs.
  2. Poor quality of delivered goods - Have each SW code scrutinized internally before its release to the customer.
  3. Management doesn't understand the project's status - Instead of performing one long status update meeting that aims to cover all aspects of the project, have many short meetings with clear status and requests for help from management.
  4. Re-training - The training effort yielded low scores from the users.
  5. Slow system performance - The response time of the new system is slow.
  6. Uneven income - The majority of payments for the project were received towards the end of the lifecycle.
  7. Sourcing timeline was too long - Include a sourcing SME in all initial communication with the client when the needs are agreed upon.

Read - Difference between Lessons Learned Meeting and Sprint Retrospective Meeting