Filterable Excel Gantt Chart Template - FREE Excel Project Planner
Originally published: 12/08/2021 08:32
Publication number: ELQ-72198-1
View all versions & Certificate
certified

Filterable Excel Gantt Chart Template - FREE Excel Project Planner

1-Year Project Planner with Filterable Gantt Chart Automated Excel Template for High-Level planning.

Description
This is a 1-Year Project Planner with Filterable Gantt Chart Automated Excel Template for High-Level planning.

🎁 Key Features 🎁
1. Super easy task entry - just enter key letter to mark the duration and the sheet will automatically visualize the plan for you.
2. Ability to filter for tasks by month / quarter / half of the year

🧑‍💻👨‍💻Software Requirement🧑‍💻👨‍💻
Microsoft Office 365, 2013, 2016, 2019 for Windows; or
Microsoft Office 365 for Mac

👉 Prerequisite 👈
Excel Macro has to be enabled

📝 Instruction 📝
1. Enter Task name in column B of the table
2. Enter Sub-Task name in colume C
3. Enter t character to mark the duration of the task or sub-task between columns D to AY (1 column equates to a week)
Tip: To mark t in multiple cells at once : select multiple cells, enter t, then press Ctrl + Enter
4. Change from t to d to mark part of the durations as done.
5. To add more row, press the Add Row button which can be found right beneath the table
6. You can use the buttons above the table to filter for:
6.1 Tasks/sub-tasks for each month: Buttons above each month name
6.2 Tasks/sub-tasks for each Quarter : Q1/Q2/Q3/Q4 buttons
6.3 Tasks/sub-tasks for the first or latter half : H1/H2 buttons
6.4 Tasks/sub-tasks throughout the year : All button

This Best Practice includes
1 Excel file

Kacharuk Marukpitak offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Project Planning / Activities Planning


5.0 / 5 (1 votes)

please wait...