Find Jobs
Hire Freelancers

Create excel based tool

₹37500-75000 INR

Cancelled
Posted almost 8 years ago

₹37500-75000 INR

Paid on delivery
We have a system that tracks goals and actuals data for our sales team. However, the data gets is organised in rows format (change in a column variable, creates a new row) with unique ids for each row. We need an MS. Excel expert who can convert existing data sheets into user-friendly matrix formats which can enable data collection (from 100+teams) and aggregation of large volume of data. The consolidated file will need to be re-converted to the original data sheet format with original system id references. This will be a working file to import data from a system, convert it in a relevant format to enable data collection and consolidation, and reconvert the consolidated data for export to the system.
Project ID: 10893165

About the project

15 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

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
15 freelancers are bidding on average ₹50,061 INR for this job
User Avatar
I have read your project description and being one of the most famous Excel expert in this platform, I think I am perfect fit for your project. I am mostly online. Lets discuss more on chat.
₹52,631 INR in 10 days
5.0 (141 reviews)
7.1
7.1
User Avatar
I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a reservation system - Built a complex shift allowance calendar and calculator - Built a complex lookup to sort products into multiple categories You can see the reviews of the same in my profile
₹45,000 INR in 10 days
4.8 (81 reviews)
5.8
5.8
User Avatar
I have handled similar consolidation(data pulling, extraction), validation against range tables, summarising in Excel macros. Finally using the summaries output for further Pivot tables and grouped data. I have lots of experience in VB scripting, Excel macro, Automations. I should be able to deliver to your standards.
₹37,500 INR in 10 days
4.6 (49 reviews)
6.0
6.0
User Avatar
Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. I am interested to work for your project. Please give me a chance. I have handled many projects involving data manipulation handling, business solutions, Excel automated dashboards, Report Generation and Excel Applications. If you offer me your project, I can start immediately and deliver the job within 2 days after testing (QA) . I guarantee 100% accuracy for my deliverable. I do hope you'll give me the honorable chance to work with you and help me with making my mark on freelancer.com. I will take your project as the priority job and will complete your work in minimum time with 100% commitment. Thanks Fibin
₹37,500 INR in 5 days
4.9 (50 reviews)
5.4
5.4
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. In my portfolio look at the screen of "Create sales and purchases database application". You can have a little view about my coding experience.... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
₹62,500 INR in 20 days
4.7 (20 reviews)
5.3
5.3
User Avatar
My mainstream is VBA and VBscript coding and API automation with user-friendly graphic interface MS Office applications (Excel, Word, Access, Sharepoint, IE,...), creating of customized Windows API applications and complex client-server (SQL) applications, smart reports, smart solutions, routine work automation, process optimization and reverse engineering. VBA REFERENCES: BeGamer Beaverton, Oregon, USA - one of the biggest game portal worldwide 2011/12 - automate and enhance partner list with IE searching AT&T US Dallas, Texas, USA - one of the biggest phone and internet provider worldwide 2012/8 - EXCEL->PPT 2013/5 - Automated Gatekeeper 2015/3 - Quality Reporting Application 2015/8 - VBA-ACCESS-Sharepoint real-time reporting tool 2016/4 - Comparison tool Air Scientific Ltd. Dublin, Ireland - air emissions monitoring 2013/01 - EXCEL->WORD Habitat for Humanity International (Innovation Proposals) Atlanta, Georgia, USA - nonprofit, Christian organization that seeks to eliminate poverty housing and homelessness from the world 2013/04 - 3D positioning in dynamic chart The Technical University of Kosice, SK
₹38,000 INR in 20 days
5.0 (2 reviews)
3.3
3.3
User Avatar
Hello This is Srini from Bangalore India. I saw the attached excel file and it feels like its a very familiar territory cause of my Corporate finance experience. I work on such files day in and day out. I have created numerous such macros over the last 11+ years in Corporate Finance roles in the IT industry. I can assure you I am one of the best in this area of specialization. Several of the applications I created for my employers have got deployed across the globe and have been in production for almost a decade. This usually does'nt happen in multi national corporations (its top down - from head quarter to regions). I just built an excel based Sales Commission calculation tool (SaCACT for Sale Commission Attainment Calculation Tool) which is there in my Portfolio. This tool required to import data from multiple sources into multiple sheets, then a summary of all this data had to be created in a central sheet and then a dashboard had to be created for each row in the central sheet along with the details from the multiple sheet, and this dashboard had to be sent out in a mail to an email id in the corresponding row of the central sheet. Just try and I assure you of a great & delightful experience. Have a great day Srini
₹50,000 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked in jobs previously and am very new to freelancing. Have extensive knowledge of scripting, excel, macros, etc. and would be complete this task for you with great quality. Lets chat sometime to better understand the requirements and present my case for this project.
₹37,500 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Excel expert from Canada. I have done many similar projects. Quality over speed. Please feel free to contact me for further discussion. I can meet and exceed.
₹75,000 INR in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there Thank you very much for the opportunity to propose for this project. As an actuary I work with big data sets in MS Excel on a daily basis, and I am therefore very comfortable with the described task. I also work accurately as I perform validity checks while I work. As part of my deliverable I will provide all my workings, and if necessary a report detailing any instructions or recommendations. Please feel free to contact me should you have any questions. I look forward to hearing from you. Kind regards Shaun
₹50,000 INR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello We have checked the requirement and specifications. You can ask us any questions if you have. Sri Technocrat will provide fully interactive application for your project. The timeline and total cost for development is stated along with the bid. During development period, the application would be visible on one of our test servers. Sri Technocrat have professionals in the fields of graphic designer, site management and programming. Thanking you for considering Sri Technocrat as a partner in development. With Regards, Sri Technocrat
₹62,500 INR in 30 days
0.0 (0 reviews)
3.7
3.7

About the client

Flag of INDIA
Bangalore, India
5.0
2
Payment method verified
Member since Jun 29, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.