From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 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

Using date and time as metrics in a PivotTable

- [Instructor] One of a pivot table's greatest strengths 2 is its ability to analyze information by date and time. 3 In this worksheet here, we're showing sales data, 4 transaction data over a two year period, 5 and it's identified by the date 6 in which it occurred and the time of day. 7 And we might want to analyze the information 8 based on either or both of those criteria there. 9 Let's create a pivot table on this worksheet. 10 We can go to the Insert tab on the ribbon, 11 select Pivot Table, choose Existing Worksheet. 12 Click on the Location panel below it, 13 and I'll simply click on sell H1 14 in the background, click OK. 15 The Pivot Table Fields list, 16 I'm going to shrink a bit, and by the way, 17 you can make this be docked by simply double clicking. 18 If it's already docked 19 and you'd like to move it out from the docking position, 20 simply grab its title bar and move it out. 21 I usually prefer to have it…

Contents