1001 Freelance Projects -- Excel Dashboard

Latest Projects from
Freelance Marketplaces

View this project in detail (Note: you will be redirected to external marketplace)
Project title:
Excel Dashboard
Posted by:
External project from PeoplePerHour
Started:
09-Oct-2025 12:27 GMT
Description:
Project: Build a multi-tab Excel sales & marketing tracker with an automated monthly dashboard. What we need A clean, robust Excel file that pulls data from input tabs into a visual Dashboard (monthly selector) showing: Leads, trials booked, trials attended, new monthly subscribers One-off revenue total Conversion rates: Leads → Trials, Trials → Monthly ROI for Sales Employee & Facebook Ad Manager Break-even targets: trials/monthlies needed for each role to cover costs Average revenue per subscriber, Customer lifetime value (LTV) Churn/cancellations per month Cost per lead and cost per trial Lead-source breakdown (FB, referral, word-of-mouth, other) Total monthly revenue (subscriptions + one-offs + trials) Input tabs Sales KPIs (Daily): Date, Calls made, Contacts reached, Bookings (Trials/Monthly), Follow-ups, Notes, Lead Source. Trials (Weekly): Name, Trial date, Trial type (Lego/Engineering/3D Printing), Attended Y/N, Converted Y/N, Conversion date, Non-conversion reason, Notes. Subscriptions (Weekly): Start date, Subscription type, Active (Yes = Green), Cancellation date, Cancellation reason. One-Offs: Date, Name, Product, Paid Y/N, Amount, Notes. Facebook Leads: Date, Leads, Ad Spend, Notes. Built-in pricing & costs (for automation) Sales Employee: £60/week (4 days/week, 4 hours/day). FB Ad Manager: £350/month. Trial prices: £12.99 / £14.99 / £15.99. Monthly prices: £45 / £59 / £64.99. Automations Monthly KPIs via formulas (SUMIFS/COUNTIFS), funnel & trend charts, ROI and break-even (trials/monthlies needed), CPL/CPT, churn, ARPU/LTV, and lead-source split. Data validation (Yes/No, dropdowns), protected formulas, and a tidy, print-friendly layout. Deliver a ready-to-use template with clear instructions.
Project ID:
3453053
Project category:

Project budget:

View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
Experienced Dynatrace + AWS Observability Engineer Needed Category: Amazon Web Services, Azure, Cloud Computing, Linux, Node.js Budget: ₹6000 - ₹12000 INR	01 Dec 2025 14:46 GMT
Corporate Business Plan Slides Design Category: Branding, Corporate Identity, Graphic Design, Icon Design, Logo Design, Powerpoint, Typography, Visual Design Budget: $30 - $250 USD	01 Dec 2025 11:04 GMT
Social Media App Executive Team Needed Category: Android, Android App Development, Application Performance Monitoring, CTO, Internet Marketing, IOS Development, IPhone, Mobile App Development, Software Development, Technology Consulting Budget: £20 - £250 GBP	01 Dec 2025 11:03 GMT
Panduan Cara Kerja Lengkap Category: Content Development, Copywriting, Data Entry, Data Processing, Excel, Technical Writing, Word Processing Budget: $2 - $8 USD	01 Dec 2025 11:03 GMT
Mengenal Nama Hewan: Proyek Pembelajaran Anak Category: Childrens Book Illustration, Content Development, Education & Tutoring Budget: $10 - $30 USD	01 Dec 2025 11:03 GMT
Pembuatan Furniture Interior Custom Category: 3D Design, 3D Modelling, AutoCAD, CAD / CAM, Data Entry, Furniture Design, Interior Design Budget: $250 - $750 USD	01 Dec 2025 11:02 GMT
French Employment History Verification Category: Canadian French Translator, Compliance, Data Management, French Translator, Human Resources, Recruitment, Research Writing, Translation Budget: $10 - $30 USD	01 Dec 2025 11:02 GMT
Urgent Music PR Outreach -- 70292 Category: Blog Writing, Brand Management, Content Writing, Digital Marketing, Email Marketing, Influencer Marketing, Music, Public Relations, SEO, Social Media Marketing Budget: $10 - $30 USD	01 Dec 2025 11:01 GMT
Technical Documentation Update & Polish Category: Content Development, Documentation, Editing, Proofreading, Report Writing, Research, Technical Documentation, Technical Writing Budget: €12 - €18 EUR	01 Dec 2025 11:01 GMT
AI Music App Training Session Category: AI Audio To Audio, AI Chatbot Development, AI Content Creation, AI Design, Audio Production, Audio Services, Music, Sound Design Budget: $250 - $750 AUD	01 Dec 2025 11:01 GMT
ADP Payroll Specialist Category: Human Resources, Payroll, Payroll HR S&E, Workday Payroll Budget: ₹12500 - ₹37500 INR	01 Dec 2025 11:00 GMT
Elevate Google & TripAdvisor Ratings Category: Analytics, Business Analysis, Business Plans, Business Writing, Customer Service, Google Ads, Internet Marketing, Social Media Management Budget: $30 - $250 USD	01 Dec 2025 10:58 GMT
Replace TextLocal Inbound SMS Webhook in ASP.NET Portal -- 2 Category: ASP.NET, C#, Programming, IIS, JQuery / Prototype, Twilio, Windows Server Budget: ₹600 - ₹1500 INR	01 Dec 2025 10:58 GMT
Excel API Sales Integration Category: API Integration, Excel Budget: $10 - $30 USD	01 Dec 2025 10:57 GMT
Documents Verification From AS Monaca Roca Team Basket Category: Documentation, Excel, PDF, Word Budget: $10 - $80 USD	01 Dec 2025 10:57 GMT

Browse All Projects

New!
Проекты на русском (Projects in Russian)