
Closed
Posted
I need a sharp Excel specialist who can jump straight into my raw data, clean it up, and turn it into useful information. Day-to-day work will begin with straightforward data entry, then move quickly into advanced territory: building pivot tables that slice the figures the way I need, writing or tweaking VBA macros to automate repetitive steps, and crafting complex formulas so the sheets stay dynamic even as the numbers change. Once the groundwork is solid, I’ll also ask for clear, standard charts that can be dropped into monthly reports without further editing. Nothing flashy—just accurate visual summaries that decision-makers can read at a glance. A bonus (and the reason “Tally Prime” sits in the title): most of these datasets originate from our Tally Prime accounting package. If you already know your way around exporting, reconciling, or re-importing data there, we’ll save time; if not, you simply need to be comfortable following my export templates and keeping field formats intact so I can pull everything back into Tally later. Deliverables • Cleaned and well-structured Excel workbook • Pivot tables linked to source data • VBA macros with clear inline comments • Formulas tested for accuracy across sample scenarios • A set of standard bar/line charts tied to the pivots I’ll review each milestone against sample numbers I provide and confirm the outputs match. Clear communication and documented steps are essential so I can maintain the files once the project wraps up.
Project ID: 40627739
15 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
15 freelancers are bidding on average ₹907 INR/hour for this job

Hello, I’d be happy to help with your Excel and Tally Prime project. I hold an MBA and have extensive experience in Excel, VBA, Power Query, Pivot Tables, advanced formulas, dashboards, and financial data analysis. I specialize in transforming raw data into accurate, automated reporting solutions that are easy to maintain. I can: * Clean, organize, and validate your raw data. * Build dynamic Pivot Tables and professional charts. * Develop well-documented VBA macros to automate repetitive tasks. * Create robust formulas that adapt as your data grows. * Ensure compatibility with Tally Prime exports by preserving field formats and data integrity. I focus on accuracy, clear documentation, and efficient automation, delivering workbooks that are reliable, scalable, and easy to update. I’m ready to start immediately and look forward to working with you. Best regards.
₹750 INR in 70 days
5.2
5.2

I have done a similar project a day 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.1
5.1

I am a Chartered Accountant with experience of more than 10 years in the field of accounting and taxation. I have successfully completed various similar projects which can be reviewed in my profile. I am interested in your said assignment and look forward to connect to you. Please feel free to contact over chat for detailed discussion.
₹1,000 INR in 40 days
4.1
4.1

Hi, I can help clean your raw Excel/Tally data and turn it into structured, useful reports with pivots, formulas, VBA automation, and clean charts for monthly reporting. The best solution is to first review your raw data format and Tally export structure, then clean and organize the workbook without disturbing important field formats. After that, I’ll build pivot tables, add tested formulas, create VBA macros for repetitive tasks, and prepare simple bar/line charts linked to the data. I’m comfortable with Excel data cleaning, advanced formulas, PivotTables, VBA macros, Tally Prime exports, reconciliation support, accounting data handling, data visualization, report preparation, and documented workbook workflows. Deliverables will include: * Cleaned Excel workbook * Structured source data * Pivot tables * Tested formulas * VBA macros with comments * Standard bar/line charts * Tally-format field handling * Sample scenario validation * Clear usage notes I’ll focus on accuracy, clean structure, and easy maintenance so your team can continue using the files confidently after delivery. Best regards Ankit
₹1,000 INR in 40 days
3.2
3.2

Hi As a chartered accountant I have 5+ Years of experience working with Data and tally. I am interested in your project. feel free to contact to discuss further. Thanks and Regards
₹900 INR in 40 days
2.2
2.2

I DON'T COMPETE ON PRICE. I COMPETE ON RESULTS. In a recent project, I transformed a disorganized dataset for a retail client into a structured Excel workbook, implementing pivot tables and VBA macros that automated their monthly reporting process. This led to a 30% reduction in time spent on data analysis and improved decision-making speed. With over five years of experience specializing in Excel and Tally Prime, I have successfully managed complex data projects, ensuring accuracy and efficiency. My background in data processing and reporting directly aligns with your needs. I understand your goal is to create clean, actionable insights from your data while ensuring seamless integration with Tally Prime. I will meticulously clean your datasets, build dynamic formulas, and develop clear charts that convey critical information, facilitating quick decision-making. With a focus on execution, transparent communication, and your long-term success, I am committed to delivering high-quality outcomes that meet your expectations. The difference between an average result and an exceptional one is usually decided before the work even begins. Regards, Isabella isabellasteyn02
₹750 INR in 14 days
0.8
0.8

Hello. I'm a specialist in VBA for Excel and I can create macros if needed. Hope to hear from you soon. Have a nice day.
₹750 INR in 28 days
0.0
0.0

We recently helped a business achieve a similar goal, and the results exceeded their expectations. I'd love to help you do the same. I'll build a solution that's reliable, professional, and designed to help your business grow. Your project stood out because you're focused on creating a clean, professional, user-friendly solution, and that's exactly the kind of work I enjoy. With 75+ 5-star reviews on similar projects, we rank in the top 1% among 75 million users! I specialize in transforming raw data into actionable insights, crafting pivot tables, and creating efficient VBA macros. My approach ensures that your Excel workbooks are not only clean and structured but also equipped with dynamic formulas and standard charts that meet your reporting needs. I'd be happy to share a few ideas for your project and answer any questions you have. Regards, VutomiM1
₹750 INR in 7 days
0.0
0.0

This project immediately caught my attention because it is exactly the type of work I do best. Your need for a sharp Excel specialist to clean raw data and create clean, professional, user-friendly solutions aligns perfectly with my expertise. I understand the importance of building pivot tables, writing VBA macros, and ensuring seamless integration with Tally Prime data. While I am new to freelancer, I have tons of experience and have done other projects off site, including advanced data management and automation. If this sounds like what you're looking for I'd love to hear more about your project. Regards, Warrick Van Eeden
₹750 INR in 7 days
0.0
0.0

Hi, I took the time to carefully review your project, and I genuinely believe I understand the vision you're working to bring to life. Every great project starts as an idea, and my goal is to transform that vision into something that not only meets your expectations but exceeds them. With extensive experience in Excel, I can clean and structure your raw data efficiently. I specialize in building pivot tables, writing VBA macros, and crafting dynamic formulas. Your requirement for accurate, standard charts aligns perfectly with my skill set. I value building genuine, long-term relationships with my clients, founded on trust, transparency, and consistent communication. My portfolio showcases similar projects where I transformed complex data into actionable insights. Even if we don't end up working together, I'd still be happy to offer honest advice or point you in the right direction. I would be happy to offer a free consultation.
₹750 INR in 7 days
0.0
0.0

Hello, I have 14+ years of experience working with Advanced Excel, Tally Prime, and financial data management. I regularly clean and organize large datasets, build dynamic Pivot Tables, create advanced formulas (XLOOKUP, INDEX-MATCH, SUMIFS, IF, etc.), prepare MIS reports, and reconcile Tally Prime exports while preserving data integrity. I can also modify or develop VBA macros with clear comments and create professional charts linked to pivot tables for automated monthly reporting. I focus on accuracy, well-documented workflows, and timely delivery so your workbooks remain easy to maintain after project completion. My Questions: Approximately how many rows of data does each workbook contain, and how many Excel files will be processed each month? Do you already have existing VBA macros and report templates that need enhancement, or should I develop the automation and reporting solution from scratch?
₹750 INR in 40 days
0.0
0.0

I have extensive experience in accounting using Tally Prime/ERP 9 and have been officially recognized and awarded by Tally Solutions for my expertise. I am proficient in utilizing all advanced accounting features within the software. Additionally, I can efficiently export and provide well-structured data in Excel format directly from Tally I run an established accounting firm in Bokaro Steel City, Jharkhand, and I am a registered GST Practitioner (searchable under my name: Mukesh Kumar Thakur). We provide comprehensive financial services, including Accounting, GST compliance, ESIC, PF, TDS, and Income Tax filing. Additionally, I specialize in tax litigation and handling statutory disputes; if you have received any GST Notice, I can draft and file a legally sound reply for you
₹1,000 INR in 40 days
0.0
0.0

Jaunpur, India
Member since Jan 5, 2024
₹400-750 INR / hour
₹12500-37500 INR
$250-750 USD
£10-20 GBP
£5-10 GBP / hour
$5000-10000 USD
₹400-750 INR / hour
₹750-1250 INR / hour
₹12500-37500 INR
₹1500-12500 INR
$8-15 USD / hour
$30-250 USD
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR / hour
$30-250 USD
min $50 USD / hour
₹1500-12500 INR
$250-750 USD
₹750-1250 INR / hour