1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 19-Dec-2025 08:52 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
Commercial GPS Tracking Platform Development Category: Android, API Development, Backend Development, Flutter, GPS, IPhone, Java, Mobile App Development Budget: $250 - $750 USD	19-Dec-2025 05:02 GMT
Fix Google Sites DNS Error Category: DNS, GoDaddy, Linux, SSL, Web Hosting, Web Security, Website Management, Website Optimization Budget: $10 - $30 USD	19-Dec-2025 05:01 GMT
Product Advertising Poster Design Category: Adobe Illustrator, Photoshop, Advertising, Flyer Design, Graphic Design, Poster Design, Visual Arts Budget: $250 - $750 USD	19-Dec-2025 04:59 GMT
Cloud & Datacenter Certification Audit Category: Amazon Web Services, Audit, Azure, Cloud Computing, Cloud Security, Compliance, Documentation, Microsoft Azure, Network Administration, Risk Management Budget: ₹750 - ₹1250 INR	19-Dec-2025 04:59 GMT
Academic Business Research Report Category: Academic Research, Academic Writing, Business Analysis, Business Consulting, Business Development, Business Writing, Data Analysis, Research, Research Writing, Statistical Analysis Budget: $30 - $250 USD	19-Dec-2025 04:52 GMT
Social-Ready Hairstyle Photography Session Category: Content Creation, Creative Design, Graphic Design, Photo Editing, Photography, Photoshop, Social Media Marketing, Visual Arts Budget: $10 - $30 USD	19-Dec-2025 04:50 GMT
Elegant Food Catalogue Revamp Category: Adobe Illustrator, Adobe InDesign, Brochure Design, Catalog Design, Content Writing, Graphic Design, Photoshop, Print Design, Product Descriptions, Typography Budget: $30 - $250 USD	19-Dec-2025 04:50 GMT
Compelling Social Media Post Writing Category: Content Writing, Cooking & Recipes, Freelance, Poetry, Voice Talent Budget: $15 - $25 USD	19-Dec-2025 04:48 GMT
Commission-Based Sales Partner for IT Services (India & International Markets) -- 2 Category: Business Development, Internet Marketing, Lead Generation, Leads, Market Research, Sales, Sales Management, Telemarketing Budget: ₹12500 - ₹37500 INR	19-Dec-2025 04:46 GMT
Increase Positive Service Reviews Category: Content Marketing, Customer Experience, Customer Retention Marketing, Customer Service, Google Ads, Marketing Strategy, Script Writing, Training Development Budget: ₹600 - ₹1500 INR	19-Dec-2025 04:45 GMT
International Lead-Gen Website Redesign -- 2 Category: Conversion Rate Optimization, Graphic Design, HTML, PHP, SEO, Web Design, Web Development Budget: ₹12500 - ₹37500 INR	19-Dec-2025 04:44 GMT
Vercel Word Template PDF Generator Category: API Integration, CSS, HTML, HTML5, JavaScript, Next.js, Vercel, Word Processing Budget: $30 - $250 USD	19-Dec-2025 04:43 GMT
Virtual Event Project Manager for Fitness Festival Category: Contract Management, Data Entry, Documentation, Event Management, Event Planning, Excel, Project Management, Research, Risk Management, Virtual Assistant Budget: $30 - $250 AUD	19-Dec-2025 04:42 GMT
Multivendor & Multilingual WP Upgrade Category: CSS, Documentation, Frontend Development, HTML, PHP, Web Development, WooCommerce, WordPress Budget: ₹1500 - ₹12500 INR	19-Dec-2025 04:35 GMT
2D Animated Service Promo Video Category: 2D Animation, 2D Animation Explainer Video, After Effects, Animation, Script Writing, Sound Design, Video Editing, Video Production, Video Services, Voice Over Budget: $30 - $250 USD	19-Dec-2025 04: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