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 Technical Writer for STEM Bluetooth Speaker Kit Documentation (Electronics Focus) -- 2 Category: Circuit Design, Electrical Engineering, Electronics, PCB Layout, Technical Writing Budget: $125 - $250 USD	07 Feb 2026 05:14 GMT
Beckhoff PLC for XYZ gantry with conveyors Category: Automation, Electrical Engineering, Programming, Project Management, Software Development, Technical Support, Training Budget: ₹1250 - ₹2500 INR	07 Feb 2026 05:02 GMT
Node.js Result API & Webhooks Category: AngularJS, API Development, Frontend Development, JavaScript, Linux, MongoDB, MySQL, Node.js, NoSQL Couch & Mongo, Vue.js Budget: ₹1500 - ₹12500 INR	07 Feb 2026 05:00 GMT
Assistance with Oracle 4GL Scripting for VEE Rules Category: Database Administration, Database Development, Java, Oracle, SQL Budget: ₹600 - ₹1000 INR	07 Feb 2026 04:59 GMT
AI Cinematic Storytelling Video Editor Required Category: AI Animation, AI Art Creation, HeyGen, Runway, Sound Design, Video Editing, Video Post Editing, Video Processing, Video Production, YouTube Video Editing Budget: ₹600 - ₹1500 INR	07 Feb 2026 04:56 GMT
Asisten Balas Chat WhatsApp Category: Chat Operation, Chatbot, Customer Service, Customer Support, Data Entry, Data Processing, Excel, Web Search Budget: $15 - $25 USD	07 Feb 2026 04:56 GMT
Expert Microsoft Word Document Formatting Category: Accessibility, Editing, Microsoft Word, Research Writing, Sharepoint, Word Budget: $250 - $750 USD	07 Feb 2026 04:54 GMT
Need 3000-Series UBC Aluminum Scrap Category: Data Entry, Excel, Inventory Management, Logistics, Manufacturing Budget: ₹1500 - ₹12500 INR	07 Feb 2026 04:54 GMT
Berserk-Style Manga Page Illustration Category: 2D Drawing, Caricature & Cartoons, Character Illustration, Comics, Digital Art, Illustration, Manga Budget: $10 - $30 USD	07 Feb 2026 04:54 GMT
Informational Brand Website Build Category: Content Management System (CMS), Graphic Design, HTML, PHP, Web Design, Web Development, WordPress Budget: ₹600 - ₹1500 INR	07 Feb 2026 04:52 GMT
Basic WhatsApp Marketing Category: Google Analytics, Marketing Strategy, Social Media Marketing Budget: ₹12500 - ₹37500 INR	07 Feb 2026 04:51 GMT
Vintage T-Shirt Webstore Build Category: ECommerce, Graphic Design, HTML, Shopping Cart Integration, Web Development, Web Design, WooCommerce, WordPress Budget: ₹400 - ₹750 INR	07 Feb 2026 04:51 GMT
Urgent: Looking for a Professional Who Can Introduce a Serious Investor (24h Deal) -- 3 Category: Business Development, Business Strategy, Consulting, Contracts, Investment Management, Legal, Legal Research, Legal Writing, Market Research, Startup Consulting Budget: $3000 - $5000 USD	07 Feb 2026 04:51 GMT
Urgent: Looking for a Professional Who Can Introduce a Serious Investor (24h Deal) -- 2 Category: Business Analysis, Business Consulting, Business Development, Consulting, Contracts, Investment Management, Legal, Legal Research, Legal Writing, Startup Consulting Budget: $5000 - $10000 USD	07 Feb 2026 04:51 GMT
Urgent: Looking for a Professional Who Can Introduce a Serious Investor (24h Deal) Category: Business Consulting, Business Development, Business Strategy, Entrepreneurship, Internet Marketing, Investment Management, Market Research, Marketing, Social Media Marketing, Startup Consulting Budget: $3000 - $5000 USD	07 Feb 2026 04:51 GMT

Browse All Projects

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