Compare Monthly Data by Days

This video show how to quickly compare sales or quantity type of data by days or day of the week between two years. All that is needed is to put the data into a Pivot Table and then use Slicers to choose the day or day of week. It fairly straight forward to create this so check the video out.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[WoodBlock]

This is exactly what I needed for a project im working on!!!

[Meolimo]

thks Doug you put me on a path to solved some other problems ... ;-)

[onageon]

Nice and very quick tool to analysis.... Thanks Alot.... Also can we highlight the cell which are de-growing?

[Tesnobay]

Hi, when you do the chart from the pivot table, you do not show that you are only displaying 1 day of the week. How do you make that show up in the chart?

[sekarsucianahd]

hii, can you explain about create pivot table in row date? and how change to month? thank you

[CarlosEspinoza-meoi]

Great!! I need sth different only evaluating one month (current) over one month (last year) by day of the week. Ex. Thu 01 Jul 2021 vs Thu 02 Jul 2020 and so on...