Analysis of Sales Data Using Excel Pivot Tables FMCG Industry

Analysis of Sales Data Using Excel Pivot Tables FMCG Industry

HomeAnalytical GuyAnalysis of Sales Data Using Excel Pivot Tables FMCG Industry
Analysis of Sales Data Using Excel Pivot Tables FMCG Industry
ChannelPublish DateThumbnail & View CountDownload Video
Channel AvatarPublish Date not found Thumbnail
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

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.