Dynamic Task Dependency Workflow in Excel
Budget: $50 – $75 USD
I'm seeking an Excel expert to create a dynamic workflow managing task dependencies.
Key Requirements:
- Understanding of task dependencies
- Proficiency in creating dynamic Excel models
- Ability to visualize task dependencies in various ways
- Experience in creating Gantt chart visualizations in Excel for task dependencies.
- Ability to write macros and VBA scripts to automate task dependency updates.
- Expertise in using pivot tables to dynamically filter and analyze task data.
- Proficiency in using conditional formatting to highlight critical paths and dependencies.
- Experience incorporating data validation to prevent incorrect task entries.
- Experience in designing user-friendly interfaces within Excel for ease of use.
The ideal freelancer for this project will be quick, efficient and able to comprehend my requirements without much guidance. Please note, I'm uncertain about the best way to visualize task dependencies in Excel, so your expertise and suggestions will be invaluable.
The workflow should include a dependency matrix that updates automatically when tasks are changed, but also allows for manual adjustments at times.
Skills & Experience:
- Advanced Excel skills
- Experience with project management tools
- Ability to create dynamic and user-friendly Excel models
Key Requirements:
- Understanding of task dependencies
- Proficiency in creating dynamic Excel models
- Ability to visualize task dependencies in various ways
- Experience in creating Gantt chart visualizations in Excel for task dependencies.
- Ability to write macros and VBA scripts to automate task dependency updates.
- Expertise in using pivot tables to dynamically filter and analyze task data.
- Proficiency in using conditional formatting to highlight critical paths and dependencies.
- Experience incorporating data validation to prevent incorrect task entries.
- Experience in designing user-friendly interfaces within Excel for ease of use.
The ideal freelancer for this project will be quick, efficient and able to comprehend my requirements without much guidance. Please note, I'm uncertain about the best way to visualize task dependencies in Excel, so your expertise and suggestions will be invaluable.
The workflow should include a dependency matrix that updates automatically when tasks are changed, but also allows for manual adjustments at times.
Skills & Experience:
- Advanced Excel skills
- Experience with project management tools
- Ability to create dynamic and user-friendly Excel models