Excel Spreadsheet Optimization and Cleanup

## Excel Specialist Needed for Stock Department Process Overhaul

### Project Overview
We are seeking an experienced Excel professional to streamline and optimize our Stock Department's operational processes at a Festival Bar Operator. Our current system relies on multiple spreadsheets that lack integration, leading to inefficiencies and data inconsistencies. The goal is to simplify, automate, and visualize data to reduce errors and enhance usability.

### Objectives
- Understand the current process through demonstrations and sample documents.
- Develop a user-friendly, automated solution using Excel or relevant tools (e.g., Power Query, VBA, or Power BI).
- Implement data validation, reduce human error, and improve reporting.
- Provide clear documentation and training for staff.

### Scope of Work
- Evaluate current spreadsheets and identify areas for improvement.
- Design and implement an integrated, streamlined system.
- Conduct testing and refine as needed.
- Deliver staff training and support.
- Potential for further development in areas like revenue tracking, sales mix data, and cross-departmental processes.

### Requirements
- Proven experience in Excel automation and data management.
- Expertise in VBA, Power Query, and relevant tools.
- Familiarity with API lookups is a plus.
- Understanding of bar operations and stock management preferred.

### Timeline and Budget
- **Start:** ASAP
- **Completion:** Initial phases ASAP, with opportunities for ongoing work.
- **Budget:** Flexible based on scope and outcomes.

### Application Process
Please submit:
- A brief cover letter detailing relevant experience.
- Examples of past Excel projects.
- Your proposed approach and estimated timeline.

We look forward to working with a skilled professional to enhance our Stock Department’s efficiency.