Рет қаралды 33,639
⏱ Manage activities by schedule and control status, PENDING, PROCESS and FINISHED and plan better.
In today's video we are going to develop a project management tool for planning activities according to a schedule, for this we will make a gantt chart, we will have a start and end schedule to determine the duration of each activity, we will use functions conditional and drop-down lists to place a status of said activity, this will be automatic and will change the color according to the status.
#Excel #LoganExcel #GanttChart
🔴 Subscribe 👉 / @loganexcel
📃 Download File
📌Related Videos
✅ Eisenhower Matrix • Matriz de Eisenhower e...
✅ SWOT • Análisis FODA en Excel...
⏱️ Timestamps ⏱️
00:00 Introduction
02:22 Create activity list
04:52 Automate status with dropdown list
05:43 Conditional function
07:46 Gantt chart in Excel
12:37 Color at each state of the diagram
Also follow me on my Networks 📲:
🔹Facebook / logan-excel-1008353283...
🔹Blog loganexcel.wordpress.com/
🔹Instagram loganexcel...