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

## Tuesday, April 13, 2010

### Time Warp Wednesday - Excel Menus: Podcast 101

Over the past several months, many emails and messages have come to us asking about earlier MrExcel Podcasts. In an attempt to make even the earliest episodes available, we are introducing... "Time Warp Wednesday".

Welcome to 'Time Warp Wednesday'! Today, the first MrExcel Podcast [created October, 2005]. Episode 101 deals with Excel Menus and how to work the Excel user interface so that all menu items are readily visible to the user. Enjoy and Thank You for Viewing!

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

### Pivot Date Grouping - Episode 1201

Deb from Wisconsin noticed that her date grouping was wiped out after refreshing a pivot table. Episode 1201 takes a look at how to find the bad dates and solve the problem.

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

### April Fools ? - Episode 1200! MrExcel's 1100th Podcast!

Well, it was supposed to be for April Fools day, but after a slight mix up here Episode 1200 - MrExcel's 1100th Podcast - almost became 'The Lost Episode'.

Here is a great trick with the Speak Cells tools. Episode 1200 shows you how.

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

### AVERAGEPRODUCT? - Episode 1199

Susan asks..."I have been using SUMPRODUCT a lot ever since you showed me how – since I can’t use SUMIFS for users with pre-2007 version. But, is there an AVERAGEPRODUCT or something similar? I know about AVERAGEIFS but, again, it can’t be used by pre-2007 version users. How about MAXPRODUCT?" Episode 1199 shows you how.

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