Oliver50
Thành viên mới
![](/diendan/data/PhoToDanhHieu/gold.gif)
- Tham gia
- 10/7/24
- Bài viết
- 0
- Được thích
- 0
- Giới tính
- Nam
- Nghề nghiệp
- IT Manager
Hello Everyone
,
I'm contacting this informed group because I'm in need of help with some complicated Excel formulae for a project that I'm working on that involves data analysis. Excel has been my go-to tool for simple jobs, but this project calls for more intricate calculations, so I'm a little stumped in this community .
Here is a quick synopsis of my project:
I'm doing sales data analysis for a retailer. Columns for the product ID, category of the product, sale amount, region, and date of sale are all included in the dataset.
I have the following analyzes to complete, however I'm unsure of which functions or formulas to use:
Monthly Sales Overview: I must compile the total amount of sales broken down by product category and month. I'm guessing I'll need to use SUMIFS & DATE functions in this combination, but am not sure exactly how to configure it properly.
Year-to-Date Sales Development: I am interested in finding out how much each product category's sales have increased so far this year in comparison to the same time previous year. Basic % change formulas are nothing new to me, however I'm having trouble applying it to a temporal date span.
Top Performing Regions: According to total sales, I must determine which five regions are the best. Although I've previously used the SORT and LARGE functions , I'm not sure how to combine them with my dataset to produce the intended outcomes.
Sales Forecasting: Using previous sales data, I wish to produce a straightforward linear forecast. Although I am aware about the FORECAST function , I would really appreciate some advice on how to apply it in this particular situation.
For your reference, I've attached another portion of my dataset. I would greatly appreciate any advice, example formulas, or sap resources that you could provide.
Thank you in advance.
I'm contacting this informed group because I'm in need of help with some complicated Excel formulae for a project that I'm working on that involves data analysis. Excel has been my go-to tool for simple jobs, but this project calls for more intricate calculations, so I'm a little stumped in this community .
Here is a quick synopsis of my project:
I'm doing sales data analysis for a retailer. Columns for the product ID, category of the product, sale amount, region, and date of sale are all included in the dataset.
I have the following analyzes to complete, however I'm unsure of which functions or formulas to use:
Monthly Sales Overview: I must compile the total amount of sales broken down by product category and month. I'm guessing I'll need to use SUMIFS & DATE functions in this combination, but am not sure exactly how to configure it properly.
Year-to-Date Sales Development: I am interested in finding out how much each product category's sales have increased so far this year in comparison to the same time previous year. Basic % change formulas are nothing new to me, however I'm having trouble applying it to a temporal date span.
Top Performing Regions: According to total sales, I must determine which five regions are the best. Although I've previously used the SORT and LARGE functions , I'm not sure how to combine them with my dataset to produce the intended outcomes.
Sales Forecasting: Using previous sales data, I wish to produce a straightforward linear forecast. Although I am aware about the FORECAST function , I would really appreciate some advice on how to apply it in this particular situation.
For your reference, I've attached another portion of my dataset. I would greatly appreciate any advice, example formulas, or sap resources that you could provide.
Thank you in advance.