Filterable Excel Gantt Chart Template - FREE VERSION (bi-weekly precision)

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
3. This is the FREE version with the precision of bi-weekly precision.
   The Pro version of weekly precision can be purchased from here.
   

🧑‍💻👨‍💻Software Requirement🧑‍💻👨‍💻
Microsoft Office 365, 2013, 2016, 2019 for Windows; orMicrosoft 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 2 weeks) 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:
1. Tasks/sub-tasks for each month: Buttons above each month name
2. Tasks/sub-tasks for each Quarter : Q1/Q2/Q3/Q4 buttons
3. Tasks/sub-tasks for the first or latter half : H1/H2 button
4. Tasks/sub-tasks throughout the year : All button