Excel Data Analysis Sheet
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I need a clean, well-structured Excel workbook that will let me import sales, survey, and financial data interchangeably and analyse everything through pivot tables. The layout should separate raw data from the analysis area, so updating the source file instantly refreshes the pivot results without breaking formulas or references.
Core requirements
• One centralized “Data” tab with clearly labeled columns ready to accept any of the three data types.
• Pre-built pivot tables on a dedicated “Analysis” tab that summarise totals, averages, counts, and percentages, with slicers or filters for quick drill-downs by date, category, region, or any other common field that appears in the upload.
• No static ranges—use Excel Tables so the pivots expand automatically when new rows are added.
Please keep formulas light and avoid unnecessary features like charts, graphs, or complex statistical add-ins; the focus is strictly on pivot-table reporting. After delivery, a short note inside the file (or a separate text document) explaining where to paste fresh data and how to refresh the pivots will be enough for me to maintain the sheet on my own.
Core requirements
• One centralized “Data” tab with clearly labeled columns ready to accept any of the three data types.
• Pre-built pivot tables on a dedicated “Analysis” tab that summarise totals, averages, counts, and percentages, with slicers or filters for quick drill-downs by date, category, region, or any other common field that appears in the upload.
• No static ranges—use Excel Tables so the pivots expand automatically when new rows are added.
Please keep formulas light and avoid unnecessary features like charts, graphs, or complex statistical add-ins; the focus is strictly on pivot-table reporting. After delivery, a short note inside the file (or a separate text document) explaining where to paste fresh data and how to refresh the pivots will be enough for me to maintain the sheet on my own.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.