Using Excel Pivot Chart To Analyze Sales Data - Quick Sales Orders Analytics - Pt 2

0 0

Published 2022-06-20

Are you wondering how you can visualize your sales data? Here is a quick way to use the Excel Pivot Chart functionality and bring your data to life!
Summary, weekly and monthly reports, and segmentation is now easy and visualized with columns, lines, and graph!

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:32 Describing the Dataset
01:34 Defining the Scope of the Analysis
02:01 Difference Between Pivot Table and Pivot Chart
02:34 Weekly Sales By Item - Task 1
09:25 Top Selling Item by Week - Task 2
12:14 Top 3 Customers For Each Sales Channel - Task 3
15:04 Revenue Split for Each Channel - Task 4
16:11 Conclusions

Thanks!

All Comments (1)