Simplifying our Master pricelist
Description
We require an expert to streamline our Master pricelist spreadsheet. The workbook contains extensive data, numerous VLOOKUP operations, and synchronization with our Sage database via the "Sage Data" sheet. Despite a reduced upload copy, the file remains sluggish—taking over a minute to open and delay when saving/closing. Deliverables: optimize formulas, restructure for performance, implement efficient lookup/indexing strategies or Power Query/SQL alternatives, and provide a lean, responsive workbook with documented changes and recommendations.
Budget: GBP 363 (Fixed Price)
Proposals: 21 freelancers have applied
Skills
SQL
Want AI to find more roles like this?
Upload your CV once. Get matched to relevant assignments automatically.