1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 21-Dec-2025 10:37 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 Townhouse 2D Plans Category: 2D Drafting, Architectural Engineering, AutoCAD, Building Architecture, Building Design, CAD / CAM, Drafting, Revit Budget: ₹600 - ₹1500 INR	21-Dec-2025 05:03 GMT
T-Display S3 Footprint & Symbol PCB design Category: 3D CAD, Altium Designer, Circuit Design, Electrical Engineering, Electronic Design, Electronics, PCB Layout Budget: $30 - $250 AUD	21-Dec-2025 05:02 GMT
Graphic design and branding 8 images and 20page white paper design Category: Adobe Illustrator, Adobe InDesign, Photoshop, Banner Design, Branding, Graphic Design, Logo Design, Social Media Marketing Budget: $30 - $250 AUD	21-Dec-2025 05:01 GMT
Affiliate Program & Recruitment with Rewardful+Stripe Category: Affiliate Marketing, Digital Marketing, HTML, PayPal API, PHP, Social Media Marketing, Stripe, Web Design Budget: $30 - $250 AUD	21-Dec-2025 04:59 GMT
Exam-Gen app organization and upgrade Category: Node.js Budget: $250 - $750 USD	21-Dec-2025 04:58 GMT
Elementary Addition & Subtraction Assistance Category: Math Tutoring, Mathematics, Teaching / Lecturing Budget: ₹750 - ₹1250 INR	21-Dec-2025 04:56 GMT
Romantic Event Video Montage Category: After Effects, Film Editing, Film Production, Video Editing, Video Post Editing, Video Processing, Video Production, Video Services Budget: ₹600 - ₹1500 INR	21-Dec-2025 04:56 GMT
Adobe Content Creator for Social Media Category: Adobe Illustrator, Photoshop, Adobe Premiere Pro, After Effects, Animation, Canva, Content Creation, Corel Draw, Graphic Design Budget: $250 - $750 USD	21-Dec-2025 04:54 GMT
looking for YouTube short animator Category: 3D Animation, Animation, Video Editing, Video Services, YouTube, YouTube Video Editing Budget: $30 - $250 USD	21-Dec-2025 04:53 GMT
Enhance iOS ARKit LiDAR App Category: 3D Modelling, 3D Rendering, ARKit, IOS Development, IPad, IPhone, Mobile App Development, Objective C Budget: ₹400 - ₹750 INR	21-Dec-2025 04:53 GMT
Short Blog Article Needed Category: Article Writing, Blog Writing, Content Development, Content Writing, Copywriting, Creative Writing, Ghostwriting, SEO Writing Budget: $15 - $25 USD	21-Dec-2025 04:52 GMT
Intermediate Revit 3D Modeling - 20/12/2025 23:51 EST Category: 3D Architecture, 3D Design, 3D Drafting, 3D Modelling, 3D Rendering, 3D Visualization, Building Information Modeling, Revit Budget: $40 - $60 USD	21-Dec-2025 04:51 GMT
Luxurious Shopify Horizon Theme Customisation Category: ECommerce, Figma, JSON, Shopify Development, Shopify Templates Budget: $30 - $250 USD	21-Dec-2025 04:50 GMT
PR distribution ONLY for a U.S.-based dating app ASAP! Category: Advertising, Copywriting, Digital Marketing, Email Marketing, Journalism, Media Relations, Press Releases, Public Relations, SEO, Social Media Marketing Budget: $25 - $45 USD	21-Dec-2025 04:50 GMT
Digital Marketing & Lead Generation Specialist for LoanSathi.in – Monthly Basis Category: Advertising, Digital Marketing, Facebook Ads, Google Ads, Instagram Ads, Internet Marketing, Lead Generation, Marketing, Sales, YouTube Ads Budget: ₹1000 - ₹5000 INR	21-Dec-2025 04:49 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