1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 26-Nov-2025 02:54 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
ComfyUI Setup for AI Generated Roblox-Style Video Category: After Effects, AI (Artificial Intelligence) HW / SW, AI Development, AI Model Development, ComfyUI, Video Editing, Video Services Budget: $30 - $250 USD	25-Nov-2025 22:54 GMT
Resolve Access Table Linking Issue Category: Data Entry, Database Design, Database Development, Database Management, Microsoft Access, SQL Budget: £20 - £250 GBP	25-Nov-2025 22:52 GMT
AI Automation & WhatsApp Integration Category: AI Chatbot Development, API Integration, Automation, CRM, Data Integration, OpenAI, REST API, Zapier Budget: €250 - €750 EUR	25-Nov-2025 22:51 GMT
eBay expert insuder Category: Account Management, Amazon Web Services, Customer Service, Digital Marketing, EBay, ECommerce, Inventory Management, PHP, Sales, Sales Management Budget: $50 - $150 USD	25-Nov-2025 22:51 GMT
Drone 3D Visualization Package Category: 3D Animation, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, AR / VR 3D Asset, Blender, Cinema 4D, Maya, Visual Effects Budget: $800 - $1200 CAD	25-Nov-2025 22:50 GMT
Engaging Website for Social Boost -- 2 Category: Frontend Development, Internet Marketing, Next.js, PHP, SEO, UI / User Interface, Web Development, Web Design, WordPress Budget: $15 - $25 USD	25-Nov-2025 22:50 GMT
Secure National Media Coverage Category: Article Writing, Brand Management, Content Marketing, Content Writing, Creative Writing, Ghostwriting, Journalism, Public Relations Budget: $250 - $750 AUD	25-Nov-2025 22:48 GMT
Unbutton Collar in Portrait Photo Category: Digital Art, Graphic Design, Image Consultation, Image Processing, Photo Editing, Photoshop, Photoshop Design, Visual Design Budget: $10 - $30 USD	25-Nov-2025 22:48 GMT
Mechanical & Structural Drawings Category: 3D CAD, 3D Drafting, AutoCAD, Mechanical Design Budget: $250 - $750 CAD	25-Nov-2025 22:48 GMT
Angelic Photo Enhancement Needed Category: Color Grading, Creative Design, Digital Art, Graphic Design, Image Processing, Photo Editing, Photo Restoration, Photoshop, Photoshop Design, Visual Effects Budget: $10 - $30 USD	25-Nov-2025 22:48 GMT
Minimalist Instagram Promo Graphics Category: Adobe Illustrator, Photoshop, Banner Design, Branding, Content Creation, Graphic Design, Logo Design, Social Media Marketing, Visual Design Budget: $10 - $30 USD	25-Nov-2025 22:47 GMT
Email Customer Support Representative Category: Customer Service, Customer Support, Email Handling, Helpdesk, Time Management, Zendesk Budget: $250 - $750 USD	25-Nov-2025 22:47 GMT
Multisim ECG Filter & Amplifier Category: Analog Electronics, Biomedical Engineering, Circuit Design, Electrical Engineering, Electronics, Signal Processing, Simulation Budget: $10 - $30 USD	25-Nov-2025 22:46 GMT
Revisión libro infantil para Amazon Category: Adobe InDesign, Amazon Kindle, Book Design, Book Writing, EBooks, Editing, Graphic Design, Illustration Budget: $10 - $30 USD	25-Nov-2025 22:45 GMT
Website Banners & Ad Creatives Category: Adobe Creative Cloud, Photoshop, Advertisement Design, Banner Design, Graphic Design, Photoshop Design, Web Design Budget: ₹600 - ₹1500 INR	25-Nov-2025 22:44 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)	Long URL: www.1001freelanceprojects.com	Mobile version: m.1001fp.com