Excel Date Comparison & Formatting
Budget: €30 – €250 EUR
I have several Excel spreadsheets filled with statistical entries recorded on different dates. I need the date columns repaired and standardised first, then a reliable way to compare each entry across the sheets so perfect matches surface immediately.
Once the data is aligned, A small dashboard or set of charts inside the workbook is perfect; I want to see the movement at a glance.
Everything must stay in .xlsx format. Use familiar Excel tools—formulas, conditional formatting, PivotTables, maybe Power Query if it speeds up the cleaning—so I can inspect or tweak them later.
Deliverables:
• Cleaned and consistently formatted spreadsheets
• Automated comparison logic for the date-based entries
• Standard deviation results for each metric
• Trend analysis visuals (charts or mini dashboard)
• Short walkthrough or comments explaining where to find and adjust each part
When it’s done I should be able to drop in new monthly data, press refresh, and have the workbook update itself.
Once the data is aligned, A small dashboard or set of charts inside the workbook is perfect; I want to see the movement at a glance.
Everything must stay in .xlsx format. Use familiar Excel tools—formulas, conditional formatting, PivotTables, maybe Power Query if it speeds up the cleaning—so I can inspect or tweak them later.
Deliverables:
• Cleaned and consistently formatted spreadsheets
• Automated comparison logic for the date-based entries
• Standard deviation results for each metric
• Trend analysis visuals (charts or mini dashboard)
• Short walkthrough or comments explaining where to find and adjust each part
When it’s done I should be able to drop in new monthly data, press refresh, and have the workbook update itself.