Advanced Excel Analysis Customization
Budget: $30 – $250 USD
We are looking for an experienced Excel freelancer to develop a comprehensive and automated spreadsheet for our order management process. The ideal candidate will have a strong background in creating user-friendly, flexible, and professional spreadsheets that can generate reports and metrics efficiently.
Project Requirements:
1. Masterfile Creation:
• Develop a central masterfile for order management.
• The masterfile should be easy to update with new data.
2. Automated Reporting:
• Generate automated delivery reports.
• Create financial metrics, OTIF (On-Time, In-Full) metrics, and summary reports.
• Ensure all reports are linked to the masterfile for real-time data reflection.
3. User-Friendly Design:
• The spreadsheet must be easy to navigate and edit, enabling seamless handover to other team members.
• Provide instructions or a brief guide for users on how to update and maintain the spreadsheet.
4. Professional Layout:
• The spreadsheet should be aesthetically pleasing and professionally laid out, suitable for management presentations.
• Include features like drop-down menus, conditional formatting, and pivot tables for enhanced functionality.
Skills Required:
• Advanced Excel skills, including VBA/macros, pivot tables, and data visualization.
• Experience in creating automated reports and dashboards.
• Strong attention to detail and ability to deliver a polished, professional final product.
• Good communication skills for understanding our specific needs and providing ongoing support if required.
Deliverables:
• A fully functional and automated Excel masterfile with the required features.
• Instructions or documentation for end-users.
• Initial support for implementation and any adjustments.
Project Requirements:
1. Masterfile Creation:
• Develop a central masterfile for order management.
• The masterfile should be easy to update with new data.
2. Automated Reporting:
• Generate automated delivery reports.
• Create financial metrics, OTIF (On-Time, In-Full) metrics, and summary reports.
• Ensure all reports are linked to the masterfile for real-time data reflection.
3. User-Friendly Design:
• The spreadsheet must be easy to navigate and edit, enabling seamless handover to other team members.
• Provide instructions or a brief guide for users on how to update and maintain the spreadsheet.
4. Professional Layout:
• The spreadsheet should be aesthetically pleasing and professionally laid out, suitable for management presentations.
• Include features like drop-down menus, conditional formatting, and pivot tables for enhanced functionality.
Skills Required:
• Advanced Excel skills, including VBA/macros, pivot tables, and data visualization.
• Experience in creating automated reports and dashboards.
• Strong attention to detail and ability to deliver a polished, professional final product.
• Good communication skills for understanding our specific needs and providing ongoing support if required.
Deliverables:
• A fully functional and automated Excel masterfile with the required features.
• Instructions or documentation for end-users.
• Initial support for implementation and any adjustments.