EXCEL 365 WORKBOOK FOR PROJECT MANAGEMENT
Descrição da oferta de emprego
Excel Workbook Developer for Project Management & Task Tracking Project Overview.
We need an experienced Excel developer to create a workbook for managing projects, tasks, and work orders, with automation features like email notifications and dynamic dashboards.
The workbook should be easy to use and compatible with Excel 365 for sharing and collaboration.
Key Features.
1.
Master Project Template.
• A template for setting up new projects, which automatically updates a master tracking log with project details.
2.
Task Tracking & Automated Notifications.
• Track tasks with start/end dates.
• Automated email notifications.
• 2 days before a task is due, the day it’s due, and 2 days after the due date (until marked as “Completed” or “Approved”).
• Notifications for vendors or subcontractors when their tasks are approaching deadlines.
3.
Dashboard.
• Dynamic dashboard showing task status, percentage complete, and a 2-week lookahead of tasks.
• Visual representation (e.
., pie chart) of project status.
4.
Work Order Request System.
• A template for requesting work orders.
• Work order requests are logged in a separate sheet and cleared upon submission.
5.
Quote Request & Vendor Sheets.
• A sheet for quote requests and one for vendor information (with hyperlinks for email communication).
• Ability to notify vendors when their tasks are approaching deadlines.
6.
Weekly Reminders.
• Email reminders to check the status of work orders assigned to others.
Additional Suggestions.
• Automated Task Status Updates.
Consider adding a feature where tasks automatically update their status based on the dates and progress tracked in the sheet (e.
., “In Progress,” “Delayed,” “Completed”).
• Gantt Chart.
A Gantt chart-style timeline for visualizing project schedules could be useful.
• Risk Tracking.
A risk log or risk management section for tracking issues and delays.
Excel Gestão de projetos ID do Projeto.
# Sobre o projeto 19 propostas Aberto para ofertas Projeto remoto Ativo em 37 minutos atrás
Detalhes da oferta
- Indeterminado
- Em todo Portugal
- Indeterminado - Indeterminado
- 27/12/2024
- 27/03/2025
Pm (hybrid)- location: lisboa for apply, send your cv for *****@***** with the reference 'records'... fórum selecção is looking for a records management office (m/f) for a corporate bank main activities: - maintain and update rmo (records management office) policy, procedures and retention schedule......
Description as a patch management analyst, you will develop maintenance schedules, deploy software updates, monitor deployments for our clients... · schedule maintenance windows for client deployments, following all implemented processes... · review software patch release notes for compatibility and......
Benefits: • apartment accommodation can be provided for the initial quarter... • minimum 3 years of professional nursing experience for candidates without a diploma... they are in search of empathetic and proficient nursing staff with expertise in nursing or medicine, capable of offering thorough care......
We are looking for a sap vendor invoice management with the following requirements: requisitos do trabalho • more than 7 year of experience;• experience in s/4 hana implementations• fluent in english; outros dados de posição • duration: contract for 12 months (minimum);• localization: porto......
A buyme property, empresa em expansão e de excelência a celebrar 25 anos de sucesso no mercado imobiliário algarvio, com escritórios em vilamoura, quarteira, almancil e faro, seleciona para buyme prestige, projeto no mercado imobiliário de luxo: project manager... responsabilidades: gestão 360º do projeto......
Knowledge of project management software (e... address technical issues and project challenges, providing solutions to keep the project on track... job summary we are looking for a motivated and detail-oriented project engineer to join our team... monitor project costs, manage budgets, and communicate......
Job description:you will be a single point of contact for the bank's clients for different types of inquiriesyou are able to manage all different types of inquiries generated via inbound activities such as chat and email... start: asap banking project: german on-siterole: as customer service agent (m/f/d)......
Job description:you will be a single point of contact for the bank's clients for different types of inquiriesyou are able to manage all different types of inquiries generated via inbound activities such as chat and email... banking project: german on-site start: 13 th december or laterrole: as customer......
The candidates book their own transportation and we will reimburse them fully (up to 700€ for external relocators and up to 150€ for internals)... job description:you will be a single point of contact for the bank's clients for different types of inquiriesyou are able to manage all different types of......
The second language required depends on the specific project... for employment beyond two years, a permanent contract may be offered... accommodation benefit: for those staying in designated apartments, this benefit is tax-free... employment term: initial contracts of 12 months, extendable for another......