已关闭

Excel analysis spreadsheet

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.

技能: 数据输入, 数据处理, Excel, 微软Office, Visual Basic

查看更多: data analysis excel 2016, spreadsheet analysis examples, excel data analysis tutorial, excel statistical analysis, data analysis using excel pdf, quick analysis tool excel mac, quick analysis tool excel 2010, sample excel data for analysis, excel stock spreadsheet, advanced excel mortgage spreadsheet, soccer excel blank spreadsheet league, excel warehouse stock control, port excel vba spreadsheet website, eplain excel budget spreadsheet stock symbols, sales analysis spreadsheet, escrow analysis spreadsheet, financial analysis spreadsheet, pricing custom excel vba inventory control program, rent excel scenario spreadsheet, excel turn spreadsheet macro

关于此雇主:
( 0个评论 ) Perth, Australia

项目ID: #17976943

84 威客就此工作平均出价 $383

jaylancer43

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 Ex 更多

$555 AUD 在3天内
(643条评论)
8.3
schoudhary1553

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 you 更多

$500 AUD 在3天内
(300条评论)
7.7
zekovicm

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 withi 更多

$370 AUD 在4天内
(107条评论)
7.0
paris2785

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. Th 更多

$450 AUD 在7天内
(171条评论)
6.9
TonmoyRoy111

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 更多

$300 AUD 在3天内
(279条评论)
6.5
dgled

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 更多

$600 AUD 在10天内
(63条评论)
6.7
suyashdhoot

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 comp 更多

$1000 AUD 在10天内
(56条评论)
6.5
MohsanEijaz

I am excel and vba expert, i have completed many excel analysis project, please review my profile. Mohsan

$361 AUD 在3天内
(70条评论)
6.0
polarjin2017

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 在3天内
(64条评论)
6.3
charleslimnet

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) under 更多

$300 AUD 在10天内
(70条评论)
5.8
nagybatonyi

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 deta 更多

$277 AUD 在4天内
(62条评论)
5.7
citijayamala

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 mar 更多

$250 AUD 在3天内
(56条评论)
5.4
supper5guy

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 m 更多

$250 AUD 在5天内
(73条评论)
5.4
dvcontact

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 exp 更多

$250 AUD 在10天内
(33条评论)
5.5
antoinepal

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 更多

$500 AUD 在10天内
(16条评论)
4.6
sarcscoin

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 ge 更多

$300 AUD 在3天内
(59条评论)
4.7
aubrey03

I am an Excel and VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] 更多

$500 AUD 在10天内
(55条评论)
5.1
luiswilliam

Hello, I read the description of your project thoroughly. I understand your requirements basically, and I have experiences of similar project. I am professional Website builder and Mobile App developer, and talented A 更多

$555 AUD 在3天内
(5条评论)
4.3
sagarwal3005

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 reportin 更多

$500 AUD 在5天内
(10条评论)
4.5
afenache

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 da 更多

$400 AUD 在5天内
(11条评论)
3.9