Using Excel Pivot Table To Analyze Sales Data - Quick Sales Orders Analytics - Pt 1

4 0

Published 2022-06-01

Are you looking for a quick way to analyze and get insights from your sales data? Here is a quick way to create two powerful reports to check your Revenue and Volume of sales leveraging Excel Pivot Table. Summarizing and getting insights has never been so easy!

If you find this video useful please hit the like button and subscribe to the channel. I publish videos regularly around excel and business.

Chapters:
00:00 Intro
00:25 Describing the Dataset
02:45 Defining the Scope of the Analysis
03:13 Weekly Sales by Item (Q.ty) - First Pivot Table
08:25 Analysing the Result on the Pivot Table
09:47 Customizing the Pivot with Pivot Table Option and Classic Pivot Table Layout
11:19 Week Sales Value by Item - Second Pivot Table
13:30 Formatting the Pivot - From Number to Currency

Thanks!

All Comments (1)