Relates to planning the interdependent tasks of an operationnal team of 6 staff. Creating an interactive sheet where all team members will capture whether and when they have completed a given standard tasks, and that will visualize on daily basis advancement and show delays etc.
Project management (sort of gantt-type): each client/contract has a 6 months cycle with standardized tasks - tasks relate to each other : sequence + min/max delays between tasks.
Excel expertise required in: conditionnal formatting with multiple conditions (date in other cells, date of the current day, value of cells of earlier days) ; automatic cells/zone locking/protection in function of dates and/or value of other cells ; complex formulas combining multiple conditions (using IF, LOOKUP ...) depending on current day date, dates , value of other cells, etc.
ps: will share sketch/overview later
12 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello Sir, please provide all required material asap so i will complete this task within time with quality skills. i hope you will contact me in future for more projects.