I will design custom excel spreadsheets for sales, finance, and kpis


About this gig
Turn your raw data into clear business insights with a professional Excel dashboard. I'm Mohit, a PwC data analyst with 4+ years' experience, I'll craft a custom Excel/Google Sheets solution (dashboards or templates) for your sales and finance KPIs. Forget manual reports; get a self-updating tool that saves you hours and decision-ready charts.
What I Offer
- Custom Excel Dashboard: Charts, slicers, pivot tables to highlight KPIs (sales, revenue, expenses).
- Interactive Templates: Financial tracker or inventory template with clear data entry.
- Advanced Formulas & Automation: IF, INDEX/MATCH, VBA macros to automate reports and calculations.
- Data Cleaning & Modeling: Organize your CSV/Excel data for analysis (merge sheets, remove duplicates).
- File Conversion: Export to PDF, or migrate sheets between Google Sheets/Excel.
My Process (3-4 steps): Outline how you work to set expectations.
- Requirements: Ill review your data + KPIs; we clarify exactly what metrics you need.
- Prototype: I design an initial dashboard layout and share a draft for feedback.
- Development: I implement formulas, charts, and automation.
- Delivery: You get the final file with a short walkthrough (video or notes).
Get to know Mohit K
Excel and Power BI Expert: Data Analysis and Automation
- FromIndia
- Member sinceJun 2025
- Last delivery9 months
Languages
Hindi, English
My Portfolio
FAQ
What do you need from me to start?
our raw file(s) and a short note of the desired KPIs and output format. A sample helps a lot.
Can you work with Google Sheets?
Yes — I deliver Excel by default and can provide a Google Sheets copy.
Do you handle large files?
Yes — Basic/Standard/Premium packages include row limits; ask for a custom offer if larger.
Will my data stay confidential?
Absolutely. I only use files to complete the order and delete them if requested.
Do you add automation (macros/VBA)?
Yes — available in Premium or as a gig extra. For Google Sheets, I use scripts on request.
Can you create industry-specific templates?
Yes — sales, finance, HR templates are available. Tell me your industry in requirements.

