Sales Data Analysis using Excel | Pivot Tables | FMCG Industry
In this video, you will understand how to analyse FMCG Sales data using Excel.
Pivot is a very useful concept used in Excel. This video will show the power of Pivot. You can literally answer any question, or analyse any dataset using Pivots
00:30 Dummy Data Overview
01:17 Objective of this video
01:26 Which Zone has the Highest Sales in India
03:04 Which City contributes Maximum for each Division
04:54 Highest Sales achieved on which 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