Find Jobs
Hire Freelancers

Excel analysis spreadsheet

$250-750 AUD

Closed
Posted over 5 years ago

$250-750 AUD

Paid on delivery
I have sales info for approx 25 items. Every month I get a sales report (and corresponding inventory report). I have data for 12+ months. I need to be able to analyse the sales rates, with visuals after I put the sales rates in. In summary, I need a spreadsheet whereby *I can load the weekly/monthly sales & Stock on Hand that will in turn show me sales rate. *I also want to be able to have drop down boxes so I can select each sku/supplier to view. (I will have 6 or 7 names of suppliers with a few specific sku's per supplier) *I need a Purchases section (column) whereby I can input what I have purchased and yet to arrive and have the spreadsheet amend the sales rate until stock runs out (adjusted sales rate based on shipping time - months). *Reporting page with some pictures/graphs (not sure what I need to show). *If possible, and separate to the above, I want to be able to load in sales throughout the year to show an annualised sales graph - In other words, I'd like to see for each sku, where the sales are happening throughout the year (graph by month/quarter). Basically I need something I can easily upload sales data into that will spit out my sales rates over a given period, weigh up how much stock I have left at current sales rates and adjust for stock on order so I can be ahead of my inventory control.
Project ID: 17976943

About the project

78 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
78 freelancers are bidding on average $388 AUD for this job
User Avatar
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a sample file before you consider awarding me the project. Please initiate a chat so we can discuss on this. Thanks, Jay
$555 AUD in 3 days
5.0 (863 reviews)
9.1
9.1
User Avatar
This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel analysis spreadsheet. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic. Please ping me for more discussion.
$500 AUD in 3 days
4.9 (534 reviews)
8.4
8.4
User Avatar
Hello! My name's Paris and I was glad to see that you're looking for an Excel developer. You mention that you need somebody to develop useful charts and graphs that will help you make decisions over your inventory. The deliverable Exce spreadsheet will run on both MACs and PCs. I've delivered more than 250 projects in the last 5 years and this makes me very confident with your task. I can deliver the project within 5-7 days including all required revisions for $450. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon. Sincerely, Paris Pallas
$450 AUD in 7 days
5.0 (479 reviews)
8.3
8.3
User Avatar
Hi there,I am Miljan,Data Analysis expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$370 AUD in 4 days
4.9 (190 reviews)
7.9
7.9
User Avatar
Dear client I am very much interested in the project. I understand the scope of work. I can certainly help you in this project. I have strong hold in excel and I have previously carried out a number of projects in the past. I can setup a nice and easy dashboard for you with interactive graphs as per your requirements. So please contact me so that we have a discussion. Roy
$300 AUD in 3 days
4.9 (503 reviews)
7.4
7.4
User Avatar
Hello, I have carefully read your proposal regarding the analysis you need and I believe my expertise and skills are well-suited for your project’s requirements. I am an expert in Excel with comprehensive knowledge of advanced formulas, pivot tables, and Visual Basic Application. I can create customized spreadsheets by preparing dynamic dashboards, screen layouts (user-forms), drop-down boxes, generator reports, and charts. During my time serving as CFO, Controller, and Chief Accountant at different global parent companies, I gained knowledge and expertise in Financial Reports, accounting, consolidating, forecasting, and budgeting. I have experience with implementing information systems in organizations and businesses (accounting, payroll, treasury, budgeting and control, Intuit QuickBooks, SAP, ERP, etc.). Within a multi-currency environment and the global marketplace, I specialize in managing cash flow and liquidity solutions, including collections, payments, inventory, and taxation. During my career, I have gained valuable experience in diverse sectors, including VC’s, private investors, start-ups, retailers, power plants, farms, insurance companies, universities, construction businesses, medical equipment manufacturers, and traders, among others. My combined experience, knowledge, and creativity will lead to exceptional results that will exceed your expectations.
$600 AUD in 10 days
4.9 (95 reviews)
7.5
7.5
User Avatar
Hi, I have examined your project description about creating Excel sheet for inventory and sales analysis. You can be confident that this project will be professionally completed. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! Hope to hear from you soon
$250 AUD in 10 days
4.9 (71 reviews)
6.9
6.9
User Avatar
Hello, I can build a fully automated excel with the information and functionality you want using power query in excel as i have advanced excel skills and over 8 years in the field. Please check my portfolio to see my work. Thanks!
$500 AUD in 10 days
4.9 (71 reviews)
6.9
6.9
User Avatar
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. 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
$1,000 AUD in 10 days
4.7 (91 reviews)
6.9
6.9
User Avatar
Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.
$500 AUD in 3 days
4.9 (104 reviews)
6.8
6.8
User Avatar
I am excel and vba expert, i have completed many excel analysis project, please review my profile. Mohsan
$361 AUD in 3 days
5.0 (99 reviews)
6.7
6.7
User Avatar
Hello there, as an expert in excel and VBA, i can help you to accurately develop such a workbook where you can enter your yearly or monthly sales data and get the required output as you have specified. Please contact me and let us talk more about your project. Thanks
$250 AUD in 5 days
5.0 (90 reviews)
6.0
6.0
User Avatar
I possess exceptional data and statistical analysis experience. I use Excel, STATA, R-Programming and SPSS software’s in qualitative and quantitative research and report writing. I hold MBA (Strategic Management) undergraduate degree (Statistics) & CPA.K (Accounting and statistics.) As a data and research analyst, I have attained utmost discipline in delivering quality, accurate and reliable results. Happy to work with YOU
$300 AUD in 10 days
4.8 (87 reviews)
6.3
6.3
User Avatar
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$250 AUD in 3 days
4.7 (86 reviews)
6.2
6.2
User Avatar
Hi, I read the requirements provided in project description. You are looking for Excel Dashboard that represents the sales based on the reports extracted. I can create pivot table with graphs and vba macros to generate reports based on the need. Happy to discuss further details with the sample in the chat. -Sri
$300 AUD in 3 days
5.0 (75 reviews)
6.0
6.0
User Avatar
Hi, I can create an excel reporting tool to process the data for your sells and display the results in a dynamic dashboard on a custom template (graphs types, custom filters, color codes). An example of a dynamic dashboard that I made in excel you can find in my portfolio. This kind of tool is very easy to update with new data and is fully controlled by the filters from the left side of it. Best regards, Florin Enache
$400 AUD in 5 days
5.0 (23 reviews)
5.7
5.7
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I am a full-time freelancer, I can start working on the project immediately. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards
$277 AUD in 4 days
4.9 (64 reviews)
5.7
5.7
User Avatar
hello! I can do it for you. I can assure you of a quality and accurate output within budget. I know exactly what you need. I will make dashboard for you considering all your needed reports that will easily update when new data is added. Just share with me your data and details of what you want to see in the creation of the reports. thanks
$300 AUD in 5 days
4.9 (66 reviews)
5.5
5.5
User Avatar
Hi, I have developed many excel tools for sales analysis, operations management, team scheduling and inventory management before and I can develop the excel macro exactly for your need to make your daily sales reporting easy. I am a highly motivated professional expert in programming and design. I will go with you until the excel is completed and also you can count on me after that for upgrades or specific requirements. Ill be more than happy to assist you in this journey. I do have few questions to start with the project so please drop me a note and lets start working. Regards Sneha
$500 AUD in 5 days
5.0 (13 reviews)
5.4
5.4
User Avatar
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$600 AUD in 10 days
4.9 (25 reviews)
4.9
4.9

About the client

Flag of AUSTRALIA
Perth, Australia
0.0
0
Payment method verified
Member since Oct 17, 2018

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.