KanBan Board tasks management

KANBAN Board tasks management

FREE DOWNLOAD

Plan and monitor your project activities and view Kanban board, using this flexible free excel template made by QuickWinsLab and FreeExcelTemplates. You can record all project tasks with respective planned start and end dates (if any) and view their progress.

What you will get

  • One FREE excel template with sample data, to see how it works
  • One FREE blank excel template, to populate your data from scratch

Requirements and important features

This professional but yet FREE excel template works with excel for Microsoft 365. If you do not have a subscription then you are strongly advised to do so, as otherwise you will be missing a lot of new functionalities and risk the template not to work.

The template contains NO VBA, NO MACROs, only Pivot Tables.

 

 

Description

This template is simple but dynamic project/task management tool with Kanban board and dashboard. Kanban is a project management tool that allows you to get a visual overview of the tasks that need to be done or are complete. In its basic form, it consists of a board with three columns (To Do, In Progress, Done) and tasks are listed as story cards.
Our Kanban board consists of up to 6 configurable columns (statuses) which provides great flexibility to project managers. It is also extended so as to record and report teams and assignees, as well as start and end dates and therefore to provide visual signal in case of overdue task. It also allows you to assign priority and monitor it visually on the board.
 

Main features

  • Teams and team members assigned with tasks of the project
  • Configuration of statuses
  • Projects, so as to include all the projects of your team and filter by project so as to have individual overview
  • Tasks
  • Kanban board, with filtering through slicers by Project, Priority, Assignee, status and Overdue or not
  • Dashboard with important KPIs (Total tasks, progress, total overdue tasks and graphical distribution of tasks by assignee and status, and by assignee and priority

View it in action



Instructions

The first sheet of the template includes instructions on how to work with it.

 

Other info

  • The template is unlocked. Some worksheets may be protected, so as to avoid random unwanted modifications in cells, but you may unprotect them at any time - no password needed.
  • Built for Excel for Microsoft 365
  • The template has the look and feel of a non-excel application (hidden sheet tabs, hidden headers and gridlines). You may unhide all above following the instructions included in the first page (sheet) of the template.
  • You are advised to always keep a backup of the blank template, in order to re-use it or in case of mistakenly breaking the working template - Just put your raw data (without the calculated fields) to a copy of the blank template and you are ready!

 

This template may not be distributed or sold, published to an online gallery or hosted on a website or server in a way that makes it available to the general public