1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 10-Nov-2025 05:09 GMT

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
EDM DJ/Producer Profile Creation Category: Biography Writing, Content Strategy, Content Writing, Creative Writing, Fiction, Ghostwriting, Graphic Design, Music Management, Music Production, Short Stories Budget: $30 - $250 CAD	10-Nov-2025 05:03 GMT
Spring Boot Services for MongoDB Persistence Category: API Development, Docker, J2EE, Java, JSP, MongoDB, Software Architecture, Spring Boot Budget: ₹1500 - ₹12500 INR	10-Nov-2025 05:03 GMT
Meta Ad for Homebuyer Leads Category: Advertising, Digital Marketing, Facebook Ads, Instagram Ads, Lead Generation, Sales Budget: ₹1500 - ₹12500 INR	10-Nov-2025 05:02 GMT
Modern Spec Home Drawings Category: 3D Modelling, AutoCAD, Building Architecture, Building Design, CAD / CAM, Interior Design, Revit Budget: $30 - $250 AUD	10-Nov-2025 05:01 GMT
Firebase Production Deployment & Audit Documentation for VSD Network -- 2 Category: Cloud Computing, Compliance, Documentation, GitHub, PDF, Project Management, Security, Software Development, Software Engineering, Technical Writing Budget: $30 - $250 USD	10-Nov-2025 05:01 GMT
Native French Content Strategist Category: Content Audit, Content Creation, Content Development, Content Management System (CMS), Content Strategy, Content Writing, LLM Integration Budget: $18 USD	10-Nov-2025 05:00 GMT
Instagram Reels Engagement Strategist Category: Content Strategy, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Social Media Marketing, Viral Marketing, YouTube Budget: ₹600 - ₹1500 INR	10-Nov-2025 04:59 GMT
React ShadCN Component Replication Category: Animation, CSS, Frontend Development, JavaScript, JQuery / Prototype, Next.js, React.js, TailWind, Typescript, Web Development Budget: $30 - $250 USD	10-Nov-2025 04:58 GMT
Two-Bedroom Dwelling House Architectural Design Category: 3D Modelling, 3D Rendering, 3ds Max, AutoCAD, Building Architecture, Interior Design, Revit, SketchUp Budget: $8 - $15 AUD	10-Nov-2025 04:58 GMT
Native Thai Content Strategist Category: Content Audit, Content Creation, Content Development, Content Strategy, Content Writing, Copywriting Budget: $7 USD	10-Nov-2025 04:58 GMT
Modern Home Interior Design Category: 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Architecture, Home Design, Interior Design, SketchUp Budget: $250 - $750 USD	10-Nov-2025 04:57 GMT
Photo-Real Sneaker Instagram Carousel Creation Category: 3D Design, 3D Graphic Design, 3D Visualization, Graphic Design, Illustration, Photoshop, Photoshop Design Budget: ₹600 - ₹1500 INR	10-Nov-2025 04:57 GMT
Urgent GoHighLevel-Stripe Workflow Setup Category: API Integration, Automation, HTML, MySQL, Payment Processing, PHP, Software Architecture, Stripe Budget: $250 - $750 USD	10-Nov-2025 04:55 GMT
Modern Circular Event Patch Design Category: 2D Drawing, 2D Layout, Adobe Illustrator, Creative Design, Graphic Design, Illustration, Logo Design, Photoshop Budget: $30 - $250 USD	10-Nov-2025 04:53 GMT
Real Estate Lead-Gen Partner Category: CRM, Email Marketing, Internet Marketing, Lead Generation, Leads, Marketing, Sales, Social Media Marketing Budget: ₹12500 - ₹37500 INR	10-Nov-2025 04:52 GMT

Browse All Projects

Projects by Skills ...
Projects for 'android' Projects for 'ajax' Projects for 'asp' Projects for 'aspnet' Projects for 'cms' Projects for 'cpp' Projects for 'csharp' Projects for 'css' Projects for 'delphi' Projects for 'design' Projects for 'drupal'	Projects for 'excel' Projects for 'facebook' Projects for 'flash' Projects for 'html' Projects for 'java' Projects for 'javascript' Projects for 'joomla' Projects for 'iphone' Projects for 'mysql' Projects for 'photoshop' Projects for 'php' Projects for 'python'	Projects for 'ruby' Projects for 'seo' Projects for 'sql' Projects for 'sysadm' Projects for 'translate' Projects for 'typing' Projects for 'twitter' Projects for 'vbnet' Projects for 'xml' Projects for 'wordpress' Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android' RSS feed for 'ajax' RSS feed for 'asp' RSS feed for 'aspnet' RSS feed for 'cms' RSS feed for 'cpp' RSS feed for 'csharp' RSS feed for 'css' RSS feed for 'delphi' RSS feed for 'design' RSS feed for 'drupal'	RSS feed for 'excel' RSS feed for 'facebook' RSS feed for 'flash' RSS feed for 'html' RSS feed for 'java' RSS feed for 'javascript' RSS feed for 'joomla' RSS feed for 'iphone' RSS feed for 'mysql' RSS feed for 'photoshop' RSS feed for 'php' RSS feed for 'python'	RSS feed for 'ruby' RSS feed for 'seo' RSS feed for 'sql' RSS feed for 'sysadm' RSS feed for 'translate' RSS feed for 'typing' RSS feed for 'twitter' RSS feed for 'vbnet' RSS feed for 'xml' RSS feed for 'wordpress' RSS feed for 'writing'

New!
Проекты на русском (Projects in Russian)	Short URL: 1001fp.com	Mobile version: m.1001freelanceprojects.com