Excel and Google Sheets Reports, Formulas and DashboardsYurii Cherevko
I turn messy spreadsheets into clean, reliable reports and models in Excel or Google Sheets that your team can keep using after the project ends.
What you get
• Reports and trackers with formulas that work: SUMIFS, XLOOKUP, INDEX/MATCH, dynamic arrays, QUERY and ARRAYFORMULA in Sheets
• Pivot tables, charts and a simple dashboard sheet with the KPIs that matter
• Data cleaning: duplicates, broken formats, merged sources, consistent categories
• Automation of repeated steps with Power Query, named ranges or Apps Script
• Clear structure, documented assumptions and a short guide on how to update the file
Typical projects: sales and marketing reports, budget and finance trackers, KPI dashboards, inventory and order sheets, lead and CRM exports, templates you fill in every week.
How it works: send me the file (or a sample with the same structure) and describe what the result should show. I confirm the scope, deliver a first version within 2 to 3 days, and include one round of revisions.
Background: 3 years as a Data Analyst in iGaming, e-commerce and digital marketing. Intro rate for first projects on Contra.
Starting at$80
Duration1 week
Tags
Google Sheets
Microsoft Excel
Dashboard
Data Analyst
Service provided by
Yurii Cherevko Edmonton, Canada
- 1
- Followers
Excel and Google Sheets Reports, Formulas and DashboardsYurii Cherevko
Starting at$80
Duration1 week
Tags
Google Sheets
Microsoft Excel
Dashboard
Data Analyst
I turn messy spreadsheets into clean, reliable reports and models in Excel or Google Sheets that your team can keep using after the project ends.
What you get
• Reports and trackers with formulas that work: SUMIFS, XLOOKUP, INDEX/MATCH, dynamic arrays, QUERY and ARRAYFORMULA in Sheets
• Pivot tables, charts and a simple dashboard sheet with the KPIs that matter
• Data cleaning: duplicates, broken formats, merged sources, consistent categories
• Automation of repeated steps with Power Query, named ranges or Apps Script
• Clear structure, documented assumptions and a short guide on how to update the file
Typical projects: sales and marketing reports, budget and finance trackers, KPI dashboards, inventory and order sheets, lead and CRM exports, templates you fill in every week.
How it works: send me the file (or a sample with the same structure) and describe what the result should show. I confirm the scope, deliver a first version within 2 to 3 days, and include one round of revisions.
Background: 3 years as a Data Analyst in iGaming, e-commerce and digital marketing. Intro rate for first projects on Contra.
$80