1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 22-Feb-2026 02:01 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
Modern Product Launch Poster Category: Adobe Illustrator, Photoshop, Advertisement Design, Advertising, Digital Marketing, Graphic Design, Poster Design Budget: $10 - $30 USD	21-Feb-2026 22:58 GMT
Artistic Wedding Photography & Videography Category: Photoshop, Adobe Premiere Pro, Color Grading, Photo Editing, Photography, Video Editing, Videography Budget: ₹1500 - ₹12500 INR	21-Feb-2026 22:56 GMT
Architectural Stamped Drawings for Renovation Category: Architectural Engineering, Architecture, AutoCAD, Building Architecture, Building Design, Building Regulations, CAD / CAM, Interior Design Budget: $250 - $750 USD	21-Feb-2026 22:55 GMT
Background Removal Photo Editing Category: Background Removal, Photo Editing Budget: $10 - $30 USD	21-Feb-2026 22:53 GMT
Ransomware Decryption Specialist Needed – 2 Files Only Category: C, Programming, Computer Security, Data Analysis, Digital Forensics, Encryption, Research Writing, Reverse Engineering, Risk Assessment, Scripting, Technical Documentation Budget: $750 - $1500 USD	21-Feb-2026 22:53 GMT
Concert Poster Design Needed Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Poster Design, Print Design, Visual Design Budget: $10 - $30 USD	21-Feb-2026 22:52 GMT
Data Analytics Testing Category: BigQuery, Business Intelligence, Data Analysis, Data Modeling, Data Warehousing, ETL, Redshift, Snowflake, SQL, Testing / QA Budget: ₹1500 - ₹12500 INR	21-Feb-2026 22:52 GMT
YouTube Vlog Editor Category: Adobe Premiere Pro, After Effects, Video Editing, Video Post Editing, Video Processing, Video Services Budget: $30 - $250 USD	21-Feb-2026 22:45 GMT
Modern Vibrant Iconic Logo Design Category: Adobe Illustrator, Branding, Creative Design, Graphic Design, Illustration, Photoshop, Vector Design Budget: $10000 - $20000 USD	21-Feb-2026 22:44 GMT
Adaptive Resource Research Support Category: Customer Service, Customer Support, Data Analysis, Data Collection, Data Entry, Data Management, Report Writing, Research, Research Writing, Statistics Budget: $250 - $750 USD	21-Feb-2026 22:41 GMT
Need commission based lead geenration expert for AppDev agencyy Category: B2B Marketing, Email Marketing, Internet Marketing, IPhone, Lead Generation, Sales, Social Media Marketing Budget: $30 - $250 AUD	21-Feb-2026 22:40 GMT
Sci-Fi ARPG Development Category: 3D Animation, 3D Art, 3D Modelling, 3D Rendering, Game Design, Game Development, Unity, Unreal Engine Budget: $15 - $25 USD	21-Feb-2026 22:39 GMT
Realistic Mangonados Storybook Art Category: 2D Drawing, Art Consulting, Art Installation, Caricature & Cartoons, Digital Art, Illustration, Photoshop Budget: $250 - $750 USD	21-Feb-2026 22:38 GMT
Remote Email Support Specialist Category: Customer Experience, Customer Service, Customer Support, Documentation, Email Handling, Email Marketing, Technical Support, Technical Writing, Time Management, Troubleshooting Budget: $1500 - $3000 USD	21-Feb-2026 22:37 GMT
Hygiene Accountability Virtual Assistant -- 2 Category: Data Entry, Photoshop, Psychology, Time Management, Video Conferencing, Video Services, Virtual Assistant, Zoom Budget: $30 - $250 USD	21-Feb-2026 22:34 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