1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 06-May-2026 21:18 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
Meta Expert Required for Lead Generation AppDevelopment agency Category: Conversion Rate Optimization, Facebook Ads, Google Adwords, Google Analytics, Instagram Ads, Internet Marketing, Lead Generation, PHP Budget: $10 - $30 AUD	06-May-2026 16:04 GMT
HOA Voting Legal Interpretation Category: Contract Management, Contracts, Legal, Legal Analysis, Legal Consultation, Legal Research, Legal Writing, Property Law Budget: $250 - $750 USD	06-May-2026 16:03 GMT
Manual WordPress Language Site Conversion Category: CSS, Elementor, HTML, PHP, SEO, Web Development, WordPress, WordPress Design Budget: ₹600 - ₹1500 INR	06-May-2026 16:02 GMT
Single-Page Restaurant Menu Design Category: Adobe Illustrator, Adobe InDesign, Branding, Creative Design, Graphic Design, Illustration, Menu Design, Photoshop, Print Design, Typography Budget: $30 - $250 USD	06-May-2026 16:02 GMT
Data Entry Specialist for CRM & WordPress Category: CRM, Data Architecture, Data Entry, Data Management, Email Marketing, PHP, Website Management, WordPress Budget: $750 - $1500 USD	06-May-2026 16:02 GMT
Outdoor ESP32 LoRaWAN Automation Board Category: Arduino, Electrical Engineering, Electronics, Embedded Systems, Microcontroller, PCB Layout, Prototyping, Signal Processing Budget: $5000 - $10000 USD	06-May-2026 16:01 GMT
Edit Group Photo Category: Image Processing, Photo Editing, Photo Retouching, Photoshop Budget: $30 - $250 USD	06-May-2026 16:01 GMT
Small time IT Services Website Build Category: CSS, Graphic Design, HTML, PHP, SEO, Web Application, Web Design, Web Development, WordPress Budget: ₹1500 - ₹12500 INR	06-May-2026 16:00 GMT
Natural Safari Photo Editing Category: Adobe Lightroom, Photoshop, Image Processing, Photo Editing, Photo Retouching, Photoshop Design, Visual Design Budget: £20 - £250 GBP	06-May-2026 16:00 GMT
Wind-Resistant Roof Addition Category: AutoCAD, Building Design, Building Engineering, Civil Engineering, Construction, Mechanical Engineering, Roofing, Structural Engineering Budget: $30 - $250 USD	06-May-2026 15:59 GMT
I have two excel spreadsheets that are generated by my point of sale system. One is a daily sales report and the other is the time an employee works. From the one spreadsheet I need to go through and determine who worked at what time. From the 2nd spre Category: Data Analysis, Data Entry, Data Extraction, Data Integration, Data Management, Data Processing, Data Visualization, Excel Budget: $250 - $750 USD	06-May-2026 15:59 GMT
E-Commerce Lead Generation Website Category: Graphic Design, HTML, Laravel, PHP, Shopify, Web Development, Web Design, WooCommerce Budget: ₹1500 - ₹12500 INR	06-May-2026 15:59 GMT
Detailed Interior Elevation Renderings - 2D Category: 2D Drawing, 2D Layout, 3D Animation, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Interior Design Budget: min £36 GBP	06-May-2026 15:57 GMT
Home & Office Interior Design Category: 3D Modelling, 3D Rendering, Architecture, Building Architecture, Floor Plan, Interior Design Budget: €250 - €750 EUR	06-May-2026 15:56 GMT
Next.js Colyseus 1-on-1 PvP Category: API Integration, CSS, Full Stack Development, Game Design, HTML5, JavaScript, Next.js, Node.js, React.js, Vercel Budget: $1000 - $2500 USD	06-May-2026 15:56 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