Analysis of Sales Data Using Excel Pivot Tables FMCG Industry
Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
In this video, you will understand how to analyze FMCG sales data using Excel.
Pivot is a very useful concept used in Excel. This video shows the power of Pivot. You can literally answer any question or analyze any data set using Pivots
Pivot is a very useful concept used in Excel. This video shows the power of Pivot. You can literally answer any question or analyze any data set using Pivots
00:30 Overview of dummy data
01:17 Purpose of this video
01:26 Which zone has the highest turnover in India
03:04 Which city contributes maximum for each division
04:54 Highest turnover achieved on what date?
05:50 Which price range contributes maximum to the top line
06:48 Top 5 distributors in terms of sales
### Bonus Tip #### 07:57
#Exceltutorial #FMCGSales #SalesAnalysis #CPG #FMCG #FMCGAnalytics #ExcelSales
Please take the opportunity to connect and share this video with your friends and family if you find it helpful.