📌 Be more productive and manage processes with a KANBAN BOARD in Excel, I explain from scratch how to do it automatically and dynamically.
In this tutorial you are going to learn to create from scratch a productive tool such as the KANBAN BOARD, a way of visualizing the processes with colorful cards and with different parameters that help to identify the processes faster, you will see how your work team moves and detect bottlenecks, as well as the priority of each activity.
We will apply automatic tables, dynamic tables, segmenters and search functions that will allow us to make the board dynamic, a simple way to manage it in Excel.
#Excel #LoganExcel #kanban
🔴 Subscribe 👉 / @loganexcel
📃 Download File
📌Related Videos
✅ Ishikawa diagram • Diagrama de Ishikawa e...
✅ SWOT Analysis • Análisis FODA en Excel...
✅ Eisenhower Matrix • Matriz de Eisenhower e...
⏱️ Timestamps ⏱️
01:36 Create list of activities and responsible
03:10 We make an automatic table of activities
05:44 Pivot table in tabular format
09:15 Name manager for ranges
10:52 Automatic search engine based on parameters
13:51 Advanced index and match function
20:41 Return to Dashboard the searches
26:13 Conditional formatting on priorities
32:14 Segmenter by responsible, priority, time
35:02 Progress graph in Excel
Also follow me on my Networks 📲:
🔹Facebook / logan-excel-1008353283...
🔹Blog loganexcel.word...
🔹Instagram www.instagram....
26 авг 2024