Kelvin Muli - Data Analyst | Contra
Work by Kelvin Muli
Sign Up
Post a job
Sign Up
Log In
Kelvin Muli
Excel Expert | Clean Data & Dashboards in 24hrs
Message
Follow
New to Contra
Kelvin is building their profile!
Followed by
GALLERY L
Nairobi, Kenya
Work
Posts
Services
About
Nairobi, Kenya
0
Automated Invoice Generator | Excel VLOOKUP + LOOKUP TABLES Built a fully automated invoice system that eliminates manual entry: How it works: • Select Client → Name, Address, Email auto-fills via VLOOKUP from Clients Table • Select Item Code → Description & Unit Price auto-fills from Products Table • Line Total, Subtotal, Tax (10%), Total Amount calculates automatically • Reference data hidden (Products & Clients tables) for easy updating Formulas used: VLOOKUP, IFERROR, SUM, multiplication for totals Result: Create a professional invoice in 30 seconds vs 15 minutes manually. Perfect for small business owners. I can customize this with your logo, tax rate, and currency.
0
26
0
Sales Dashboard — FY 2024 | Automated Excel Dashboard Built a fully automated sales dashboard for a US client to track $1.24M sales, units sold, and growth. Features: ✓ Auto-updating KPIs ✓ Product breakdown with growth % ✓ Sales by Product chart + Region pie chart ✓ Saved client 10+ hours of manual reporting Tools: Excel, PivotTables, Formulas, Charts Delivery: 24 hours, 100% accurate. Open to similar projects starting at $25.
0
28
0
Data Cleaning — Before & After | Excel Data Cleanup Expert Transformed messy raw customer data into clean, ready-to-use dataset: BEFORE (8 rows, 6 issues): • Duplicate rows, invalid emails & dates • Negative numbers, #ERROR, inconsistent caps AFTER (4 rows, 0 issues): ✓ 3 duplicates removed ✓ Validated emails & standardized dates ✓ Fixed amounts to currency format ✓ Status unified to Completed Tools: Excel Text-to-Columns, Remove Duplicates, TRIM, PROPER, Data Validation, Conditional Formatting I can clean 500+ rows in 24hrs — perfect for small businesses with messy CRM exports.
0
30
0
Monthly Budget Tracker — September 2026 | Automated Excel Template
0
29