We are looking for an Excel expert to develop a comprehensive pricing tool for our sales team, covering approximately 200 SKUs across three currencies (GBP, USD, EUR). This tool must streamline price calculations, display product images, and allow for quick searches by product name.
Project Scope: ✅ Three Currency Sheets – Separate pricing sheets for GBP, USD, and EUR, with automatic currency conversion. ✅ Dynamic SKU Pricing – Automated calculations based on materials, customizations, and quantity. ✅ Image Integration – Ability to display product images next to SKUs. ✅ Search Functionality – Quick search/filtering by product name for easy navigation. ✅ Cost & Margin Calculation – Include built-in profitability metrics (cost, margin, and contribution calculations). ✅ User-Friendly Interface – Dropdown selections, conditional formatting, and structured layout for ease of use.
Ideal Candidate: ✔ Proficient in Excel (advanced formulas, data validation, pivot tables). ✔ Experience with large datasets (handling 200+ SKUs efficiently). ✔ Knowledge of image embedding in Excel (linking or displaying product visuals). ✔ VBA/macros experience is a plus for automation and enhanced functionality.
