From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Using date and time as metrics in a PivotTable

Using date and time as metrics in a PivotTable - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Using date and time as metrics in a PivotTable

“

- [Instructor] When you're trying to analyze data, PivotTable is a great tool, and pivot tables can handle date and time analysis as well. On this worksheet, we've got some data over in columns A through F, little over 400 rows, and two different pivot tables and also pivot charts. The pivot table in columns H through O is analyzing the data, summarizing the data by quarter within years. And the accompanying chart below at the pivot chart emphasizes by way of a stacked column chart, the variations in the different quarters over this three-year period. The pivot table to the right, as you can see, is based on hours of the day, during which hours do we have the most sales. And that neatly brings out that idea here too, a stacked column chart, so over a three-year period or busiest hour phase. And over this three-year period of 2023 to 2025, it looks as if the 2:00 PM timeframe is the busiest in terms of actual sales. And…

Contents