Customer Data Spreadsheet Management & Analysis
Budget: $15 – $25 USD
The project centres on keeping our customer database clean, organised, and genuinely useful for decision-making. Every day I export raw sign-up lists from several sources; they land in Excel, Google Sheets, and occasionally Word tables. I need a detail-oriented female administrative professional who can take those disparate files, consolidate them, and turn them into meaningful insights while maintaining crystal-clear communication with me throughout the process.
The core work involves:
• Importing, deduplicating, and normalising new customer records inside shared Google Sheets or Excel workbooks.
• Using formulas, pivot tables, and simple charts to highlight purchasing trends and engagement patterns.
• Preparing a succinct weekly summary in Word (or Google Docs) that lays out key findings and flags any data issues that need my attention.
Acceptance criteria: spreadsheets are free of errors and duplicates, calculations are transparent, and the weekly report arrives every Friday before 17:00 WIB, ready for direct presentation to management.
Strong command of Microsoft Office, Google Sheets, and a proactive communication style are essential, and enthusiasm is always welcome.
The core work involves:
• Importing, deduplicating, and normalising new customer records inside shared Google Sheets or Excel workbooks.
• Using formulas, pivot tables, and simple charts to highlight purchasing trends and engagement patterns.
• Preparing a succinct weekly summary in Word (or Google Docs) that lays out key findings and flags any data issues that need my attention.
Acceptance criteria: spreadsheets are free of errors and duplicates, calculations are transparent, and the weekly report arrives every Friday before 17:00 WIB, ready for direct presentation to management.
Strong command of Microsoft Office, Google Sheets, and a proactive communication style are essential, and enthusiasm is always welcome.
Related categories:
Data Processing
Data Entry
Excel
Report Writing
PDF
Web Search
Data Cleansing
Data Analysis
Google Sheets
Data Management