Find Jobs
Hire Freelancers

Need an Excel expert to automate sales reports

$30-250 USD

Closed
Posted about 5 years ago

$30-250 USD

Paid on delivery
Each week we receive sales reports from out 70 locations. We spend hours pulling out data and organizing it into spread sheets that compare sales to the previous years. I am hopping to find an expert that can create a master sheet or sheets and pull the data from the reports we receive each week.
Project ID: 18644824

About the project

33 proposals
Remote project
Active 5 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
33 freelancers are bidding on average $176 USD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD in 3 days
4.9 (338 reviews)
7.9
7.9
User Avatar
Dear Employer, I understand your job and I will write an application that will compare the data as per your requirement and give you solution. Please message me, I am an expert. Do try me once and check my review once!! :) Thanks and Regards, Ash
$166 USD in 3 days
5.0 (167 reviews)
7.4
7.4
User Avatar
Dear client I am an excel expert and I have previously carried out a number of projects in excel using macros and formulas. I can surely help you in automating the report generation from your 70 locations. Kindly contact me. Lets have a discussion. Roy
$200 USD in 3 days
4.9 (323 reviews)
6.8
6.8
User Avatar
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on developing such Excel based solution every single day. Please share sample files for few locations - I would come up with an automation solution for consolidating all data into one master report. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Weekend! Srinivasan Krishnamoorthi
$120 USD in 4 days
5.0 (185 reviews)
6.8
6.8
User Avatar
I can create for you a KPI Analysis Module in Excel to calculate the staff performance and its commission based on chosen parameters. The performance reports show results per period, person, working group and company levels. during the process, Excel validates the information, prepares a creates a structured database and pivot tables which enables to develop templates reports independently. the module is secured by usernames and passwords. About me: I am a financial expert and a guru in Excel/VBA/Macro. I come up with creative and sophisticated financial & statistical modules in a simplified and logical manner. I develop financial modules and financial projections including business valuation & terminal valuation methodology & ratios (INPV, IRR, DSCR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.) Furthermore, I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in Financial Reports, accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.
$250 USD in 3 days
4.9 (79 reviews)
7.0
7.0
User Avatar
Hi I am a very experienced statistician, data scientist and business analyst. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$500 USD in 3 days
4.8 (75 reviews)
6.7
6.7
User Avatar
Hi, I am experienced on Microsoft Access , Excel and VBA, Powerpoint. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
$100 USD in 3 days
4.9 (156 reviews)
6.4
6.4
User Avatar
hello sir, i am pure accounting and finance profeasional .. very well versed in doing this project. please consider my bid .. highest quality is assured
$111 USD in 111 days
4.9 (105 reviews)
6.4
6.4
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Sure, I will derive a automated tool for your team that will ease the job. Willing to take up your project. Thank you, Regards.
$200 USD in 4 days
5.0 (103 reviews)
6.2
6.2
User Avatar
Hello, I am Excel and VBA expert. I understand the requirements. I can do it in VBA (Excel VBA macros). Macro can create master sheet and pull data from sales reports automatically. Could your provide sample input and output files? If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Ja
$100 USD in 5 days
5.0 (96 reviews)
6.0
6.0
User Avatar
I am proficient with Microsoft Excel and marco/VBA development. I read your project descriptions carefully, I can write the marco to merge data into a report as requested. You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, Would be great if you can provide a sample of your workbook for some more context. Kindly get back to me if you wish to proceed, I am available to start your project immediately, looking forward to chat further and work on your project.
$150 USD in 3 days
5.0 (83 reviews)
5.8
5.8
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$250 USD in 3 days
5.0 (32 reviews)
5.6
5.6
User Avatar
Hi, As per requirements I will develop Master sheet for you containing VBA macros which will move the data and will do all required calculations on the data as per description of the project. Please share your Excel sheets. I have expertise in Excel, formulas, Excel VBA and finished many such projects. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I am ready to work on this project now. Please give me this opportunity to work on your project. Thanks and regards, Mohan
$250 USD in 3 days
5.0 (78 reviews)
5.8
5.8
User Avatar
I have excellent command on MS Excel and can automate the sales report by extracting data from the reports of all the locations. I have completed complex projects in Excel before . For instance - Built a POS and inventory management system - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$150 USD in 3 days
4.8 (92 reviews)
6.0
6.0
User Avatar
Hi, I can build an excel VBA script to loop through your files, pull data and consolidate it in a master sheet. Best regards, Florin Enache
$150 USD in 3 days
5.0 (19 reviews)
5.2
5.2
User Avatar
Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
$100 USD in 3 days
4.8 (74 reviews)
5.5
5.5
User Avatar
Hi, dear. I'm very interested in your project very well. I've got an experience of VBA development for MS Excel as MACRO. Please ping me to discuss about this project.
$155 USD in 3 days
5.0 (9 reviews)
5.1
5.1
User Avatar
I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance data analytics tools to perform various automation, data consolidation, computation and analysis. I will be happy to discuss in detail how I am highly suitable for this project.
$50 USD in 1 day
4.7 (49 reviews)
5.4
5.4
User Avatar
Hi there, Greetings! I am an experienced Excel/Access developer. I have been developing custom database solutions for the past 10 years. I have excellent depth over MS Access, VBA, ADO, SQL, MySQL, Excel, and other Office applications. Please see a few of my work in the attached pdf. I understood your basic requirement, let's discuss this on the detail level. Thanks, Rayyan
$155 USD in 3 days
5.0 (16 reviews)
4.8
4.8
User Avatar
Hello I can help with your spreadsheet collation issue. My name is Steve, I have worked with excel/vba for over 10 years for a global financial services company. In that time I became the local lead for all excel/vba based issues which lead me to design and implement many complex spreadsheets and macros. This helped to gain efficiencies in our daily tasks and increase our profitability and I’m sure this experience will be of use to you with your project. I hope to hear back from you soon to discuss the project in more detail. Kind regards Steve
$222 USD in 5 days
5.0 (8 reviews)
3.9
3.9

About the client

Flag of UNITED STATES
Pompano Beach, United States
0.0
0
Member since Feb 2, 2019

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.