Use Excel to find the best-selling product in 9 clicks

Описание: Put your keyboard away. No keystroke is required...

With the power of pivot table, you can group and sort a data table in summary for best-selling, most profitable, and least popular if you want to. In fact, it is so simple that you DO NOT EVEN punch in any key!

Chapters
0:02 1. Select cell (the first click)
0:03 2. Insert
0:04 3. Pivot Table
0:06 4. Select product
0:09 5. OK
0:12 6. Drag product to Row labels
0:14 7. Drag product to Values
0:18 8. Sort
0:19 9. Sort Largest to Smallest

If you like this video, please consider like, comment, and subscribe to my channel. If you have any video that you want me to make, please comment below. Thank you for watching. I hope you enjoy it.

#learn
#excel
#tricks
#pivottable
#howto
#tips
#worksmart
#exercise