핵심 요구사항
- 원본 판매 데이터 클렌징 및 테이블 형식으로 재구성
- 총합/추세를 즉시 파악 가능한 요약 행 포함
- 날짜→제품 순으로 그룹화된 피벗테이블 작성 (총 매출, 거래 건수)
- 슬라이서/필터 추가 (선택, 단순·인쇄 가능한 레이아웃 유지)
- 수식·피벗 옵션 잠금 해제로 이후 감사·새로고침 가능하게 유지
Required stack
필요 기술
ExcelExcel VBAExcel MacrosPivotTableData ProcessingData VisualizationData Analysis
Project brief
프로젝트 내용
I have a raw sales workbook that needs to be turned into a clean, analysis-ready file.
The finished file should open on a neatly structured table with a clear summary row, so that anyone can instantly read totals and spot trends without scrolling through cluttered data.
Inside the same workbook, I also need a PivotTable that reports two key metrics—“Total sales” and “Number of transactions”. The pivot must allow me to look at those figures grouped first by date and then by product. Feel free to add slicers or filters if that speeds up exploration, but keep the layout simple and printable.
Deliverables:
• One Excel file (.xlsx) containing
– A cleaned data sheet formatted as a Table with summary row
– A PivotTable showing Total sales and Number of transactions, grouped by date and by product
• All formulas and pivot options left unlocked so I can audit or refresh later
I’ll provide the current spreadsheet as soon as we start. Accuracy in the transformation is more important than speed, but I’d like the first draft within a day if possible.
The finished file should open on a neatly structured table with a clear summary row, so that anyone can instantly read totals and spot trends without scrolling through cluttered data.
Inside the same workbook, I also need a PivotTable that reports two key metrics—“Total sales” and “Number of transactions”. The pivot must allow me to look at those figures grouped first by date and then by product. Feel free to add slicers or filters if that speeds up exploration, but keep the layout simple and printable.
Deliverables:
• One Excel file (.xlsx) containing
– A cleaned data sheet formatted as a Table with summary row
– A PivotTable showing Total sales and Number of transactions, grouped by date and by product
• All formulas and pivot options left unlocked so I can audit or refresh later
I’ll provide the current spreadsheet as soon as we start. Accuracy in the transformation is more important than speed, but I’d like the first draft within a day if possible.
지원 기회 분석
지원 전에 볼 것
예상 산출물
- 정리된 데이터 시트(요약 행 포함 테이블)가 담긴 .xlsx 파일 1개
- 총 매출·거래 건수를 날짜·제품별로 보여주는 피벗테이블
매력 포인트
- 명확하고 구체적인 산출물 스펙
- 짧은 단기 작업으로 부담이 적음
확인할 점
- 예산 표기가 '$750~$1,250 INR'로 통화 단위가 모순됨 (USD인지 INR인지 불명확)
- 실제 원본 스프레드시트를 착수 후에야 제공한다고 하여 작업량 산정이 어려움
Client signal
클라이언트 정보
플랫폼에서 상세 정보를 확인하세요.