Counting Mondays - Episode 1185

Mike and Bill get together for another live dueling podcast, counting the number of Mondays between two dates. Episode 1185 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!

Pivot SmartArt - 1184

Create a pivot table that drives a SmartArt diagram. Episode 1184 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!

Q1, Q2, H1 - Episode 1183

Is the fill handle smart enough to fill in quarters and halves? Maybe. Maybe not.
Episode 1183 shows you why.
Also, in this episode, a challenge to users - view the podcast for details!

...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!

Plus / Minus - 1182 Dueling Excel

Today's 'Dueling Excel' podcast - Episode 1182, with Bill Jelen and Mike Gel Girvin - shows you how to visually present statistical values (+/-) in a cell.

...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!

Links Failing - 1174

A workbook that was working perfectly in Excel 2003 starts failing in Excel 2007. For no apparent reason, the links will no longer update. Episode 1174 Episode 1174 show why and how to fix this problem forever.

...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!

Turn Data - 1173

Paula asks how to take a range and turn it on its side.
Episode 1173 Episode 1173 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!

Picture Lookup - 1172 - Dueling Excel

Today's dueling Excel podcast shows how to do a picture lookup in Excel.
Episode 1172 Episode 1172 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!

Concatenated Lookup? 1171a - Learn Excel from MrExcel

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Episode 1171 Episode 1171 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!

Concatenated Lookup? 1171 - Learn Excel from MrExcel

Another look at Formula Speed in Excel: I have to do a lookup to find both a city and a day. Rather than using a concatenated lookup, two alternative formulas that perfom faster.
Episode 1170 Episode 1170 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!

Microsoft First? 1170 Learn Excel Podcast

Szilvia noted a strange anomoly in Excel 2007 pivot tables. Microsoft started appearing at the top of every customer list! Episode 1170 Episode 1170 takes a look at this mystery and the solution.

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!

MrExcel's Learn Excel #977 - Filtered Paste

Joe asks if there is any way to do a Filtered Paste operation. I can't figure it out, so I had to resort to a macro. Check out Episode 977 and see if you have a better way.

This video is the 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!

Episode 674 - Negative Invert

Ute from Germany sends in a better way to show negative points in a column chart in a red color. His cool trick works for Excel 97-2003. Episode 674 will show 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!

Episode 673 - Custom Numbers

Hamideh sends in an interesting question. He set up a really cool custom number format to prevent people from having to enter 4 dashes in a part number. However... now Find appears not to work. In Episode 673, I will show you the hidden setting to assist with the Find.

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!