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.
Dance Outdoor Shoot Category: Creative Design, Motion Graphics, Photography, Video Editing, Video Production, Video Services, Videography Budget: ₹1500 - ₹12500 INR
04-Aug-2025 16:03 GMT
Dynamic Promotional Video Editing Category: A / V Editing, Adobe Premiere Pro, After Effects, Commercials, Final Cut Pro, Video Editing, Video Production, Video Services Budget: $30 - $250 CAD