
Closed
Posted
Paid on delivery
Scope (Tabs & Purpose) Dashboard: Card-based overview (KPI tiles + charts). Budget Tracker: Category budget vs actual vs paid + expense tracker. Attendees (Guest List): Invitations, RSVP, dietary, contact, seating link. Task Timeline: Tasks with deadline, owner, priority, completion. Daily Schedule (Itinerary): Day-of timeline (start/end, activity, owner). Packing & Essentials: Checklist by category with progress %. Suppliers (Vendors): Directory, contracts, payment due dates. Directory (Contacts): People referenced by dropdowns. Seating & Tables: Tables, capacity, assigned/remaining seats. Catering (Food & Drinks): Menu + dietary counts from Attendees. Media Plan (Photography): Shot list with priority & completion. Gifts & Thank-Yous: Gifts log + thank-you tracking. Travel Plans (Honeymoon): Bookings, payments, activities. Home (new): Logo + big navigation buttons to key tabs. Branding & Theme Colors: Deep Teal #004E64 (primary), Bright Green #64C13B (success/KPIs), Lime #C4E86B (warnings), Very Light Grey #F3F4F6 (cards), Dark Grey #111111 (text). Fonts: Headings Montserrat, Body Segoe UI/Calibri. Provide and apply a .thmx theme so charts/shapes/tables use Theme Colors. Dashboard Layout (must deliver) Full-width teal header with logo + title; subheader shows event name/date/days. KPI cards (2×2 grid) with icons, titles, and cell-linked values: Budget (Planned / Actual / Paid / Left to pay) Attendees (Total / Confirmed / Seated / Waiting) Tasks (Total / Completed / Overdue / Today + % complete) Packing progress (Packed / Total + %) Charts in cards: RSVP breakdown (pie), Budget (bar), Task completion (bar). Use rounded rectangles (light grey) as cards; values in Bright Green. Data Model & Rules Use Excel Tables (Ctrl+T) for all grids; keep existing column logic. Validations: RSVP (Attending/Unable/Pending), Invitation (Sent/Not), Dietary list, Yes/No flags, Table dropdown from Seating. Named ranges for Dashboard KPIs (e.g., Budget_TotalPlanned, Guests_Confirmed, Timeline_CompletionPct). Conditional formatting mapped to theme: Tasks: Completed = pale green; Due Soon = lime; Overdue = stronger lime. Attendees: Attending = pale green; Pending = lime; Unable = grey. Budget: Variance < 0 = lime. Wording & Structure (to avoid cloning) Replace “Wedding”→“Event”; “Guests”→“Attendees”; “Vendors”→“Suppliers”; etc. Rename tabs as above; adjust dashboard composition/order and add at least one new KPI (Packing %). Keep formulas but rebuild visual cards/shapes, linking text boxes to the source cells. UX & Protection Add Home tab with navigation buttons. Freeze headers; turn gridlines off on Dashboard only. Set shapes to Don’t move or size with cells; lightly protect sheets (inputs unlocked). Deliverables Branded Excel workbook (.xlsx or .xlsb) with all tabs above, theme applied, and dashboard wired. Theme file (.thmx) with colors/fonts. One-page hand-off notes listing named ranges, validations, and any helper ranges. Acceptance Criteria Dashboard KPIs/charts update live from data sheets. All tables use Theme Colors & Fonts; cards/icons match brand. Wording/tab names changed; layout visibly different from the original. No broken references; validations and conditional formatting work. Sheets protected appropriately; inputs remain editable. Constraints / Preferences Prefer no macros (unless agreed); pure Excel formulas/tables/CF. Keep performance smooth up to ~2,000 attendee rows and ~500 expenses. Use Theme Colors (not hardcoded Standard Colors) so palette can change later.
Project ID: 39721329
88 proposals
Remote project
Active 8 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
88 freelancers are bidding on average £140 GBP for this job

Hello there, I can build your Excel Event Management Dashboard with all required tabs, branded .thmx theme, and a modern card-based dashboard showing live KPIs (Budget, Attendees, Tasks, Packing %). All sheets will use Excel Tables, named ranges, and conditional formatting tied to theme colors/fonts. The Home tab will include navigation buttons, validations and protections will be applied, and the workbook will remain responsive up to thousands of rows. You’ll also get the theme file and a concise hand-off guide. Questions: – Do you want sample data pre-filled or blank templates? – Should Home tab buttons be VBA-free or hyperlink-based? I am a TOP Rated Freelancer, and you can check my past work and reviews here: https://www.freelancer.com/u/kamran2012 Looking forward to potentially working together on this project. Thanks and Best regards, Kamran
£130 GBP in 10 days
8.4
8.4

Hello, I came across your project and found it truly interesting. With over eight years of hands-on experience in this field, I have successfully delivered high-quality solutions to clients worldwide. My dedication to excellence is reflected in the 180+ positive reviews from satisfied clients. I’d love to bring this expertise to your project and ensure outstanding results. However, I do have a few important points I’d like to clarify to align perfectly with your vision. Let’s connect via chat, where I can also share relevant examples of my past work. I'm looking forward to hearing back from you! Best Regards, Divu.
£250 GBP in 4 days
8.2
8.2

Hello, I can create a fully branded Excel workbook with all the tabs, dashboards, KPIs, charts, tables, and conditional formatting as described. The workbook will use your theme colors/fonts, live-linked KPI cards, and fully responsive charts, while keeping inputs editable and sheets lightly protected. I’ll also deliver a `.thmx` theme file and a one-page handoff guide covering named ranges, validations, and helper ranges. A couple of quick questions: 1. Do you want any interactive elements (buttons, slicers) on the dashboard, or just static cards linked to tables? 2. Should I include sample data for testing formulas and visual updates, or will you provide the dataset? Best, Bilal Khalid
£150 GBP in 7 days
7.4
7.4

Hello Adam B., I am excited about the opportunity to work on your project for a Comprehensive Excel Event Management Dashboard. Your detailed project description showcases the complexity and depth of the dashboard you envision, from budget tracking to seating arrangements and everything in between. With over 5 years of experience in Excel data management and dashboard creation, I am confident in my ability to bring your vision to life. My expertise in Excel Tables, named ranges, and conditional formatting will ensure that the dashboard is not only visually appealing but also highly functional and user-friendly. I have included links to my portfolio for you to review my previous Excel dashboard projects: https://www.freelancer.com/u/eDesignerExpert To better understand your needs, could you please provide insights on your preferred approach to data visualization and any specific functionalities you would like to see in the dashboard? Your input will help me tailor the design to meet your expectations effectively. Thank you for considering my proposal. I look forward to the opportunity to collaborate with you on this project. Best regards, Ramneet
£21 GBP in 1 day
7.6
7.6

HI, Muhammad here With nearly a decade of experience in web development and designing, I have developed comprehensive skills in using Excel to interpret and present data. I am very comfortable with excel tables, formulas, conditional formatting, and charts – all the elements that your project centralizes on. My strong grasp of HTML and PHP ensures that I will be able to keep the sheets protected while making inputs remains editable just as you've requested in your project description. You mentioned you prefer no macros but pure Excel formulas/tables/CF; no problem! I'll ensure a smooth and efficient performance of the event management dashboard without relying on macros. Having worked on similar large-scale database projects in the past, I am confident that your desire for smooth operation with up to ~2,000 attendee rows and ~500 expenses is well within my capability. As an "All Rounder Experienced Web developer" and a "Web designer," I bring the best of both worlds to any project. Not only will your comprehensive Excel event management dashboard work flawlessly, but it will also look beautiful! Being great with aesthetics - design layout , placement , UI/UX - your project materials are going to be visually different from the original.
£100 GBP in 4 days
7.7
7.7

With over 7 years of experience in Full-stack development and my expertise in Data Visualization, including Excel Macros and VBA, I assure you that I have the necessary skills to deliver an exceptional Excel Event Management Dashboard. Having previously worked with top-tier companies such as Metlife GOSC and DXC Technologies, I understand the value of accuracy, speed, and a user-oriented approach. Moreover, my proficiency in Excel Formulas, Web Scraping, Data Crawling along with other relevant skills give me the ability to tackle even the most complicated tasks associated with your project effortlessly. Additionally, I am well-versed in various programming languages including PHP and HTML which complements my understanding of financial analyses needed for your budget tracker component. Lastly, as a CEO and Founder myself, I acknowledge the importance of building strong relationships with clients by consistently delivering high-quality work; this is what stands at the heart of my business model. In light of this, I guarantee not just your satisfaction but a commitment to long-term project relations. So why wait? Let's make your comprehensive Excel Event Management Dashboard a success together. My speed. Your Satisfaction! Let's get to work!
£180 GBP in 3 days
7.5
7.5

Hello Adam B. I'm Sharmeen from the USA, and I've reviewed the details for Comprehensive Excel Event Management Dashboard. With over 8 years of experience in HTML, Excel VBA, Excel Macros, Website Design, Data Visualization, Data Analysis, PHP and Graphic Design, I am confident in my ability to deliver exceptional results for your project. Please take a moment to view my portfolio here: https://www.freelancer.com/u/AmeliaArty My services include: Innovative design concepts tailored to your needs Final files with full copyright Formats: .AI, .PSD, .EPS, .PDF, .JPEG, .PNG, .SVG I’d love to discuss your project further. Looking forward to your response! Thankyou,
£65 GBP in 2 days
6.7
6.7

As an established Full Stack Software Engineer and accustomed to conquering large projects, I am confident that my skills align perfectly with your comprehensive Excel event management dashboard project. To begin, I have expansive expertise in utilizing Excel. Since you preferably want to avoid macros but rather utilize pure Excel formulas/tables/CF, I can guarantee high performance even with large data load as required for ~2,000 attendee rows and ~500 expenses. My coding structure is clean, organized with provisioning for scalable solutions. Another element of the project that makes me the perfect fit is my experience in Graphic Design, specifically with branding and theme selection. Utilizing an established Thmx or HTML5 or even CSS3, Bootstrap framework will allow us to create a vibrant yet professional dashboard. As per your requests, I will meticulously apply the designated color scheme and theme fonts (Montserrat / Segoe UI / Calibri) to every aspect of the project ensuring a cohesive look and feel throughout.
£50 GBP in 5 days
7.2
7.2

As a seasoned web designer and digital solutions expert with 10+ years of experience, I'm confident that I possess the skills and capabilities required to exceed your expectations for the event management dashboard. I've worked extensively with HTML, CSS, and PHP to create highly responsive, user-friendly, and visually stunning interfaces. Applying this proficiency to your project, I'll build a comprehensive Excel event management dashboard that checks all the essential boxes outlined, ensuring that it meets your unique needs to perfection. Additionally, my eye for design and knack for incorporating the latest trends will contribute positively to bringing your vision for the branding and theme of the dashboard to life. Apart from just delivering on functionality, I appreciate the importance of aesthetics which is why I'll meticulously apply the color palette and fonts you've specified. Furthermore, utilizing my knowledge in SEO and Social Media Marketing, I'll make sure the dashboard boasts not only a great user interface but also has ample online visibility which is important if you want to share dashboards or report results weekly or monthly
£20 GBP in 1 day
6.8
6.8

Hello, I have carefully reviewed your project details and fully understand the requirements for developing a professional, fully-branded Excel workbook to manage all aspects of your event. With my expertise in advanced Excel design, data visualization, and theme customization, I can deliver a polished solution that not only functions seamlessly but also reflects your specified branding and layout standards. My approach will start with building a .thmx theme file using your chosen color palette and fonts so all charts, tables, and shapes consistently follow the event branding. I will then create structured Excel Tables for each functional tab (Budget Tracker, Attendees, Task Timeline, etc.), applying data validation lists and conditional formatting mapped directly to the theme. The Dashboard will feature a teal header with your logo, KPI cards in a 2×2 grid, and charts embedded into cards for RSVP breakdown, budget, and task completion. KPIs such as budget, attendees, tasks, and packing progress will be linked to named ranges for live updates. I will add a Home tab with large navigation buttons for a user-friendly experience, and set light sheet protection while keeping input fields editable. Would you like me to also include a compact “Daily Snapshot” card on the Dashboard that shows today’s tasks and key attendee updates alongside the main KPIs? Let’s connect so I can tailor the design perfectly to your event needs. Best Regards, Aneesa.
£100 GBP in 1 day
6.8
6.8

I excel at crafting dynamic Excel dashboards, recently delivering a similar project using Power Query for data cleansing and Power Pivot for advanced analytics, resulting in a 30% efficiency increase for the client. My expertise lies in creating intuitive, data-driven solutions leveraging VBA for automation and advanced charting techniques. My approach involves initially analyzing your existing data to determine optimal data structuring for seamless integration with Power Query. Subsequently, I'll develop the KPI dashboard, incorporating interactive charts and card-based overviews. The Budget Tracker will leverage categorized data analysis and pivot tables for granular budgeting insights. Finally, rigorous testing and comprehensive documentation will ensure a smooth transition and future maintenance. Ready to discuss your specific needs and timeline? Could you share more details on the data sources and desired KPIs for the dashboard, so I can ensure a perfectly tailored solution that meets your precise requirements?
£189.47 GBP in 21 days
6.9
6.9

Hi there, I’m submitting a bid for your project and would love to offer my professional services. With my experience, I’m confident in delivering high-quality results tailored to your project requirements. Feel free to message me to discuss the full scope and budget. View my Freelancer portfolio and client reviews: https://www.freelancer.com/u/Feriver Looking forward to connecting with you. Best regards, Asif Nawaz
£250 GBP in 3 days
6.5
6.5

Hello Adam, I am excited about the opportunity to create a comprehensive Excel Event Management Dashboard tailored to your specifications. With my expertise in data visualization and a keen understanding of event management needs, I can develop a user-friendly dashboard that includes the required tabs like Budget Tracker, Attendees, Task Timeline, and more, all featuring your specified branding in deep teal and bright green. I will ensure that the dashboard's KPIs update live from data sheets and that all tables adhere to your specified theme colors and fonts. Additionally, I will thoroughly test the functionality to avoid any broken references, uphold validations, and maintain the smooth performance you desire. Your preference for no macros will be respected as I rely on pure Excel formulas, ensuring the workbook remains performant even with substantial data. What is your preferred method for testing and validating the dashboard functionalities before final delivery? Thanks, Ahmet
£200 GBP in 10 days
6.0
6.0

Good Day Adam, As a senior Excel expert, I will create a comprehensive event management dashboard with various tabs for budget tracking, attendees, task timelines, daily schedules, packing checklists, suppliers, seating arrangements, catering details, media plans, travel plans, and more. I have experience in developing similar Excel dashboards and understand the importance of organizing event data efficiently. Why Choose me? - Unlimited Revisions: Ensuring your satisfaction. - Unique Creations: Crafting original solutions. - Money-Back Guarantee: Providing risk-free services. - 24/7 Communication: Available for any queries. - Timely Delivery: Projects completed promptly. Browse my portfolio at https://www.freelancer.com/u/leenadvnani6 for unique visual solutions. Let's discuss your project requirements further in the chat. Thank you & Regards, Leena.
£20 GBP in 1 day
5.6
5.6

With a track record of tackling similar projects, our team is uniquely equipped to address your needs with insight, agility, and a commitment to exceptional outcomes. Your requirement for a clean, professional, and seamlessly integrated Excel workbook aligns perfectly with our expertise in creating user-friendly, automated solutions. We specialize in designing customized Excel solutions, applying themes, and creating dynamic dashboards that update live from data sources, all while maintaining a visually appealing and branded look. We would be delighted to discuss your project in further detail. Best Regards, Desmond
£150 GBP in 7 days
5.7
5.7

Hello, Drawing from my decade-long experience in full-stack development and UI design, I wholeheartedly believe that I am the perfect fit to create your Comprehensive Excel Event Management Dashboard. Your project description resonates well with my skills and strengths of meticulous attention to detail and delivering user-centric applications at large scale. My HTML, PHP expertise combined with my track record of creating robust, efficient and reliable applications perfectly complements your preference for no macros in this project. By leveraging only pure Excel formulas, tables, and conditional formatting, I can ensure seamless performance even with large data volumes, mitigating the risk of any lagging or compromises. Lastly, what sets me apart is not just my technical skills but my understanding of what it means to be a developer tasked with creating the right solutions for unique needs. I am not interested in just creating isolated systems but always aim to align technology with users' requirements - evident from my long-standing interest in React development. I take pleasure in making pragmatic designs that satisfy both the aesthetic standard and usability expectation. I really look forward to taking on this project! Thanks!
£74 GBP in 15 days
5.5
5.5

Hello, As someone who dabbles in Computer Science and boasts of an extensive background as a Web Developer, I understand the intricacies involved with building highly-functional software. Your project aligns perfectly with my skills in Java, Excel formulas, tables and conditional formatting, all of which are key elements required for your event management dashboard. I’ve have hands-on experience with Excel's Data Models and named ranges, ensuring that your project's BBudget Tracker, Attendees (Guest List), Task Timeline, Daily Schedule (Itinerary) and others are done uniformly. I possess a keen eye for aesthetics without compromising functionality. As such, I can rebrand your Excel workbook to incorporate your chosen theme colors and fonts; this includes the use of Card-based overviews with KPI tiles/charts and Full-width teal header with logo + title. With a deep understanding of the significance of user experiences, I will recreate the packed view by categories you requested as a checklist with progress percent using Rounded rectangles cells emphasized by Bright Green values. Finally, I am well aware of the importance of delivering on time without exceeding budget. I guarantee that your project will be ready for preview within an agreed timeframe. My ultimate goal is customer satisfaction and delivering complete solutions that exceed expectations. Do not hesitate to reach out to me should you have any questions or need further cl Thanks!
£150 GBP in 1 day
5.3
5.3

Hi there! I read through your requirements carefully and I understand you need a fully branded, functional Excel event planner with a dashboard, KPI cards, charts, and multiple tabs covering everything from budget tracking to attendee management and packing. I recently completed a similar project for a corporate event planner where I built a full-featured Excel workbook with dynamic dashboards, themed KPI cards, live charts, and conditional formatting that updated automatically from data tables. The client loved how intuitive and visually clean it was, and it scaled smoothly for 1,500+ rows of data. For your project, I’d create all tabs with structured Excel tables, link dashboard KPIs via named ranges, apply your brand theme (.thmx), implement conditional formatting per your color rules, and add a Home tab with big navigation buttons. Charts and cards will be fully linked to live data, and I’ll ensure smooth performance and sheet protection while keeping inputs editable. Let’s chat so I can see your current workbook and plan the cleanest, fastest setup. If you choose me, you’ll have a fully functional, branded Excel planner ready quickly—and even if not, I hope you find someone great to bring this project to life. Good luck!
£150 GBP in 7 days
5.3
5.3

Respected Adam B. This is Adeel from the UK. I have expert skills in Logo Design, Graphic Design, Illustrator, and Photoshop. I have completed more than 300+ projects with 98% client satisfaction. I can provide excellent options with unlimited revisions as per your requirement just in 2 days. As I am new on Freelancer, I am providing my services at very affordable rates. Can we please discuss the project "Comprehensive Excel Event Management Dashboard" in detail over chat? Thank you for considering my proposal. Sincerely, Adeel
£20 GBP in 3 days
5.6
5.6

Warm Greeting! I understand you need a fully branded, professional Excel workbook that combines multiple event-planning tools (budget, attendees, tasks, schedule, suppliers, etc.) into a live-updating dashboard with KPIs, charts, and clean navigation. My approach is to design the workbook around structured Excel Tables, named ranges, and conditional formatting tied to your theme colors/fonts. I’ll apply a custom .thmx theme for consistent branding, build a card-based dashboard with KPI tiles and charts, add a Home tab with large navigation buttons, and ensure validations, dropdowns, and protection are correctly applied for a smooth, professional UX. The end result will be a fast, formula-driven solution (no macros unless required) that can scale to thousands of rows while keeping the dashboard visually polished and instantly updating. While I don't have many reviews on this platform yet, I bring years of experience building websites and custom Excel tools for global clients. To build reputation here, I'm offering a discounted rate without compromising on quality. I’m excited about the opportunity to collaborate and look forward to working with you! Best regards, Muamer Kaukovic
£135 GBP in 3 days
5.3
5.3

Ireland
Member since Aug 24, 2015
$15-25 USD / hour
$30-250 USD
$250-750 USD
$10-30 USD
$30-250 AUD
₹600-1500 INR
₹1500-12500 INR
$250-750 USD
$250-750 CAD
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR
$10-30 USD
$8-15 USD / hour
₹750-1250 INR / hour
$250-750 USD
₹12500-37500 INR
$30-250 USD
$250-750 USD
$80-240 HKD