Excel Cleanup & Pivot Dashboard

₹12500-37500 INR

Open

Posted 1 minute ago

•

Ends in 6 days

₹12500-37500 INR

Paid on delivery

I have an existing Excel workbook that first needs to be put in order, then turned into a concise, pivot-table-driven dashboard. Here’s the scope: • Data cleanup – Remove every duplicate row without losing legitimate repeats – Correct all data formats (dates, numbers, text) so they behave consistently in formulas and pivots – Fill or clearly flag missing values to keep the dataset analysis-ready • Dashboard creation – Build a refreshable pivot-table dashboard that summarises the cleaned data at a glance – Include filters or slicers so I can drill down instantly – Keep the layout simple and presentation-ready on one tab Deliverables will be a single Excel file that contains: 1. The original raw data (untouched) 2. A cleaned data sheet produced via formulas, Power Query, or VBA—whatever you prefer, as long as it updates easily 3. The finished pivot dashboard with descriptive headings and colour-coded fields I’ll consider the job complete once the workbook passes a quick duplicate check, all formats respond correctly to SUM/AVERAGE tests, blanks are handled as agreed, and the pivots recalculate without errors when I drop in fresh data.

Visual Basic for Apps

Project ID: 40681305

About the project

3 proposals

Open for bidding

Remote project

Active 16 secs ago

Place your bid

Bid amount

₹

INR

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

3 freelancers are bidding on average ₹21,667 INR for this job

@mohjib092

Hi, I can clean and structure the workbook while keeping your original data completely untouched. I’ll remove true duplicates, standardize the formats, handle missing values, and build a simple refreshable PivotTable dashboard with slicers on one clean presentation tab. I’ll make sure the setup is easy to refresh when you add new data and test the workbook against your acceptance criteria before delivery. Thank You,

₹25,000 INR in 5 days

4.6

(15 reviews)

4.9

@Jennycreation

I am Priyanka, an expert with 17+ years of experience in various software development fields including, but not limited to, ASP.NET C#, Python Automation, and Crypto Currency. These experiences uniquely qualify me for your project. In the case of your excel cleanup & pivot dashboard job, I have a robust skill set that I believe will be highly valuable. Over the years working with various technologies, I have mastered all Microsoft Office Suite applications including Excel to transform raw data into sophisticated and purposeful dashboards. My meticulous attention to detail guarantees your dataset will be scrupulously cleaned-upinciple-a task I often do-for optimum functionality within formulas and pivots. Furthermore, my extensive exposure dealing with financial and stock datasets aligns closely with your project requirements. Being able to manipulate large quantities of data and creating smart visual representations using pivot tables are second nature to me. The deliverables you're seeking including filters/Slicers, responsive pivot-dashboard for drill-down analysis, and presentation-ready layout are all areas in which I'm exceptionally skilled.

₹25,000 INR in 7 days

0.0

(0 reviews)

0.0

@venkatsreekanth

Hello, I can help you clean and organize your Excel workbook and build a professional, refreshable pivot-table dashboard. I will preserve your original raw data, remove duplicate records while retaining valid entries, standardize dates, numbers, and text formats, and handle missing values by filling or clearly flagging them. The cleaned dataset will be created using Power Query, formulas, or VBA as appropriate, making it easy to refresh with new data. I will then create a clear, one-page dashboard with Pivot Tables, slicers, filters, descriptive headings, and color-coded fields for quick analysis. I focus on accuracy, clean formatting, and timely delivery, and I will ensure all formulas and pivot tables recalculate correctly when new data is added. I look forward to delivering a reliable and easy-to-maintain Excel solution.

₹15,000 INR in 5 days