
Closed
Posted
Paid on delivery
Overview I turn your raw sales records into a clean, interactive Excel dashboard. You can see how the business is performing at a glance and filter by month and product category, without any manual calculation. What the dashboard shows Key figures: total revenue, number of invoices, units sold, and average invoice value Monthly sales trend: a line or column chart Sales by category: a chart showing which categories earn the most Top 5 products and top 5 customers: auto-updating ranked tables Filters: month and category slicers that update every figure and chart at once Deliverables One .xlsx workbook with a Data sheet, a Calculations sheet, and a Dashboard sheet Your existing sales data cleaned and set up as an Excel Table, so new rows are picked up automatically A one-page instruction sheet on how to add new data and refresh 7 days of support for questions or small fixes after delivery What I need from you A sample of your sales data (Excel or CSV) with at least these columns: date, invoice number, customer, product, category, quantity, amount Any branding preferences (colors, logo) and currency format Process and timeline Stage Time Data review and cleaning Day 1 Dashboard build Days 2–3 Your review and feedback Day 4 Revisions and final delivery Day 5 Scope Included: the features above and 2 rounds of revisions Not included: connecting to live accounting software, VBA macros, or data entry of paper records (these can be quoted as add-ons) Pricing (example) Basic (core metrics and charts): ₹3,000–5,000 Standard (all features above, with filters): ₹6,000–10,000 Premium (adds VBA buttons or Power Query auto-merge of monthly files): ₹12,000+ Adjust these to your experience and the platform's market rates.
Project ID: 40757133
11 proposals
Remote project
Active 5 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 ₹1,738 INR for this job

Being a data expert with a special affinity for Excel, I am confident that I can design an exceptional sales monitoring dashboard for your small business. With extensive experience in Data Analysis, Data Entry, and Data Visualization, I am skilled at transforming raw data into insightful and interactive reports – exactly what your project demands. My proficiency in advanced Excel functionalities like Pivot Tables, Charts, and Graphs will ensure that you have all key metrics at your fingertips. Moreover, my knack for crafting visually appealing spreadsheets means that your dashboard will not only be packed with accurate and relevant information but also look professional and easy-to-understand. Branding preferences or currency formats? Not a hassle! Your personal touches will be integrated seamlessly into the design. In addition to delivering a high-quality product, my commitment is backed by prompt support with any queries or minor changes after project completion. Rest assured, this is just the start of our journey towards a successful partnership. Choose me and let us transform your sales data into actionable insights to drive the growth of your business.
₹5,050 INR in 1 day
6.4
6.4

The main challenge is making the dashboard stay reliable as sales rows are added: every metric, ranked list, chart, and month/category filter needs to reflect the same cleaned source data without manual recalculation. I’ll structure the workbook so the data remains easy to maintain while the dashboard gives a clear view of sales performance. I’ll clean and format the provided records as an Excel Table, then organize the workbook into the requested Data, Calculations, and Dashboard sheets. Calculations will cover revenue, invoice count, units sold, and average invoice value; charts will show monthly trends and category performance, with ranked top-five product and customer tables. Pivot-based summaries and slicers can keep the views connected, while the table structure supports newly added rows. I’ll keep the solution within the stated scope and avoid VBA macros, which are excluded from the project. The result will be a one-page dashboard designed for quick reading, with consistent currency and visual formatting based on your preferences. I’ll also provide the instruction sheet for adding data and refreshing the workbook, make the included revision updates, and provide the stated seven days of support for questions or small fixes. The calculations and source layout will remain understandable so the workbook can be maintained without relying on opaque manual steps. Could you share a sample Excel or CSV file showing the date, invoice number, customer, product, category, quantity, and amount columns, along with your preferred currency format and any branding colors or logo?
₹920 INR in 5 days
3.8
3.8

I recently completed two Excel/VBA automation projects on Freelancer, both with 5-star feedback, including data processing, validation, formulas and production-ready workbook delivery. I can build your sales workbook with separate Data, Calculations and Dashboard sheets, including revenue/invoice KPIs, monthly trends, category analysis, Top 5 products/customers and slicer-based filtering. I’ll structure the source data as an Excel Table so new rows can be added and the dashboard refreshed without rebuilding anything manually. I can start immediately and deliver the first working version within 2–3 days, with final adjustments by day 4. One clarification before starting: do you already have the sales CSV/Excel data, or is the project description itself intended as a dashboard template specification?
₹750 INR in 4 days
2.8
2.8

As a skilled Excel, Macros, and VBA expert, I have extensive experience in generating effective and efficient Excel dashboards just like the one you need for your sales monitoring. With my proficiency in data analysis, calculations, charting and pivot tables, I can transform your raw sales records into a clean, interactive Excel dashboard that not only reveals your key figures but also displays insightful trends and analyses. One of my biggest strengths is automation scripts in Excel/Office using VBA macros. By leveraging this skillset I can set up your workbook in such a way that it automatically picks up new rows of data with minimal effort required from you. Additionally, I offer 7 days of post-delivery support to guarantee a smooth experience with the dashboard and address any questions or small fixes you might require. My pricing for the job can be customized to suit your experience, platform rates and budget constraints while ensuring optimal value for money. I can offer basic core metrics and charts or upgrade it to include filters for detailed analysis which makes my pricing quite flexible thus fitting into varying budgets smoothly. Therefore, given my expertise in Excel, my proficiency in creating interactive visuals using tools like Power BI, and most importantly, my dedication towards offering high-quality work with excellent post-delivery support, I am confident that I am the right fit for this project.
₹1,500 INR in 1 day
2.9
2.9

Hi, I can build your Excel sales monitoring dashboard as described. I will create a clean workbook with three sheets — Data, Calculations, and Dashboard — featuring total revenue, invoice count, units sold, average invoice value, monthly trend charts, category breakdown, top 5 products and customers, plus month/category filters that update everything at once. I will set up your data as an Excel Table for automatic expansion and include a one-page instruction sheet. Before starting, I will confirm your source columns (date, invoice number, customer, product, category, quantity, amount) and desired KPIs to ensure the dashboard matches your needs. Delivery in 3 days with 2 rounds of revisions included. Standard bid — no paid boosts or highlights. Looking forward to your sample data.
₹1,200 INR in 3 days
0.0
0.0

Hi, I can build this sales dashboard in Excel exactly as described: KPI cards (revenue, invoices, units, average invoice value), a monthly trend chart, sales by category, auto-updating top 5 products and customers, and month and category slicers that update everything at once. How I’ll build it: Your data goes into an Excel Table, so new rows are picked up automatically. The dashboard runs on PivotTables and slicers, with no macros, so it works on any recent Excel version and you only need to click Refresh All. You’ll get: One .xlsx with Data, Calculations and Dashboard sheets A short how-to sheet for adding data and refreshing 1 round of revisions plus 7 days of support Timeline: 3 days from receiving your data. Price: ₹1,500 To start, please send a sample of your sales data (Excel or CSV) and tell me your preferred currency format and colours. Could you also confirm the rough number of rows and which Excel version you use, so the slicers work on your setup? You can see a sample dashboard I built with demo data in my portfolio Thanks, Viswanath
₹1,050 INR in 1 day
0.0
0.0

As a full-stack developer, I can create for you the perfect Excel Sales Monitoring Dashboard that aligns precisely with your requirements. My skills span various domains including mobile apps, web development, e-commerce, automation, and even game development! Particularly relevant to this project is my extensive expertise in creating of dynamic and interactive dashboards, owning to my experience with data handling at scale. Your requirement of monthly trends, category segregation, top products & customers along with slicers to filter the analysis has been established by me umpteen times in the past. I propose not just fulfilling your present needs but going above and beyond to deliver a Best-in-Class Dashboard that would give you insights from your raw sales record at an entirely different level. Further during my 7 days of support after delivery I can help answer any questions and make minor tweaks ensuring that you get the most out of the solution in practice.
₹4,500 INR in 7 days
0.0
0.0

Hi, I can build this sales dashboard within your 5-day timeline. My plan: clean your raw sales records and set them up as an Excel Table so new rows are picked up automatically. A Calculations sheet will hold the key figures (total revenue, invoice count, units sold, average invoice value), and the Dashboard sheet will show the monthly trend, sales by category, and the top 5 products and customers, all driven by month and category slicers. You'll get one .xlsx with Data, Calculations and Dashboard sheets, a one-page refresh guide, and the 2 rounds of revisions included in your scope. VBA buttons and Power Query auto-merge can be quoted separately if you want them later. To start, please send a sample of the data (Excel or CSV) along with your branding and currency preferences. I work fully in writing here and will share a layout preview before the charts are finalised. Best regards, Hung
₹1,300 INR in 5 days
0.0
0.0

Hi, I can build exactly the workbook you describe: a Data sheet holding your records as an Excel Table (so new rows are picked up automatically), a Calculations sheet, and a Dashboard sheet with: - KPIs: total revenue, invoice count, units sold, average invoice value - monthly sales trend chart and sales-by-category chart - auto-updating Top 5 products and Top 5 customers - month and category filters that update every figure and chart together Before building, I'll clean your sample data: dates, duplicate invoices, and numbers stored as text. You'll also get a one-page "how to add data and refresh" guide. Please send a sample of your sales data (date, invoice no., customer, product, category, quantity, amount) plus your currency and colour preferences. First version in 2 days, final in 3, with 2 revision rounds included. Price: INR 1,200 - Delivery: 3 days
₹1,050 INR in 3 days
0.0
0.0

As a highly experienced data analyst and Excel expert, I am confident in my ability to deliver a top-notch Excel Sales Monitoring Dashboard for your business. With over eight years of experience in financial services, I have honed my skills in handling complex data sets and transforming them into clear and actionable insights. I hold a Bachelor of Commerce in Finance from Dalhousie University, which has equipped me with the necessary knowledge for precise financial analysis. Moreover, my past work includes successful projects similar to yours such as creating pricing models, reconciling data discrepancies, and building dashboards for various purposes. For instance, I efficiently resolved six-figure commission disputes by rigorously leveraging my data analysis and reconciliation skills. Furthermore, I have also developed an AI-powered reporting tool that replaced a manual quarterly process which led to significant time and cost savings for the company. In addition to my technical expertise, I take great pride in offering comprehensive and ongoing support to ensure maximum usability and longevity of deliverables. Should any questions or minor issues arise after project completion, I commit to providing seven days' worth of support at no additional charge. Ultimately, choosing me for this project means entrusting your sales data in the hands of someone who is both highly skilled and dedicated to delivering exceptional results.
₹1,200 INR in 5 days
0.0
0.0

Raigarh, India
Member since Oct 8, 2026
₹600-1500 INR
$750-1500 USD
$15-25 USD / hour
₹1500-12500 INR
$15-25 USD / hour
$10-30 USD
£10-20 GBP
₹12500-37500 INR
₹12500-37500 INR
$15-25 USD / hour
₹1500-12500 INR
₹1500-12500 INR
min ₹2500 INR / hour
₹1250-2500 INR / hour
$10-30 USD
$15-25 USD / hour
$10-30 CAD
₹750-1250 INR / hour
₹750-1250 INR / hour
£20-250 GBP
₹12500-37500 INR