Excel Lookup Pivot Report
Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I need an Excel specialist to transform a raw data workbook into a polished, refresh-ready report. The core of the task is wiring together several data sheets with VLOOKUP and HLOOKUP, then driving a clear summary through Pivot Tables. Whether the final view ends up looking like a sales, financial, or inventory snapshot, the goal is the same: a concise report I can regenerate each time I paste in new data.
What I will give you:
• A multi-tab .xlsx file containing the source data.
• A rough sketch of the information the finished report should display.
What I expect back:
• Clean, well-labeled VLOOKUP and HLOOKUP formulas that pull the right fields every time.
• One or more Pivot Tables structured so the summary sheet instantly updates on refresh.
• A short, plain-language note (or comments inside the file) explaining how to add new data and refresh the report.
If you can see a smarter or faster way to achieve the same outcome, feel free to suggest it—accuracy and ease of maintenance are my priorities.
What I will give you:
• A multi-tab .xlsx file containing the source data.
• A rough sketch of the information the finished report should display.
What I expect back:
• Clean, well-labeled VLOOKUP and HLOOKUP formulas that pull the right fields every time.
• One or more Pivot Tables structured so the summary sheet instantly updates on refresh.
• A short, plain-language note (or comments inside the file) explaining how to add new data and refresh the report.
If you can see a smarter or faster way to achieve the same outcome, feel free to suggest it—accuracy and ease of maintenance are my priorities.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.