1001 Freelance Projects -- Excel Dashboard

Latest Projects from Freelance Marketplaces

Today is: 01-Mar-2026 16:30 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
Retail Startup Financial Models Category: Accounting, Business Analysis, Business Consulting, Data Analysis, Data Visualization, Excel, Finance, Financial Analysis, Financial Forecasting, Financial Modeling Budget: $250 - $750 AUD	01-Mar-2026 11:03 GMT
Source products from 1688.com to my WooCommerce store. Category: Adobe Illustrator, Brochure Design, Corporate Identity, Covers & Packaging, Label Design, Product Design Budget: €250 - €750 EUR	01-Mar-2026 11:03 GMT
Need 2 VAs for urgent one-time data entry job Category: Data Analysis, Data Collection, Data Entry, Data Integration, Data Management, Data Processing, Data Scraping, Excel, Virtual Assistant, Web Search Budget: $10 - $30 USD	01-Mar-2026 11:02 GMT
Wellness Retreat Lead Generation Specialist Category: Business Development, Digital Marketing, Facebook Marketing, Internet Marketing, Lead Generation, Leads, Market Research, Marketing Strategy, Sales, Social Media Marketing Budget: ₹1500 - ₹12500 INR	01-Mar-2026 11:01 GMT
Qualitative Interview Thematic Analysis Needed Category: Data Analysis, Data Visualization, Qualitative Research, Research Writing, Transcription Budget: $25 - $50 USD	01-Mar-2026 11:01 GMT
Construction Transport Booking App Development -- 2 Category: Android, Android App Development, API Development, Cloud Computing, IOS Development, IPhone, Mobile App Development, PHP Budget: ₹12500 - ₹37500 INR	01-Mar-2026 11:01 GMT
Facebook Brand Awareness Campaign Category: Advertising, Affiliate Marketing, Brand Management, Content Marketing, Content Strategy, Digital Marketing, Facebook Marketing, Instagram Marketing, Social Media Copy, Social Media Marketing Budget: $15 - $25 USD	01-Mar-2026 10:59 GMT
Weekly Sales & Purchase Sheet Updates Category: Accounting, Data Management, Data Processing, Excel, Financial Analysis, Google Sheets, Visual Basic Budget: $30 - $250 CAD	01-Mar-2026 10:56 GMT
Engineer for Advanced PCB Design & Programming Category: 3D Print Design, Circuit Design, CNC Programming, Electrical Engineering, Electronics, Embedded Systems, Motor Control, PCB Layout, Robotics, Signal Processing Budget: $1500 - $3000 USD	01-Mar-2026 10:56 GMT
[URGENT]Fix Cloud Run Egress Issue Category: Amazon Web Services, Cloud Computing, Containerization, Google Cloud Platform, Linux, MongoDB, Network Administration, Network Security, System Admin, Troubleshooting Budget: ₹600 - ₹2000 INR	01-Mar-2026 10:56 GMT
international Buyer Acquisition Agent for chemical bussiness Category: Account Management, B2B Marketing, Business Development, Lead Generation, Market Research, Sales, Sales Management, Sales Promotion Budget: ₹12500 - ₹37500 INR	01-Mar-2026 10:55 GMT
Instagram Growth & Reels Strategy Category: Adobe Premiere Pro, CapCut, Content Creation, Content Strategy, Instagram Marketing, Social Media Management, Social Media Marketing, Video Editing Budget: ₹750 - ₹1250 INR	01-Mar-2026 10:53 GMT
AI-Driven Social Media & Ads Manager Development Category: API Development, Full Stack Development, HTML, MySQL, Node.js, PHP, Python, Web Design Budget: $25 - $50 USD	01-Mar-2026 10:52 GMT
AWS Architecture & Cost Benchmark Category: Amazon Web Services, AWS Lambda, Cloud Computing, Containerization, Data Analysis, Linux, Network Administration, Virtualization Budget: €8 - €30 EUR	01-Mar-2026 10:51 GMT
Classic Bilingual Diary Design -- 2 Category: Adobe Illustrator, Adobe InDesign, Graphic Design, Illustration, Logo Design, Photoshop, Print Design, Typography Budget: ₹1500 - ₹12500 INR	01-Mar-2026 10:50 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