Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Thursday, April 26, 2007

Episode 495 - Grouping by Hour

In yesterday’s podcast, I proposed a formula to solve Jonathan’s dilemma of analyzing information by hourly buckets. An easier solution is to use the Group by Hour feature in a pivot table. Episode 495 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!