
Closed
Posted
The task is to build a dynamic, easy-to-refresh Excel workbook that turns raw sales data into clear insights. I need three distinct perspectives captured: • Monthly sales totals that can be filtered by year • Product-wise performance, highlighting best-sellers and slow movers • Region-wise breakdown so I can compare territories at a glance Please structure the file so new data can be pasted in and all pivots, charts, and formulas update automatically. Native Excel features such as PivotTables, slicers, Power Query, and conditional formatting are welcome as long as the final file remains fully editable (no macros are strictly required, but you may use them if they simplify refresh). Acceptance criteria: 1. One consolidated workbook delivered in .xlsx format. 2. Separate, clearly labeled tabs for each of the three report views plus a clean data input tab. 3. All calculations must reconcile with a small sample data set I will provide for testing. 4. No external links or hidden connections. If you can share a short sample layout or screenshot early on, that will help confirm the direction. Once approved, you can complete the full build.
Project ID: 40549459
19 proposals
Remote project
Active 4 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
19 freelancers are bidding on average ₹934 INR/hour for this job

Creating a dynamic Excel workbook with PivotTables and slicers can help turn raw sales data into clear insights. We built a Python Deterministic Scoring Engine for a client, ensuring absolute accuracy and auditability for critical data-driven decisions, https://www.freelancer.com/portfolio-items/11337466-python-deterministic-scoring-engine. I'll help you structure the file so new data can be pasted in and all pivots, charts, and formulas update automatically. I can put together a quick Consolidated workbook for free so you can see the approach first. ~ Rajesh
₹1,000 INR in 40 days
6.0
6.0

Hello, I trust you're doing well. I am well experienced in machine learning algorithms, with nearly a decade of hands-on practice. My expertise lies in developing various artificial intelligence algorithms, including the one you require, using Matlab, Python, and similar tools. I hold a doctorate from Tohoku University and have a number of publications in the same subject. My portfolio, which showcases my past work, is available for your review. Your project piqued my interest, and I would be delighted to be part of it. Let's connect to discuss in detail. Warm regards. please check my portfolio link: https://www.freelancer.com/u/sajjadtaghvaeifr
₹1,500 INR in 40 days
5.2
5.2

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
₹1,000 INR in 40 days
5.0
5.0

Hi, Your requirement is clear and well defined, and I can help you build an Excel workbook that is simple to maintain while providing meaningful sales insights. I have extensive experience developing project tracking sheets, cost models, management reports, dashboards, and data analysis templates for engineering and consulting projects. My focus is always on creating workbooks that are easy to update, well structured, and reliable. My approach would be to first understand your raw data structure and reporting requirements, then design a clean input sheet that feeds dynamic PivotTables, charts, and slicers. I'll build the three required report views—monthly sales trends, product-wise performance, and region-wise analysis—with formulas and validations that automatically update when new data is added. Before I complete the workbook, I'll share a sample layout for your review to ensure we're aligned with your expectations. The final workbook will be fully editable, organized, and easy for your team to use without requiring complex steps. I'd be glad to discuss your dataset and get started.
₹1,000 INR in 40 days
2.4
2.4

As a team of Chartered Accountants, we have been honing our proficiency in Excel for over 8 years. We understand the significance of accurate and organized data and possess the skills necessary to deliver on your project requirements. Being well-versed with native Excel features such as PivotTables, slicers, Power Query, and conditional formatting, we can ensure that your workbook is not only dynamic but also manageable. Our forte lies in simplifying complex data structures and transforming them into actionable insights. We are capable of constructing an Excel workbook that will enable you to have a comprehensive overview of your sales performance from three different perspectives- monthly sales totals by year, product-wise performance, and region-wise breakdown. And our thorough testing process ensures that all calculations reconcile perfectly with your provided sample data set. Additionally, our experience with large corporates around the world(including nations like Dubai, Singapore, Korea, Malayia and Canada), means we are familiar with diverse compliance requirements -- a skill that assures no external links or hidden connections in your workbook. So why not let professionals who breathe Excel day in and day out handle your project? It’s time to put your financial desk at ease; let’s get started!
₹800 INR in 40 days
1.8
1.8

As an experienced Financial Analyst and Business Consultant, specializing in financial modeling and data analysis, I understand the vital role in creating easy-to-use yet sophisticated Excel workbooks that deliver actionable insights. Your project aligns perfectly with my skill set and experience as I have developed numerous dynamic, error-free workbook systems that handle big datasets and enable efficient data refresh. Utilizing Excel's powerful native features such as PivotTables, slicers, Power Query, and conditional formatting comes second nature to me and I can ensure that the final file is fully editable while maintaining its functionality. My proficiency across various sectors, including real estate, banking, energy, and telecommunications, demonstrates my ability to adapt to different business needs effectively. This experience coupled with my intuitive approach towards financial analysis and strategic decision-making makes me an ideal fit for this project. I've delivered projects where calculations had to reconcile flawlessly with provided sample data—with no external links—and I'm confident in providing the same level of detail-oriented work for your project. Most importantly, however, is my dedication to quality deliverables that meet your specific needs. My commitment is to provide more than a mundane tool; rather an all-encompassing solution that truly serves your requirements.
₹1,000 INR in 40 days
1.7
1.7

Hello, I can create a clean, fully editable Excel workbook that automatically updates as new sales data is added. The workbook will include separate dashboards for monthly sales, product performance, and regional analysis using PivotTables, charts, slicers, and conditional formatting. I'll ensure all calculations are accurate, easy to refresh, and delivered in a well-organized .xlsx file. I can also share a sample layout early for your review. Looking forward to working with you. Thank you!
₹1,000 INR in 40 days
0.0
0.0

As an AI & Cloud Data Engineering Specialist, I find that Excel and Visual Basic skills are indispensable in my line of work, making me the right fit for your project. Having worked to improve operational efficiency and reduce costs in various domains, I understand that the key to achieving this is turning raw data into actionable insights - exactly what you need in this project. My extensive experience across multiple industries including finance, healthcare and insurance aids me in creating efficient systems like the one you need.
₹800 INR in 40 days
0.0
0.0

I have a feeling most proposals you're receiving look exactly the same. This isn't one of them. I understand you need a detailed Excel workbook for sales reports, emphasizing clean, professional, user-friendly, and automated features with no macros. While I'm new to Freelancer, I've spent years delivering quality work on time. I specialize in creating dynamic Excel workbooks with PivotTables, slicers, and Power Query for seamless data analysis. If you're looking for someone who thinks beyond the brief, I'd welcome the opportunity to chat. Regards, Warrick Van Eeden
₹750 INR in 7 days
0.0
0.0

Hi, I'd like to take this on. I'll build a single consolidated workbook with a clean data input tab and three clearly labeled report tabs covering monthly sales (filterable by year), product-wise performance highlighting best- and slow-sellers, and a region-wise comparison view. I'll use PivotTables, slicers, and Power Query so everything refreshes automatically when new data is pasted in, with conditional formatting to make best/slow performers easy to spot at a glance. The file will stay fully editable with no macros, external links, or hidden connections, and I'll validate all calculations against your sample dataset before final delivery. I can share an initial sample layout within 2 days for your review and approval, then complete the full build once you confirm the direction. Looking forward to working on this. Best, Isha Gupta
₹800 INR in 40 days
0.0
0.0

I can build a fully dynamic and easy-to-maintain Excel sales dashboard that automatically updates when new sales data is pasted into the data sheet. What you'll receive: ✅ Clean Data Input sheet for pasting new sales data ✅ Monthly Sales Dashboard Monthly sales totals Year filter using slicers Interactive Pivot Charts ✅ Product Performance Dashboard Best-selling and slow-moving products Sales ranking Conditional formatting Interactive filters ✅ Region-wise Dashboard Territory comparison Regional sales charts Drill-down capability Features Included Dynamic Excel Tables PivotTables & Pivot Charts Slicers & Timelines Power Query (optional for easy refresh) Automatic updates after data refresh Fully editable .xlsx workbook No external links No hidden connections No unnecessary macros I will also share a sample dashboard layout before completing the full workbook so you can confirm the design and reporting structure.
₹750 INR in 40 days
0.0
0.0

Hello, I will build a dynamic Excel dashboard that turns your raw sales data into clear, actionable insights. I have strong experience in Excel, PivotTables, Power Query, and data visualization. I am detail-oriented and can create a fully editable workbook with automatic updates when new data is pasted. What I will do: - Build a clean data input tab for raw sales data - Create Monthly sales totals (filterable by year) - Create Product-wise performance (best-sellers + slow movers) - Create Region-wise breakdown for territory comparison - Use PivotTables, Slicers, and Charts for interactivity - Ensure all formulas and calculations reconcile - No external links or hidden connections My approach: - Use native Excel features (no external dependencies) - Ensure automatic updates when new data is added - Keep the file clean, organized, and user-friendly - Document each tab clearly Why choose me: - 50+ Excel and data analysis projects completed - Strong PivotTables, Power Query, and formulas skills - Detail-oriented and reliable - Fast and efficient I can share a sample layout early to confirm direction before completing the full build. Availability: I can start immediately and deliver within 3–5 days. I am ready to start. Please share the sample data and any specific requirements. Warm regards, Rosan Karki
₹900 INR in 40 days
0.1
0.1

Hi, I can create a dynamic and fully editable Excel workbook with automated reports, PivotTables, charts, slicers, and well-structured formulas that update easily when new data is added. I will ensure accurate calculations, clear report tabs, and a clean data input sheet while keeping the workbook organized and user-friendly. I’m ready to start immediately and provide a sample layout for your review. Best Regards, Ishrat Fatima
₹750 INR in 40 days
0.0
0.0

Hello, I would be happy to build a professional, dynamic Excel dashboard that transforms your raw sales data into meaningful, easy-to-understand reports. I have experience working with Excel, data processing, reporting, and large datasets, and I can create a workbook that is both user-friendly and easy to maintain. The workbook will include: * A clean data input sheet where new sales data can simply be pasted. * Monthly sales summaries with year filters using PivotTables and slicers. * Product-wise performance reports highlighting top-selling and slow-moving products. * Region-wise sales analysis with clear charts and conditional formatting for quick insights. * Automatic refresh of PivotTables, charts, and formulas whenever new data is added. * A fully editable `.xlsx` workbook with no external links or hidden connections. I will ensure that all calculations reconcile accurately with your sample dataset before delivery. I'll also share an initial layout/mockup early in the project so you can review the design and request any changes before I complete the final dashboard. I am detail-oriented, committed to accuracy, and communicate regularly throughout the project. My goal is to deliver a clean, professional workbook that saves you time and makes your sales reporting effortless. I look forward to working with you. Thank you.
₹750 INR in 40 days
0.0
0.0

With my strong background in data entry and proficiency in Excel, I am confident that I can deliver the dynamic and insightful sales reports you need. Your project aligns directly with my skillsets honed over years, ensuring your datasets will be tactfully transformed and represented through native Excel features such as PivotTables, slicers, Power Query, and conditional formatting. I assure you that all the calculations will reconcile perfectly with your provided sample dataset. One feature that sets me apart from other freelancers is my capacity to create reports that are not just functional but also visually appealing. I understand the importance of clean layouts for easy comprehension, and I will create separate tabs for each report view -- with a clearly labeled data input tab -- resulting in a consolidated workbook where all pivots, charts, and formulas update automatically. Additionally, what distinguishes me is my deep commitment to keeping things editable. With no external links or hidden connections, you can be sure that even though the design will be sophisticated and informative, it will still be nimble enough to accommodate new sales data pasted in later. Let's team up to turn your raw sales data into meaningful insights.
₹800 INR in 40 days
0.0
0.0

Bengaluru, India
Payment method verified
Member since Jun 21, 2026
₹600-1500 INR
$15-25 USD / hour
₹750-1250 INR / hour
₹600-1500 INR
₹600-1500 INR
₹400-750 INR / hour
$10-30 USD
₹750-1250 INR / hour
£250-750 GBP
₹12500-37500 INR
$500 AUD
₹750-1250 INR / hour
£10-20 GBP
₹750-1250 INR / hour
₹750-1250 INR / hour
$15-25 USD / hour
£1500-3000 GBP
$250-750 USD
$10-30 USD
$250-750 USD