How to use a Pivot Table to Analyze SALES DATA in Excel
In this video, we will learn about How to use a Pivot Table to Analyze 3 years of SALES DATA in Excel.
👉 Join now our QnA Community - bit.ly/335Fic7
00:00 Introduction to How to use Pivot Table to Analyse Sales Data
00:57 How to use Pivot Table from Scratch
03:20 How to Group in Excel Pivot Table
03:44 How to Create Chart in Excel Pivot Table
06:22 How to does Percentage Calculation
07:30 How to use Filter in Pivot table
08:54 How to Get Back Pivot Table Fields
09:27 How to SORT Data in Pivot Table
10:30 How to Add Column in Pivot Table
10:50 How to Change in Data in Pivot Table
👉 Check out Excel tutorial Playlist - • Excel Tips & Tricks
How to use a Pivot Table to Analyze SALES DATA in Excel
#PivotTable #ExcelTutorial #SalesData
Let's Connect:
👉 Follow us on Instagram / yodalearning
👉 Follow our boards at / pins
Пікірлер: 38
👉 *_Join now our QnA Community_* - bit.ly/335Fic7
LOVE this vid! Your animation is a crack up!
Great content! Loved it!
@Yodalearning
2 жыл бұрын
Glad you enjoyed it!
AMAZING VIDEO !
@Yodalearning
3 жыл бұрын
Thanks, Kyunglyung Sonya Park. Keep learning...👍
Good explanation :)
cant believe i have a test on excel thank u very much'
Great video!
@Yodalearning
2 жыл бұрын
Thanks!
this was good i liked it and super helpful.
@Yodalearning
3 жыл бұрын
Thanks, Radigundo Custorio. Keep learning...👍
This was very helpful thank you
@Yodalearning
2 жыл бұрын
Glad it was helpful!
Superb 👍
Hello thanks for posting the video, really liked it. I have another problem, I work on costing and our factories give us the costing. Often they change the content of costing sheet and it becomes difficult to track the changes . One way is to put both the costing sheet in one sheet and compare manually with some formula but it is very cumbersome. Can you suggest some smart and less cumbersome way to do it
Thank you so much
@Yodalearning
2 жыл бұрын
You're most welcome
great content i like it
@Yodalearning
2 жыл бұрын
Glad to hear it
Do you do any consulting work? I need help in setting up a complicated pivot table.
Super trick sir
@Yodalearning
4 жыл бұрын
Thanks, Sanjay. Keep Learning...
I have created a pivot table through vba and now I need to create a chart for each subsection of the pivot table. Can we achieve this ?
Hi please share this dataset for practice.
Hi if possible please help to separate year on year part code wise unit price.
can you please upload theis templete for practice ?
Sir I want link of your first video where you create 3 year sales into 1
Please provide excel file link also in description for better understanding 🤗🤗🤗
@Yodalearning
4 жыл бұрын
Click here - yodalearning.com/download-excel-sales-marketing-practice-files/
Please share me the file link of this excel sheet for practice
please the link for the previous video
@adalgizabonifacio
2 жыл бұрын
Yes that would have been great. Please let me know if you found it
@kikyaaakun
2 жыл бұрын
Indeed, can’t find it anywhere
Unable to get the data set
Plss give me your source of dataset☺️
Where is the previous video……
unable to get excel file even in email