1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 21-Oct-2025 01:48 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
Regular Online hindi or punjabi to English Coaching Needed Category: Audio Services, Business Coaching, English Tutoring, Hindi Translator, Language Tutoring, Punjabi Translator, Voice Talent Budget: $30 - $250 CAD	20-Oct-2025 22:02 GMT
Riset Harga iPhone Terbaik Category: Data Analysis, Market Research, Product Research Budget: $2 - $8 USD	20-Oct-2025 22:01 GMT
Réalisation d’une vidéo de présentation courte et percutante pour mon centre de formation -- 2 Category: After Effects, French Translator, Graphic Design, Startups, Video Editing, Video Services Budget: €30 - €250 EUR	20-Oct-2025 22:01 GMT
Basic Online English School Website Category: Backend Development, HTML, JavaScript, PHP, Video Conferencing, Web Design, Web Development Budget: €2 - €6 EUR	20-Oct-2025 22:00 GMT
NETLAB VM CTF Coaching Category: Cisco, Computer Security, Documentation, Linux, Network Administration, Network Security, Penetration Testing, Technical Writing Budget: $15 - $25 USD	20-Oct-2025 21:59 GMT
SLA-Ready Character Model Base Category: 3D Animation, 3D CAD, 3D Design, 3D Layout, 3D Modelling, 3D Printing, 3D Rendering, 3ds Max Budget: $30 - $250 AUD	20-Oct-2025 21:59 GMT
ESP32 Timer via QR Payments (debe residir en buenos aires , argentina) Category: Android, API Integration, Bluetooth, Electrical Engineering, Embedded Systems, Mobile App Development, PHP, Software Architecture Budget: $30 - $250 USD	20-Oct-2025 21:59 GMT
Figma to Live Website Conversion (Framer or Webflow Preferred) Category: CSS, Figma, Framer, Graphic Design, HTML, JavaScript, Web Design, Web Development, Webflow Budget: ₹12500 - ₹37500 INR	20-Oct-2025 21:57 GMT
Moomintroll Swift Art Category: Character Illustration, Creative Design, Digital Art, Graphic Design, Illustration, IPhone, Painting, Photoshop Budget: $30 - $250 USD	20-Oct-2025 21:57 GMT
Human Pose Annotation (Skeleteon provided, Single Person per sample please watch example video) (strictly $300aud per 2000 samples) Category: Computer Graphics, Computer Vision, Data Entry, Data Management, Data Processing, Deep Learning, Image Analysis, Image Processing, Web Scraping, Web Search Budget: $250 - $750 AUD	20-Oct-2025 21:56 GMT
Facebook and Instagram Ad Campaign for Lead Generation Category: Content Writing, Copywriting, Facebook Marketing, Internet Marketing, Marketing Budget: $50 - $100 USD	20-Oct-2025 21:56 GMT
LinkedIn Construction Management Banner ASAP Category: Adobe Illustrator, Photoshop, Banner Design, Corporate Identity, Figma, Graphic Design, Logo Design, Typography, Visual Design Budget: $10 - $30 USD	20-Oct-2025 21:55 GMT
Senior-Level Resume Overhaul Category: Business Writing, Content Writing, Creative Writing, Editing, Graphic Design, Microsoft Office, Microsoft Word, Technical Writing, Visual Design, Word Processing Budget: $30 - $250 USD	20-Oct-2025 21:55 GMT
3D Model Conversion for Prototyping -- 2 Category: 3D CAD, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, AutoCAD, CAD / CAM, Solidworks Budget: $30 - $250 AUD	20-Oct-2025 21:54 GMT
Dynamic Social Media Designer & Content Manager Category: Adobe Creative Suite, Banner Design, Canva, Content Creation, Graphic Design, Photoshop, Photoshop Design, Social Media Management Budget: $250 - $750 USD	20-Oct-2025 21:53 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