1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 16-Apr-2026 17:49 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
Comprehensive Website and Graphic Design Support for Small Business Category: Graphic Design, HTML, PHP, User Interface / IA, Web Design Budget: $100 - $200 USD	16-Apr-2026 18:19 GMT
Minimalistic Mobile App UI/UX Design Category: Adobe XD, Figma, Graphic Design, IPhone, Mobile App Development, UI / User Interface, User Interface / IA, UX / User Experience Budget: $250 - $750 USD	16-Apr-2026 16:04 GMT
Android Pixel Worlds Mod Menu Category: Android, Android App Development, Android Studio, Java, Kotlin, Mobile App Development, Mobile Development, Software Architecture Budget: $10 - $30 USD	16-Apr-2026 16:03 GMT
HRMS SaaS Deployment & Customization Category: Backend Development, CPanel, HTML, Laravel, MySQL, Node.js, Payment Gateway Integration, PHP, SaaS, Web Design Budget: ₹1500 - ₹12500 INR	16-Apr-2026 16:02 GMT
WooCommerce E-Commerce Store Design -- 2 Category: ECommerce, Figma, PHP, Prototyping, SEO, Shopify, Web Development, Website Optimization, WooCommerce, WordPress Budget: $3000 - $5000 USD	16-Apr-2026 16:01 GMT
Modern Concrete Terrace Design Category: Architecture, AutoCAD, Building Architecture, Building Design, Building Engineering, Civil Engineering, Construction, Interior Design, Project Management Budget: $750 - $1500 USD	16-Apr-2026 16:00 GMT
আকর্ষণীয় ব্যানার ডিজাইন দরকার Category: Graphic Design, Print Design Budget: $15 - $25 USD	16-Apr-2026 16:00 GMT
SEO specialist required	16-Apr-2026 15:59 GMT
WordPress Speed Fix, Layout Fixes & Form Setup	16-Apr-2026 15:59 GMT
Short Video Creator (Veo, NanoBananaPro, CapCut) Category: After Effects, CapCut, ElevenLabs, Facebook Ads, HeyGen, Instagram Marketing, Social Media Marketing, Video Editing, Video Production, Video Services Budget: $30 - $250 USD	16-Apr-2026 15:58 GMT
Daily News Research EN-CN Summaries Category: Article Writing, Content Writing, Editing, English Translation, Research, Simplified Chinese Translator, Traditional Chinese (Hong Kong), Translation Budget: $250 - $750 USD	16-Apr-2026 15:58 GMT
REVIT Structural Model Development Category: 3D Modelling, Architecture, AutoCAD, Autodesk Revit, Building Architecture, Building Design, Building Information Modeling, Construction, Revit, Structural Engineering Budget: £20 - £250 GBP	16-Apr-2026 15:53 GMT
Azure DevOps Specialist for Hybrid Role Category: Azure, CI / CD, Cloud Computing, DevOps, Git, Network Administration, Terraform Budget: ₹250000 - ₹500000 INR	16-Apr-2026 15:52 GMT
Odoo WhatsApp Message Automation Category: API Integration, Automation, Documentation, ERP, Odoo, PHP, Python, Software Architecture, Software Development, Software Documentation Budget: $30 - $250 USD	16-Apr-2026 15:52 GMT
Updating a P6 Schedule Category: AutoCAD, Building Architecture, CAD / CAM, Change Management, Construction Management, Home Design, Project Management, Project Planning, Project Scheduling, Time Management Budget: $30 - $250 USD	16-Apr-2026 15:51 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