
Closed
Posted
Paid on delivery
I’m working with an Excel workbook that has grown messy over time and I need it transformed into a reliable decision-making tool. First, the raw data must be cleaned end-to-end: remove all duplicates, fill or flag missing values in a sensible way, and standardise every column’s format so dates, numbers and text behave consistently. Once the dataset is solid, I want an interactive dashboard—built entirely in Excel—that lets me explore: • Monthly sales trends so I can spot seasonality • Product-level performance to highlight best- and worst-sellers • Regional sales distribution for quick comparisons across territories Feel free to leverage PivotTables, PivotCharts, Power Query or any native Excel features that keep the file self-contained. The final deliverable should include: 1. A cleaned data sheet ready for future refreshes 2. A separate, visually clear dashboard tab with slicers or filters for time, product and region If anything in the source data prevents full automation, leave concise notes so I can update it easily later.
Project ID: 40387317
11 proposals
Remote project
Active 27 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
11 freelancers are bidding on average $44 USD for this job

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$80 USD in 3 days
6.7
6.7

As an experienced freelancer with a solid background in web and mobile app development, I believe I can bring some fresh perspective and unique solutions to your Excel cleaning and Sales Dashboard project. While my core skills revolve around JavaScript and PHP, my understanding of data manipulation and reporting through efficient programming will be revelatory for you. Throughout my satisfying 9+ years career journey, I have consistently applied my sharp analytic skills to craft reliable decision-making tools. I have worked on numerous transformation projects similar to yours, where I had to clean up large datasets while ensuring continued automation. My deep knowledge of Excel's native features like PivotTables, PivotCharts, Power Query, etc. will be instrumental in creating the interactive dashboard that you require. By choosing me for this project, you can expect a diligently cleaned dataset ready for future refreshes and an elegantly designed dashboard tab with slicers or filters for time, product and region. Additionally, I ensure after-delivery support exceeding industry standards by providing a 3-month free support period. My client-centric approach will surely add value to your project as I genuinely care about bringing your ideas to reality, effectively and efficiently.
$120 USD in 7 days
5.4
5.4

As a seasoned professional with over six years of experience, I am more than qualified to tackle your data cleaning and dashboard design project. My expertise in Full Stack Development including JavaScript and PHP gives me an intricate understanding of Excel's advanced features like PivotTables, PivotCharts, Power Query, and the ability to leverage them effectively to transform your raw data into a reliable decision-making tool. Having successfully completed 850+ projects, including similar tasks involving data cleaning and visualization, I am deeply familiar with the nuances of standardizing column formats and filling or flagging missing values. This enables me to clean your data end-to-end with the highest level of accuracy and efficiency. Furthermore, my frontend skills in React.js, Vue.js combined with the problem-solving proficiency gained from working on 20,000+ hours and counting make me highly skilled at creating interactive dashboards that are easy to use but powerful tools for exploring and extracting actionable insights. Remembering deadlines for pick up is something you wouldn't need to worry about as I specialize in promptly meeting project goals. Choose me for your project needs and let's create an impressive Excel-based sales dashboard for you!
$66 USD in 2 days
4.0
4.0

Hello, I can transform your messy Excel file into a clean, reliable, and fully interactive decision-making tool. I’ll handle complete data cleaning—removing duplicates, standardizing inconsistent formats (especially dates), fixing or flagging missing values, and ensuring all columns (Price, Qty, Total) are accurate and structured for analysis. Then, I’ll build a professional dashboard in Excel using PivotTables, Power Query, and slicers. It will include: Monthly sales trends to identify patterns and seasonality Product-level performance to highlight top and low performers Regional sales comparisons for quick insights You’ll receive a clean, refreshable dataset and a visually clear dashboard that’s easy to update and use. I’m ready to start right away. Best regards,
$10 USD in 1 day
4.2
4.2

Greetings I can surely help you for Excel Cleaning & Sales Dashboard I am in the IT industry since more than a decade and serve so many clients in building and rebuilding websites, software, and applications I have strong hands-on different cms like webflow, Wordpress, shopify, squarespace, wix and on different programming languages like PHP, Laravel, React, Node.js, HTML, CSS, And I did the migration from HTML to click funnels. I have made so many websites (E-commerce, WordPress, Classified admin, WooCommerce, etc.), bots, softwares, and Mobile applications (Android, IOS, and Huawei Play store) in my entire career. I have strong hands on both the front end and back end. Currently, I am part of the team who are dealing with miscellaneous tasks in dubizzle and Mzad Qatar including design and layouts and they both have more than 1 million users. I believe that you are looking for a web designer and for sure you will get your end desire result with plagiarism-free work and with better quality as I am assuring you this. Package deals can also be done for long-term collaboration as per the client's requirement. Kindly do come on chat so that we can discuss project details further more.
$10 USD in 2 days
3.2
3.2

Hi, My name is Cindy Viorina and I specialize in cleaning complex Excel workbooks and building interactive dashboards. I have reviewed your request to clean the raw data end-to-end and deliver a self-contained Excel dashboard for monthly trends, product performance, and regional distribution. I will remove duplicates, sensibly fill or flag missing values, and standardize date, number and text formats so sheets behave consistently. For the dashboard I will use Power Query for repeatable ETL, PivotTables/PivotCharts and slicers so you can filter by time, product and region without external tools. I will leave concise notes where full automation is blocked and supply a cleaned-data sheet plus a separate dashboard tab ready for future refreshes. I can communicate in real time in your time zone and provide a simple demo or portion of the project within 12 hours of starting. Q1: Do your raw files include a stable transaction ID or will deduplication rely on composite keys and timestamps? Q2: Which date format and fiscal month definition should I use for the monthly trend analysis? Q3: Are there any archived sheets or hidden rows we should ignore during cleaning? Which worksheet contains the raw transactional records and do those records include a consistent transaction ID I can use for reliable deduplication? Best regards, Cindy Viorina
$10 USD in 4 days
3.0
3.0

Hello, I checked your project "Excel Cleaning & Sales Dashboard" and I already have a clear idea how to deliver this efficiently. I have solid experience in PHP, JavaScript, Visual Basic, Excel, Excel Macros, Data Visualization, Data Analysis, Data Management, and I’ve worked on similar projects where I delivered high-quality, scalable, and clean solutions. Why choose me? • Strong expertise in PHP, JavaScript, Visual Basic, Excel, Excel Macros, Data Visualization, Data Analysis, Data Management • Clean, optimized, and scalable code • Fast communication and daily updates • 100% focus on delivering results, not just code If needed, I can also suggest improvements to make your project even better. Let’s connect I’m ready to start right away. Best regards, Umer
$20 USD in 1 day
2.9
2.9

Hello, I can transform your Excel workbook into a clean, reliable, and fully interactive decision-making tool. I will start by cleaning your raw data end-to-end using Power Query—removing duplicates, handling missing values logically, and standardizing all formats (dates, numbers, and text) to ensure consistency and accuracy. The cleaned dataset will be structured for easy future updates with a simple refresh. Once the data is optimized, I will build a professional Excel dashboard that includes: * Monthly sales trends to clearly identify patterns and seasonality * Product-level performance to highlight top and low-performing items * Regional sales distribution for quick comparison across locations The dashboard will be fully interactive using slicers and filters for time, product, and region, allowing you to explore insights instantly without manual effort. Deliverables: * Clean, structured data sheet ready for future refresh * Interactive dashboard with PivotTables and PivotCharts * Clear notes for any assumptions or limitations in the data I focus on accuracy, clarity, and usability so you can make decisions confidently from your data. I’m ready to start immediately and can ensure a quick turnaround. Best regards, Mitali Kumari
$30 USD in 1 day
0.9
0.9

As an accomplished full-stack developer with a keen eye for detail, I'm well-suited to sort out your messy Excel workbook. With my expertise in JavaScript and PHP, not only can I clean up your data end-to-end by removing duplicates and flagging missing values, but I can also ensure that each column is standardized consistently for greater ease of use. Building a reliable decision-making tool is my forte, and in this particular case, it means creating an interactive sales dashboard that aligns perfectly with your needs. Employing native Excel features like PivotTables, Power Query, and PivotCharts, I will create a visually clear dashboard that allows you to have a comprehensive view of your business at both the monthly and product level. This way, you will not only be able to spot sales trends and seasonality but also highlight your best- and worst-sellers for better decision-making. Though my primary specialization is in Node.js and PostgreSQL development, I pride myself on being a quick learner,and consider myself efficient in working across different platforms. With my deep understanding of business operations and technical skills combined with my commitment to clear communication and timely delivery, I am confident that I can produce a cleaned dataset ready for future refreshes as well as an interactive dashboard with slicers or filters for time, product, and region. Hire me for this project and let's transform your messy data into a valuable resource!
$20 USD in 7 days
0.0
0.0

Jawa Barat, Indonesia
Member since Apr 12, 2026
$30-250 USD
₹12500-37500 INR
$250-750 USD
$80-240 HKD
₹100-400 INR / hour
₹1500-12500 INR
₹600-1500 INR
₹37500-75000 INR
$8-15 USD / hour
€30-250 EUR
₹600-1200 INR
$14-60 NZD
₹750-1250 INR / hour
$250-750 USD
$30-250 USD
$15-25 USD / hour
₹400-750 INR / hour
$30-250 USD
€250-750 EUR
₹600-1500 INR