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
Engaging E-Commerce Product Copy Category: BigCommerce, Content Writing, Copywriting, Keyword Research, Product Descriptions, SEO, Shopify, WooCommerce Budget: $750 - $1500 SGD	15 Oct 2025 16:04 GMT
Cryptography Flag Decryption Report Needed Category: C, Programming, Cryptography, Data Analysis, Documentation, OpenSSL, Python, Research Writing, Technical Writing Budget: $30 - $250 AUD	15 Oct 2025 16:04 GMT
MERN Real-Time Trading Platform Category: API Integration, Full Stack Development, Java, JavaScript, Market Analysis, MERN, MySQL, PHP Budget: $30 - $250 USD	15 Oct 2025 16:03 GMT
Boost EGEXO.com SEO Performance Category: Content Strategy, Internet Marketing, Keyword Research, Link Building, Page Speed Optimization, Search Engine Marketing (SEM), SEMrush, SEO, SEO Auditing, White Hat SEO Budget: $30 - $250 USD	15 Oct 2025 16:03 GMT
Anime Game 3D Animations Category: 3D Animation, 3D Design, 3D Rendering, 3D Rigging, After Effects, Animation, Game Development, Maya Budget: £20 - £250 GBP	15 Oct 2025 16:01 GMT
VR Game Movement Playtest Category: 3D Animation, 3D Modelling, AR / VR 3D Asset, Article Writing, Game Design, Motion Graphics, Playstation VR, User Experience Research, Video Game Coaching, Virtual Reality Budget: $10 - $30 USD	15 Oct 2025 16:01 GMT
Community Magazine	15 Oct 2025 16:01 GMT
Build HealNow Appointment System Category: Android, API Development, Backend Development, Database Management, HTML, Mobile App Development, PHP, UI / User Interface, Video Conferencing, Web Development Budget: ₹600 - ₹1500 INR	15 Oct 2025 16:01 GMT
Odoo Implementation for Car Dealership (Auto Center Bern) Category: Accounting, API Integration, CRM, ERP, Inventory Management, Odoo, PHP, Python, Sales Management, Software Architecture Budget: $3000 - $5000 USD	15 Oct 2025 15:59 GMT
Network & Web Pen Test Category: Computer Security, Internet Security, Network Administration, Network Security, Penetration Testing, Risk Assessment, Web Security Budget: $250 - $750 USD	15 Oct 2025 15:58 GMT
Legal CRM Elementor Landing Category: Elementor, Graphic Design, HTML, Lead Generation, PHP, Web Design, Web Development Budget: ₹1500 - ₹12500 INR	15 Oct 2025 15:57 GMT
Service & E-Commerce Website Build Category: CSS, HTML, JavaScript, PHP, SEO, Web Development, Web Design, WooCommerce Budget: $30 - $250 USD	15 Oct 2025 15:56 GMT
Single Image Brightness Adjustment Category: Adobe Lightroom, Photoshop, Color Grading, Graphic Design, Image Analysis, Image Consultation, Image Processing, Photo Editing, Photoshop Design Budget: $10 - $30 AUD	15 Oct 2025 15:56 GMT
Mystery Shopper — Andhra pradesh Audits Category: Article Writing, Customer Experience, Data Collection, Market Research, Photography, Report Writing, Research, Research Writing Budget: ₹600 - ₹1500 INR	15 Oct 2025 15:56 GMT
Crime Novel Review Category: Amazon, Book Review, Book Writing, Content Writing, Creative Writing, Editing, Proofreading, Writing Budget: £10 - £15 GBP	15 Oct 2025 15:55 GMT

Browse All Projects

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