1. Catalog
  2. Leadership & HR
  3. Gantt Charts
  4. Filterable Excel Gantt Chart Template - Pro Version
Filterable Excel Gantt Chart Template - Pro Version
  • Filterable Excel Gantt Chart Template - Pro Version
  • Filterable Excel Gantt Chart Template - Pro Version
  • Filterable Excel Gantt Chart Template - Pro Version
  • Filterable Excel Gantt Chart Template - Pro Version
  • Filterable Excel Gantt Chart Template - Pro Version
Originally published: 06/02/2024 08:22
Publication number: ELQ-64054-1
View all versions & Certificate
certified

Filterable Excel Gantt Chart Template - Pro Version

This is a 1-Year Project Planner with Filterable Gantt Chart Automated Excel Template for High-Level planning. This is the Pro version of weekly precision.

Kacharuk Marukpitakby Kacharuk Marukpitak
Business AnalystFollow
12 views|Start the discussion!|Bookmark Add to cart - $7.00
excelproject managementgantt chartproject plannertimelineproject managerfilterable
Description
🎁 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:
    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

This Best Practice includes
1 macro-enabled excel file

Acquire business license for $7.00

Add to cart

Add to bookmarks

Discuss

Further information

Project Management

Excel on desktop, with Excel Macro enabled


0.0 / 5 (0 votes)

please wait...